Nov 23 2017
04:12 AM
- last edited on
Jul 25 2018
10:27 AM
by
TechCommunityAP
Nov 23 2017
04:12 AM
- last edited on
Jul 25 2018
10:27 AM
by
TechCommunityAP
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
Nov 23 2017 05:32 AM
Hi Vincent,
To fix the cell(s) use absolute references instead of relative one (or mix)
Nov 23 2017 06:35 AM
Hi,
Do the following:
After that, the cell references are now absolute and you can copy the formula without changing it.