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

“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 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
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
Edit formula in highlighted cells to account for blank values i.e. if blank, then return 0
Solved by Z. U. in 25 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
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