I need the correct function or formula...

C

Crystal

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

...example

amount ordered price total

2 1.99 3.98
 
R

Ron Coderre

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)
 
Top