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

I have a problem regarding to Excel ISBLANK Function

Solved by A. C. in 30 mins

=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

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

Would like to convert this to grams please: =IF(OR(ISBLANK(D34),ISBLANK(E34)),"",E34*(D34/IF($L$18="Imperial",16,1000)))

Solved by A. L. in 30 mins

=IF(OR(ISBLANK(D5),ISBLANK(F5),ISBLANK(H5),ISBLANK(I5)),"",(D5+F5+H5)) This is the equation im trying to use but i keep getting a #VALUE in I5 unless d5,f5,h5 are filled in. I need to to just show 0 if nothing has been filled in yet

Solved by E. F. in 13 mins