LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 24
Default how do i make a formula to multiply two values?

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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make a formula automatically detect changes in values LMoore Excel Worksheet Functions 1 March 28th 07 04:44 PM
Adding values within multiply columns Scott@CW Excel Discussion (Misc queries) 4 January 16th 07 08:54 PM
multiply all values in all cells by a factor [email protected] Excel Discussion (Misc queries) 1 March 14th 06 09:51 PM
Multiply all values by 10 RTimberlake Excel Discussion (Misc queries) 4 December 27th 05 07:58 PM
Multiply one cell by a factor and make that result round Machel_C Excel Worksheet Functions 7 March 15th 05 08:04 PM


All times are GMT +1. The time now is 01:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"