Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to Find the Correct Answer-But not using Vlookup Function | Excel Worksheet Functions | |||
Using MATCH function does not return correct answer | Excel Worksheet Functions | |||
MAX Function not returning correct value | Excel Worksheet Functions | |||
Vlookup Function Arguments are correct but nothing in cell | Excel Worksheet Functions | |||
What is the correct function to use, please? | Excel Worksheet Functions |