 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008I 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 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) > How do you have your spreadsheet automatically update the total amount > when [quoted text clipped - 5 lines] > > 2 1.99 3.98 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.