Devide value by 0 or ""

[Syd]

How can I get a formula to show me the valid value in one
cell if the other cell contains a zero. Example: Cell A1 =
26, cell A2 = 0 or "".

Now to devide cell A1 by A2 will generate a #Div/0! error
in cell A3 =(A1/A2). I'd like to see the value of cell A1
which is 26 in cell A3 and not the ugly #Div/0! error.

Any ideas?

 

[Dave R.]

One way;

if(iserror(a1/a2),a1,(a1/a2))

 

[Paul B]

Syd, here is one way =IF(ISERROR((A1/A2)),A1,(A1/A2))
--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[Robert]

put in cell A3
=IF(ISERROR(A1/A2),A1,A1/A2)

 

[Syd]

Robert:

Thanks you, that is exactly what I was looking for!

It worked!

 

[Aladin Akyurek]

A better idiom would be:

=IF(N(A2),A1/A2,A1)