| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MOD Columns / INDIRECT.. for x3 columns?
hi, trying to be able to modify a formula, to pick the number of columns
desired for a calculation. examples below are for 3 columns, would range from 2-10 columns. =IF(K9=0,"",((ED9/EE9%)+(EE9/EF9%)+(EF9/EG9%))-300) is a percent change formula: fm/to%-100 got some help with: =IF(K9=0,"",SUMPRODUCT(ED9:EF9/EE9:EG9%-100)) would I use INDIRECT, MOD.. think would prefer a multplication? for external entry in one fixed cell, e.g.: 3 (as above). thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INDEX("a"&COLUMNS(INDIRECT(A1):INDIRECT(A2)):A30,4) | Excel Discussion (Misc queries) | |||
| to convert columns to rows having mulit independent group columns | Excel Worksheet Functions | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Looking at several columns with Indirect | Excel Worksheet Functions | |||
Threaded Mode
