hello 8-)

to make it more clear, i will tell you the columns where i have the values
and the formulas, you see:

in colum A i have "item number", in column B i have "quantity", in column c
i have "description" , in column I i have parts price, in column J
i have "labor price" and in column k i have "total line".

and then, in the first line of the description (that would be C17) column i
have the formula:

IF(ISNA(VLOOKUP(A17,info,2,FALSE)),"",(VLOOKUP(A17 ,info,2,FALSE)))

in I17 i have :

IF(ISNA(VLOOKUP(A17,info,3,FALSE)),"",(VLOOKUP(A17 ,info,3,FALSE)))

in J17 i have:

IF(ISNA(VLOOKUP(A17,info,4,FALSE)),"",(VLOOKUP(A17 ,info,4,FALSE)))

and in K17 i have:

B17*I17+B17*J17

and let me tell you, in the item number, the format is as a text, so the
number would be, '0001.

i have that formula because i tryed and it worked, but the formula gives me
the
#value! error, and i would like to know a formula that get rid of that
error, or a procedure.

Sorry Again!



"Fred Smith" wrote:

Apology accepted.

"what i want is the multiplication of quantity times parts price". You will
want something like:
=a1*c1
Adjust the row number to suit your siutation.

"but IF it has a value"
Assuming "it" is parts price, then check for it, as in:
=if(c1="","",a1*c1)

"BUT IF the cell in column labor price has a value, then the multiplicaton
has to be, quantity times labor price". Then check for it too, as in:

=if(j10,j1*a1,if(c1="","",a1*c1))

Regards,
Fred


"Morfeo" wrote in message
...
thank you for answering.
ok, i have item number in column A, quantity, in column B, description in
column C, parts price, in column I, Labor Price in column J and Amount in
column K, what i want is the multiplication of quantity times parts
price,
but IF it has a value, if it doesn't the don't, BUT IF the cell in column
labor price has a value, then the multiplicaton has to be, quantity times
labor price.

Do you know if i can get the result to be blank, because i have everything
in vlookup formula, and everything is in blank. only when i put the item
number it shows everything.

let me apologize if i am annoying.

thx.

"Fred Smith" wrote:

Yes, it's possible. In general, you will want a formula something like:

=if(a1="",0,b1*c1)

If you need more help, post back with information on the cell address and
what you want in each cell.

Regards,
Fred.

"Morfeo" wrote in message
...
hello

i have created an invoice in one sheet in excel, on the invoice i have
this
columns:

item number, quantity, description, parts price, labor, and total
amount.

i put the item number, the quantity, and the description, but now the
problems are the parts price, the labor, and the total amount, because
i
want
in the total amount cell, that multiplies the value on quantity times
the
value on the cell in the colum of parts price, bit "if" it has a value,
if
the labor colum has a value, then the operation has to be quantity
times
the
value of the labor colum.

first my question is if is that possible, then can somebody help me?

it is a matter of work. please help.

thx.