If statement cannot return a real blank space

[labogola]

Hi,

I have a column of cells with the following formula:

Cell F7:

=IF(E7<7*500,7*700-E7,"")

Basically this is checking if a balance is below 7*500, if it is the cell will return 7*700-E7 (it is filling up an account).

I then have another column (H) which will add the above corresponding cell to itself, i.e. H7 is

=NUMBERS+F7

When my if statement in F7 returns a blank ," ", I get a #VALUE! error in my H7 cell. If I set the blank to be a "0" instead

=IF(E7<7*500,7*700-E7,"0")

everything works.

How can I make the F7 cell treat the blank in the if statement as a 0, without actually having the F column show 0's?

Thank you!

[Domski]

You could use =IF(E7<7*500,7*700-E7,0)

And then format the cell not to display anything for zero values.

Dom

[martindwilson]

use =sum(NUMBERS,F7) instead it ignores ""

[labogola]

Hey, thanks so much Domski and and Martindwilson.

I've tried sum, but it doesn't work as the cells still returns a #VALUE! error if the IF statement returns a blank "".

Domski that works, but I'm trying to get the cells blank because they are checked by a script for their values.

[labogola]

Okay I've found a fix:

=NUMBERS+IF(ISNUMBER(F7),F7,0)