Get instant live expert help on I need help with excel if blank then 0

“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 need a formula for the following: If E18 equals 0 then E43=E24 If E18 doesn't equal 0 then leave E43 blank
Solved by A. C. in 12 mins
I need an excel formula that does: A5 + G5 = sum. If sum is 0 then leave blank or change the color of 0. Thanks, BB
Solved by S. U. in 15 mins
Edit formula in highlighted cells to account for blank values i.e. if blank, then return 0
Solved by Z. U. in 25 mins
Can you explain why this formula will not work? The logic is if B7=0 then cell is blank if > 0 then OPEN. If cells O, T and Y contain value greater than 0 it changes A7 to closed. Need help please =IF((AND(O7>0,T7>0,Y7>0,B7=0,"",Z7>0)),"OPEN","CLOSED")
Solved by G. B. in 14 mins
I need a formula that says if a cell is 0 or blank then do one thing and if not do another. Example of what I have is: =IF(Y4="",1,SUM(N4-Y4)/N4) It works if Y4 is blank but can I make it say if it is blank or 0?
Solved by G. Q. in 15 mins