Get instant live expert help on I need help with excel vba isblank

“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

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