Replacing #VALUE! error with an empty cell

=IFISERROR(your_formula,"",your_formula)

HTH

Jason

hmm, got this =IFISERROR(SUM(E9*F9),"",SUM(E9*F9)) comes up with 'NAME! error

I see two things here. First, you did not use a parenthesis after IF or a second set of closing parenthesis before the double quotes. Second, when multiplying, you do not need to use the SUM function. Use this revised formula:

=IF(ISERROR(E9*F9),"",E9*F9)

HTH

Jason

Try this:
=IF(ISERROR(your_formula),"",your_formula)

And another detail in your formula is that you don't need the SUM formula as you are not summing anything. The SUM formula should not give you any trouble if you for some reason like to put it there.

=SUM(A1*A2) is the same as =A1*A2

cheers guys

Ok, I see how you messed up your formula. It was because I TOLD YOU THE WRONG FORMULA! LOL! Sorry about that. Glad you have it figured out.

Jason