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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Divide by a value in a varying cell address
I want to help but I have no idea what you have, nor what you want to have.
The explanation you give can be understood by only someone like you, i.e. someone who already knows what you are talking about. Please post back and explain what you have and what you want to do. Use generic terms for every parameter. HTH Otto "cottage6" wrote in message ... 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. |
Reply |
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 |