I need the correct function or formula...
 

How do you have your spreadsheet automatically update the total amount when
changing values...

...example

amount ordered price total

2 1.99 3.98

I need the correct function or formula...
 

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