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

“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
Can you subtract a date from another date to see how many days late something is, whilst using the weekday function? Here is the function currently have. =IF(OR(ISBLANK(B3),ISBLANK(P3)),"",P3-B3)
Solved by E. E. in 26 mins
=IF(ISBLANK(F3),"",F3-TODAY()) Please help me add another function to this formula, thanks!
Solved by M. L. in 17 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