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

=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