| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Divide Column A by Column B multiply Column C
The advantage of having the formulas in cols B and C point to "fixed" cells
(i.e. B1 and C1), instead of hardcoding the values: 65 and 0.07 directly into the formulas, is that we don't have to amend all the formulas should the values(constants) need to be changed in future. We'd just simply change the values in B1 and C1. -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| How do I multiply a whole column by a number? | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| How do I multiply Column G Totals by a number and display the res. | Excel Discussion (Misc queries) | |||
| How can I sort an entire spreadsheet from a list | Excel Worksheet Functions | |||
Threaded Mode
