#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)

 

[Kmtravel]

Perfect - thank you very much!!

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