formatting cells

  • Thread starter Thread starter Gen Needs Help
  • Start date Start date
G

Gen Needs Help

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
 
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,
 
Back
Top