With
A2: (quantity)
B2: (price)
C2: =A2*B2
or...if you don't want zeros displayed for empty rows...
C2: =IF(A2<0,A2*B2,"")
....and if you want to get a bit fancy...
See Debra Dalgleish's instructions for building an Order Form:
http://www.contextures.com/xlOrderForm01.html
Does that help?
Post back if you have more questions.
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
"Crystal" wrote in message
...
How do you have your spreadsheet automatically update the total amount
when
changing values...
..example
amount ordered price total
2 1.99 3.98