Get instant live expert help on I need help with excel formula if cell is 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 to create a conditional format formula. If my value is between 1.-3 and -1.3 turn green. if my cell is blank or value is 0 then leave cell blank.
Solved by B. D. in 23 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
I need a formula that will average cells e3:h3 if the cell is greater than 0 if not then leave it blank
Solved by G. Q. in 25 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
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