Re: How to get rid of #VALUE! ?
From: Rusty_nl (Rusty_nl.12jg7k_at_excelforum-nospam.com)
Date: Wed, 3 Mar 2004 04:44:10 -0600
Including an ISERROR in your calculation should do the trick
Where the 0 can be "" or something else as well
> 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/