I'm trying to create an autocalculating spreadsheet and would like to use the fill down/right option with a fixed cell (or cells).
Given the following spreadsheet:
* A B C D...
1 W X Y Z
2 I J K L
3 M N O P
...
I have a formula defined in C2 referring to values in A2, B2, & C1 so it's something like: K = f(I) + f(J) + f(Y) where f is some function.
When I do a fill down, the formula becomes O = f(M) + f(N) + f(K).
Instead, I want it to be O = f(M) + f(N) + f(Y).
I also want the same behavior for column D, except the constant cell should be cell Z.
I know that there is an array grouping feature, but I can't seem to get the formulas to trickle down and right properly. Any insight would be appreciated.
Given the following spreadsheet:
* A B C D...
1 W X Y Z
2 I J K L
3 M N O P
...
I have a formula defined in C2 referring to values in A2, B2, & C1 so it's something like: K = f(I) + f(J) + f(Y) where f is some function.
When I do a fill down, the formula becomes O = f(M) + f(N) + f(K).
Instead, I want it to be O = f(M) + f(N) + f(Y).
I also want the same behavior for column D, except the constant cell should be cell Z.
I know that there is an array grouping feature, but I can't seem to get the formulas to trickle down and right properly. Any insight would be appreciated.
