#Value!   

I have 3 cells in Excel. Cell one has a number say 15, Cell two has a formula 
and Cell three I need to add up cell 1 and 2 except I am receiving an error 
#value! because my formula in cell two can't be read as a number. Is there a 
way to have Excel ignore the formula until it has a number generated from the 
formula?

date: Mon, 8 Sep 2008 08:51:02 -0700   author:   17Wendy

RE: #Value!   

You can add to the formula in cell 3:
=if(iserr(a1+b1),"",a1+b1)
 
Squeaky

"17Wendy" wrote:

> I have 3 cells in Excel. Cell one has a number say 15, Cell two has a formula 
> and Cell three I need to add up cell 1 and 2 except I am receiving an error 
> #value! because my formula in cell two can't be read as a number. Is there a 
> way to have Excel ignore the formula until it has a number generated from the 
> formula?
> 
>

date: Tue, 9 Sep 2008 06:36:01 -0700   author:   Squeaky