ommiting value not available error

[Guest]

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

 

[Niek Otten]

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

--
Kind regards,

Niek Otten

| 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

 

[Guest]

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]

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

--
Kind regards,

Niek Otten

| 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
| >
| > | 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
| >
| >
| >