Forum Discussion
vincent.moracchini
Nov 23, 2017Copper Contributor
Use SI Formula
Good morning, everyone, I use the SI function for a point calculation based on a result. the cell referring to the computation string is on another sheet of the workbook (Points). I want to copy thi...
Haytham Amairah
Nov 23, 2017Silver Contributor
Hi,
Do the following:
- Go to the formula.
- Double click on each cell reference and press F4, so you get a dollar sign before each part of the cell reference like this: $J$2
- Press Enter.
After that, the cell references are now absolute and you can copy the formula without changing it.