#VALUE! - Error

Kmtravel · Mar 10, 2010

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 · Mar 10, 2010

Try this...

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

ck · Mar 10, 2010

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

Kmtravel · Mar 11, 2010

Perfect - thank you very much!!

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

#VALUE! - Error

Kmtravel

T. Valko

ck

Kmtravel