=IF(ISNA(YourFormula),0,YourFormula)

--
Kind regards,

Niek Otten

"phill" wrote in message ...
| hi
|
| I have an invoice that i have designed in excel an have a vlookup value so
| that when i select a material from a drop down list it automatically puts the
| correct price in another cell. however if there is no materials in one of
| the cells it presents a "value not available error" and puts N/A in the cost
| cell. this in turn then messes up the calculations for adding up the
| matterial costs and VAT. Is there anyway of making it dissapear or making it
| say 0 if there are no materials entered in any of the material cells boxes?
|
| many thanks