Blank cell with Formulas
 

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,

Blank cell with Formulas
 

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.
--
Gary''s Student - gsnu200782


"Lily" wrote:

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,

Blank cell with Formulas
 

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

"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200782


"Lily" wrote:

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,

Blank cell with Formulas
 

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


"Lily" wrote:

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

"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200782


"Lily" wrote:

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,

Blank cell with Formulas
 

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


"Lily" wrote:

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,

Blank cell with Formulas
 

ignore this please. It;s wrong

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

--
Malik


"Malik" wrote:

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


"Lily" wrote:

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

"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200782


"Lily" wrote:

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,