Try this...

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

--
Biff
Microsoft Excel MVP


"Kmtravel" wrote in message
...
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