View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Farhad Farhad is offline
external usenet poster
 
Posts: 281
Default 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