Get instant live expert help on I need help with excel if zero then blank
“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
IF SUM OF RANGE IS MORE THAN ZERO,THEN SUM IF THE RANGE IS BLANK THEN BLANK IF THE RANGE HAS ONLY ZERO,THEN ZERO HOW SHALL I COMBINE THE ABOVE THREE IN A SINGLE CELL??
Solved by M. D. in 24 mins
1. Subtract N2-I2, but if column I is blank, then subtract N2-G2 2. If the value of the above is a negative number, then set value to zero
Solved by X. W. in 13 mins
I have two spreadsheets, A and B. I enter an = in A1 then reference cell A1in spreadsheet A, which is blank. Instead of leaving A1 on spreadsheet B, it enters a zero. How do I get it to return blank instead of zero?
Solved by K. H. in 20 mins
HOW CAN I HAVE A =IF FORMULA SHOW A BLANK VERSES A ZERO? IE =IF(E3>1,E3*,25, ()0
Solved by G. L. in 18 mins
I need to write if S is blank then T but if not blank then S
Solved by V. U. in 15 mins