Get rid of #value!

A

Ash

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
 
D

Dave

Ash

You could replace your formula with something like this

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

Does this help?

Dave
 
Top