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,

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,

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,

=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,

=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,

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,