In Excel, I am aware of how to create a named range.
A formula is in the last cell of a spreadsheet that has several columns acting as parameters. Each row has a separate set of data, which is repeated numerous times, and the formula is changed to correspond to the appropriate row index.
However, the formula looks like this (three rows worth):
=G2*(10*D2 + 20*E2 + 5*F2)
=G3*(10*D3 + 20*E3 + 5*F3)
=G4*(10*D4 + 20*E4 + 5*F4)
I would like to use named ranges, but I can't find a way to do something like
=Count * (10*var1 + 20*var2 + 5*var3)
Where count, var1, var2, and var3 are updated automatically to reflect the specific row's column. For each cell, I can make a named range, but that is useless. I am able to name the range in the column, but I am unable to figure out how to include an offset in the calculation.
Additionally, because the entire purpose of this is readability, it probably doesn't help much if the function call turns out to be some horribly convoluted formula.