Forum Discussion
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 this formula in several lines but at each line the reference cell also changes.
here is the first command line:
=SI (J2=1; Points! C3; SI (J2=2; SI (J2=2; Points! C4; SI (J2=3; Points! C5; SI (J2=4; Points! C6; SI (J2=5; Points! C7; SI (J2=6; Points! C8; SI (J2=7; Points! C9; SI (J2=8; Points! C10; SI (J2=9; Points! C11; SI (J2=9); SI (J2=8)
and when I copy it to a lower line:
=SI (J3=1; Points! C4; SI (J3=2; Points! C5; SI (J3=3; Points! C6; SI (J3=4; Points! C7; SI (J3=5; Points! C8; SI (J3=6; Points! C9; SI (J3=7; Points! C10; SI (J3=8; Points! C11; SI (J3=9; Points! C12; SI (J3)
I'd like to block the formula without this cell shift.
thanks in advance
2 Replies
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.
Hi Vincent,
To fix the cell(s) use absolute references instead of relative one (or mix)
