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

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