#VALUE! - Error

[Kmtravel]

I'm trying to get a percentage from the following formula c10/b10-1, the
problem i'm facing is that c/10 & b10 are zero value - I just want to make it
0%.

Any options? Thank you

 

[T. Valko]

Try this...

=IF(OR(B10=0,C10=0),0,C10/B10-1)

 

[ck]

see if this works
=IF(ISERROR(C10/B10-1),0,C10/B10-1)

 

[David Biddulph]

Zero values don't give a #VALUE! error in that formula. C10 zero would give
an answer of -1, B10 zero would give a #DIV/0! Either of those can be
trapped for.
A #VALUE! error would come if you have text in B10 and/or C10.

 

[Kmtravel]

Perfect - thank you very much!!

see if this works
=IF(ISERROR(C10/B10-1),0,C10/B10-1)