Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Divide by a value in a varying cell address
Hi all,
Once again I need help, help, and more help! I have a spreadsheet which has "indicators" in Col. C, which could be 512, 513, 515, or 525. A store could have anywhere from all four to only one of the indicators, and each indicator has a corresponding amount. Indicator 910 is a total line with an amount. In Column G, each indicator should have a formula dividing the indicator amount by the total amount. Since I can't count on the fact the 910 total row will always be 4 rows from the 512 row, how can I create the macro so the indicator is being divided by the correct 910 total cell? I can do this with nested IFs, but I know there's a better way and I'd like to know so I can learn more. TIA, and for all the help so far. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can th same spreadsheet have varying cell sizes top & bottom | Excel Discussion (Misc queries) | |||
varying a cell and seeing the outcome | Excel Worksheet Functions | |||
in excel, can i set varying CELL widths that are in same column? | Excel Worksheet Functions | |||
Divide one row over other row I dont wont to divide one number | Excel Discussion (Misc queries) | |||
Divide Expression stops in Macro when Can't divide | Excel Programming |