Get instant live expert help on isblank excel formula

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

=IF(OR(ISBLANK(E25),ISBLANK(F25),ISBLANK(G25)),"",E25*F25*G25) I have this formula in cell I25 =IF(OR(ISBLANK(I25),ISBLANK($K$3)),"",I25*$K$3) And this in cell K25 and when cell I25 is blank I have a #VALUE! in cellK25
Solved by K. J. in 26 mins
=IF(ISBLANK(Dec!C163),IF(ISBLANK(Nov!C163),IF(ISBLANK(Oct!C163),IF(ISBLANK(Sep!C163),IF(ISBLANK(Aug!C163),IF(ISBLANK(Jul!C163),IF(ISBLANK(Jun!C163),IF(ISBLANK(May!C163),IF(ISBLANK(Apr!C163),IF(ISBLANK(Mar!C163),IF(ISBLANK(Feb!C163), Jan!C163),Feb!C163),Mar!C163),Apr!C163),Jun!C163),July!C163),Aug!C163),Sep!C163),Oct!C163),Nov!C163),Dec!C163) Is not working....
Solved by A. F. in 26 mins
=IF(ISBLANK(Dec!C163),IF(ISBLANK(Nov!C163),IF(ISBLANK(Oct!C163),IF(ISBLANK(Sep!C163),IF(ISBLANK(Aug!C163),IF(ISBLANK(July!C163),IF(ISBLANK(Jun!C163),IF(ISBLANK(May!C163),IF(ISBLANK(Apr!C163),IF(ISBLANK(Mar!C163),IF(ISBLANK(Feb!C163), Jan!C163),Feb!C163),Mar!C163),Apr!C163),Jun!C163),July!C163),Aug!C163),Sep!C163),Oct!C163),Nov!C163),Dec!C163) This formula is in a YTD sheet and I want the cell to update with the data in the most recent month's cell. If I input data in Jan and Feb, it is returning FALSE. But if I put data in Jan and Dec, it is returning the Dec value. I want it to return the value in the latest month's cell.
Solved by O. D. in 18 mins
I have a problem regarding to Excel ISBLANK Function
Solved by A. C. in 30 mins
I'm trying to create nested if/then statements for a budget spreadsheet. Here is the logic: Budgeted, Credited, Debited B=E C=F D=G If B=$ and C=$, then C-D If B=$ and C=0, then B-D If B=0 and C=$, then C-D If B=0 and C=0, D I've written this for caluation starting with column E: =IF(AND(ISBLANK($E2)=FALSE, ISBLANK($F2)=FALSE),($F2-$G2), IF(AND(ISBLANK($E2)=FALSE, ISBLANK($F2)=TRUE),$E2-$G2, IF(AND(ISBLANK($E2)=TRUE, ISBLANK($F2)=FALSE),$F2-$G2, IF(AND(ISBLANK($E2)=TRUE, ISBLANK($F2)=TRUE),$G2)))) I keep getting an 0 (wrong answer) when E is false and F is true.
Solved by M. J. in 25 mins