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!”
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