Get instant live expert help on if blank then 0
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
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 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 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
I'm trying to develop the formula to accomplish this computation but keep getting an error of one kind or another. Can you help? Dealing with columns C,D,E,F(a blank column),G,&H: 1. C will never be blank 2. Value of E: =IF,D=0,"",D-C (no problem) 3. Value of H: =IF D=0 and G=0 then H will be blank but IF D=0 and G<>0 then H will be G-D
Solved by X. W. in 17 mins