| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how can i calculate formulas automatically
I have a worksheet with three columns. Col1 is item, Col2 is price and Col3
is quantity. I need a column 4 that calculates col2 * col3 and displays total. I tried formulas, but i need the total to be displayed automatically whenever i navigate to that column after entering col 2 and col 3. I dont want to drag the formula manually to se the results. It should be like pure forms. Any advice? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Suddenly cannot calculate functions or formulas in Excel | Excel Worksheet Functions | |||
| Automatically 'incrementing' formulas for new rows. | New Users to Excel | |||
| How Excel & ACCPAC 6.1 calculate formulas???? | Excel Worksheet Functions | |||
| Calculate formulas with feet & inches | Excel Worksheet Functions | |||
| How do I automatically calculate ages in Xcel? | Excel Discussion (Misc queries) | |||
Threaded Mode
