# 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