“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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