Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting cells
Hi I dont know much about excel, but i am trying to use it to calculate my
inventory. How do I make for example cell C (price per unit) multiplied by cell D (amount of units in stock) to equal cell E (total $ amount of units)? Step by step instructions would be greatly appreciated. Thanks so Much |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting cells
Hi,
Go to cell E1 and enter the formula below in the cell =ROUND(C1*D1,2) you can copy down this formula from the cell E1 to where ever you want. Thanks, -- Farhad Hodjat "Gen Needs Help" wrote: Hi I dont know much about excel, but i am trying to use it to calculate my inventory. How do I make for example cell C (price per unit) multiplied by cell D (amount of units in stock) to equal cell E (total $ amount of units)? Step by step instructions would be greatly appreciated. Thanks so Much |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Cells | Excel Discussion (Misc queries) | |||
Formatting Cells | Excel Discussion (Misc queries) | |||
Conditional Formatting Multiple cells based on 2 cells | Excel Worksheet Functions | |||
FORMATTING CELLS | Excel Worksheet Functions | |||
Formatting cells | Excel Worksheet Functions |