Using variables in formulas

Copper Contributor

I have a couple variables that I need to use in multiple calculations for a table. Say one of them is in cell d8. I will need to change it from time to time. I can set up the initial formula, but when I try to paste to next line the cell number changes to d9, etc. Is there any way to be able to copy this specific cell to multiple line items without having to edit each one?


This table has 120 lines, five calculations, and three variables. so editing it item by item is tedious and would take me hours. 

3 Replies
best response confirmed by Hans Vogelaar (MVP)


Try to use absolute reference in formula, i.e. to fix the column use $D8 instead of D8

@Sergei Baklan Thank you. That worked and was just what I needed. 

@EZepp , you are welcome