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

=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

HI ME AGAIN

THANKS FOR YOUR REPLY IT WORKED FINE. CAN I GET IT TO DISPLAY A BLANK CELL
AND NOT ZEROS INSTEAD?

"Niek Otten" wrote:

=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

=IF(ISNA(YourFormula),"",YourFormula)

--
Kind regards,

Niek Otten

"phill" wrote in message ...
| HI ME AGAIN
|
| THANKS FOR YOUR REPLY IT WORKED FINE. CAN I GET IT TO DISPLAY A BLANK CELL
| AND NOT ZEROS INSTEAD?
|
| "Niek Otten" wrote:
|
| =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
|
|
|