Help

--------------------------------------------------------------------------------

I am making up a invioce and am having a problem when it comes to the last cell that does the total of the product price, The following is the template that I made.

Cell A1 Quanity (Manually entered)

Cell B1 Product Code (Manually Entered)

Cell C1 Lookup Product Description =IF(ISNA(VLOOKUP(B1,$K$8:$M$60,2,)),"",VLOOKUP(B1, $K$8:$M$60,2,)) Cells K8:M60 Is the lookup table

Cell D1 Lookup Product Price =IF(ISNA(VLOOKUP(B1,$K$8:$M$60,3,)),"",VLOOKUP(B1, $K$8:$M$60,3,))

Cell E1 Total Price =sum(A1*D1)

When I do the last cell (CellE1) if I do not have a quanity number in cell A1 it comes up with the error code of #VALUE. It seems to be looking at th formula

I had a simular problem with the lookup funtion and had to add the IR(ISNA) to correct the error

Thanks in advance for any help

Hi Marvin,

=IF(A1="","",A1*D1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"marvin" wrote in message ...
|
| Help
|
| --------------------------------------------------------------------------------
|
| I am making up a invioce and am having a problem when it comes to the
| last cell that does the total of the product price, The following is
| the template that I made.
|
| Cell A1 Quanity (Manually entered)
|
| Cell B1 Product Code (Manually Entered)
|
| Cell C1 Lookup Product Description
| =IF(ISNA(VLOOKUP(B1,$K$8:$M$60,2,)),"",VLOOKUP(B1, $K$8:$M$60,2,))
| Cells K8:M60 Is the lookup table
|
| Cell D1 Lookup Product Price
| =IF(ISNA(VLOOKUP(B1,$K$8:$M$60,3,)),"",VLOOKUP(B1, $K$8:$M$60,3,))
|
| Cell E1 Total Price =sum(A1*D1)
|
| When I do the last cell (CellE1) if I do not have a quanity number in
| cell A1 it comes up with the error code of #VALUE. It seems to be
| looking at th formula
|
| I had a simular problem with the lookup funtion and had to add the
| IR(ISNA) to correct the error
|
| Thanks in advance for any help
|
|
|
|
| --
| marvin

Thank you very much Niek Otten