#DIV/0! Query

[Brento]

HI,

I have a formula that is just =a13 in cell a1, however, if a13'
formula returns a div/0 answer is there any way we can either return
value of 0 in a1 or leave a1 blank?

thanks in advance

Brent

 

[Niek Otten]

=IF(ISERROR(A13),"",A13)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| HI,
|
| I have a formula that is just =a13 in cell a1, however, if a13's
| formula returns a div/0 answer is there any way we can either return a
| value of 0 in a1 or leave a1 blank?
|
| thanks in advance
|
| Brento
|
|
| --
| Brento
| ------------------------------------------------------------------------
| Brento's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25213
| View this thread: http://www.excelforum.com/showthread.php?threadid=571002
|

 

[Guest]

=IF(ISERROR(A13),0,A13)