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

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