if is error and #DIV/O!
 

Hello this is my original formula =(A1-B1)/A1. This is Ok except that
sometimes I get #DIV/0!. so I tried to fix the formula to this
=IF(ISERROR(A1-B1)/A1,"",(A1-B1)/A1).. What I'm I missing? thanks in
advance

if is error and #DIV/O!
 

You are missing a set of parenthesis

=IF(ISERROR((A1-B1)/A1),"",(A1-B1)/A1)




--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Wanna Learn" wrote in message
...
Hello this is my original formula =(A1-B1)/A1. This is Ok except that
sometimes I get #DIV/0!. so I tried to fix the formula to this
=IF(ISERROR(A1-B1)/A1,"",(A1-B1)/A1).. What I'm I missing? thanks in
advance

if is error and #DIV/O!
 

Try this

=IF(A1<0,(A1-B1)/A1,"")

Mike

"Wanna Learn" wrote:

Hello this is my original formula =(A1-B1)/A1. This is Ok except that
sometimes I get #DIV/0!. so I tried to fix the formula to this
=IF(ISERROR(A1-B1)/A1,"",(A1-B1)/A1).. What I'm I missing? thanks in
advance

if is error and #DIV/O!
 

Firstly the parameter which you have supplied to ISERROR is (A1-B1), but I
guess that you aren't getting an error on the subtraction.
The error you are looking for is in the division, so the parameter for
ISERROR should be ((A1-B1)/A1), so the formula then becomes:
=IF(ISERROR((A1-B1)/A1),"",(A1-B1)/A1)

Secondly, with the use of ISERROR you might hide other errors which you
ought to investigate separately, so you would be better just trapping for
the specific #DIV/0! error, so why not use:
=IF(A1=0,"",(A1-B1)/A1)
--
David Biddulph

"Wanna Learn" wrote in message
...
Hello this is my original formula =(A1-B1)/A1. This is Ok except that
sometimes I get #DIV/0!. so I tried to fix the formula to this
=IF(ISERROR(A1-B1)/A1,"",(A1-B1)/A1).. What I'm I missing? thanks in
advance

if is error and #DIV/O!
 

=IF(A1=0,"",IF(ISERROR(A1-B1)/A1,"",(A1-B1)/A1))
--
Regards.
Daniel
"Wanna Learn" a écrit dans le message
de news: ...
Hello this is my original formula =(A1-B1)/A1. This is Ok except that
sometimes I get #DIV/0!. so I tried to fix the formula to this
=IF(ISERROR(A1-B1)/A1,"",(A1-B1)/A1).. What I'm I missing? thanks in
advance