Get rid of #value!
 

In calculating commissions, I come accross #value! message when certain
criterias are not met. I want to replace this sign with 0. How do I do
this? Becuase this error message is in the middle, the bottom line
figures are not correct. Help


--
Ash

Get rid of #value!
 

Ash

You could replace your formula with something like this

=IF(ISERROR(your formula),"",your formula)

Does this help?

Dave

"Ash" wrote in message
...

In calculating commissions, I come accross #value! message when certain
criterias are not met. I want to replace this sign with 0. How do I do
this? Becuase this error message is in the middle, the bottom line
figures are not correct. Help


--
Ash