#VALUE! - Error
 

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

#VALUE! - Error
 

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

#VALUE! - Error
 

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

"Kmtravel" wrote:

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

#VALUE! - Error
 

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.
--
David Biddulph


"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

#VALUE! - Error
 

Perfect - thank you very much!!

"ck" wrote:

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

"Kmtravel" wrote:

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