 # 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