Blank cell with Formulas

[Lily]

I have a series of cells filld with formulas, but the value of the cells is
null.

I then in some other cells used if function, which will evaluate the above
cells, and if the value of the above is null then output something like "-",
otherwise some real numbers. However, when the reference cell values are
blank, excel continuously gives me error messages. I wonder if it's the
formulas underlying those cells are screwing everything up. And if yes, is
there a fix to this?

thanks,

 

[Gary''s Student]

Here is an example that will work. If B9 contains:

=IF(1=1,"","")

it will always return a null. Therefore another cell that contains:

=IF(B9="","-","") will always return a dash. It will return a dash even if
B9 is completely empty.

 

[Lily]

Here is my situation,

In cell A1, =if(b1=a+b, 1, ""), and A1 returned "".
In cell c1, =if(a1="", "-", 1)

what I got is #value! instead of "-".

Any ideas?

Lily

 

[Malik]

=IF(ISERROR(IF(B1=A+B, 1, "")),"",1)
--
Malik

Here is my situation,

In cell A1, =if(b1=a+b, 1, ""), and A1 returned "".
In cell c1, =if(a1="", "-", 1)

what I got is #value! instead of "-".

Any ideas?

Lily

 

[Malik]

=IF(ISNA(F19),"-",IF(ISERROR(F19),"-",F19))

 

[Malik]

ignore this please. It;s wrong

Instead:
=IF(ISERROR(B1=a+b),"",IF(B1=a+b,1,""))