Change variable horizontally in excel formula

Question

I want to change a variable in an excel formula horizontally and maintain one variable constant.

O3/$C18, P3/$C18, Q3/$C18

I can keep the the bottom variable constant by using the $ symbol but when I want to extend the formula to additional cells, the top variable does not change horizontally, rather vertically.

Thank you for your help. Cheers

Answer 1

The dollar signs in excel "fix" the item to their right

$C18

means C will always be fixed, and 18 can change

C$18 means C can change, but 18 is always fixed.

$C$18 means C is fixed and 18 is fixed (ie always use C18 no matter what direction you drag the cell)

I dont fully understand what you want to do but hopefully the above will help

based on the comments below i think i understand what you mean

try a formula like this

=INDIRECT(ADDRESS(1,ROW()))/$C$18

here address takes the row and column, so row = 1 and column = which ever row you are on (so row1 = A, row2=B etc)

then indirect lets you use that as a reference point

Hope that works