Re: How to get rid of #VALUE! ?

From: Rusty_nl (Rusty_nl.12jg7k_at_excelforum-nospam.com)
Date: 03/03/04


Date: Wed, 3 Mar 2004 04:44:10 -0600

Including an ISERROR in your calculation should do the trick

=IF(ISERROR(C2*D2);0;C2*D2)

Where the 0 can be "" or something else as well

Phoenix wrote:
> *Hi!
>
> I got the price in C2:C100 and Pieces in D2:D100. The Formula in
> E:E100 is C2*D2, C3*D3 etc. But in som of the cells in C2:C100 i have
> to add some text instead of numbers. This, off course, gives the
> formula in column E "#VALUE!"
>
> How can i get rid of "#VALUE!" here, and instead have "0" or just "-"
> in the formulas in column E *

---
Message posted from http://www.ExcelForum.com/