View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default how do i make a formula to multiply two values?

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.