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.

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.

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.

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.

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.

Your formula (B17*I17+B17*J17) returns a Value error because I17 or J17 is
blank. When you multiply something by a blank, Excel doesn't know what that
means, so it returns #Value!

First, decide what you want to happen if one of the values is blank. If you
don't want Excel's result (#Value!), what do you want? Zero? Blank?

If you want zero as a result, simply change the double quotes to 0 in your
Vlookup.

If you want blank as a result, put an if statement around your formula, as
in:

=if(or(i17="",j17=""),"",b17*i17+b17*j17)

Of course, the proper solution is to avoid blank values in the first place.
The only time you get blank values is when A17 isn't in your lookup table.
Fix that, and you won't have problems with #Value errors.

Regards,
Fred.

"Morfeo" wrote in message
...
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.

Thank You !!!!!!!!!!!!! 8-)
Your Formula Works Perfectly, it is what i wanted, all this time was worth
it.
you must be an expert.

well, i have a lot of questions still, like how to make reports with this
invoice that i made. but first thank you for this information.


"Fred Smith" wrote:

Your formula (B17*I17+B17*J17) returns a Value error because I17 or J17 is
blank. When you multiply something by a blank, Excel doesn't know what that
means, so it returns #Value!

First, decide what you want to happen if one of the values is blank. If you
don't want Excel's result (#Value!), what do you want? Zero? Blank?

If you want zero as a result, simply change the double quotes to 0 in your
Vlookup.

If you want blank as a result, put an if statement around your formula, as
in:

=if(or(i17="",j17=""),"",b17*i17+b17*j17)

Of course, the proper solution is to avoid blank values in the first place.
The only time you get blank values is when A17 isn't in your lookup table.
Fix that, and you won't have problems with #Value errors.

Regards,
Fred.

"Morfeo" wrote in message
...
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.