Copying formula
Posted by Jon Swanson on February 13, 2002 2:24 PM
I need to Copy this formula down a column:
=(J134 < 1000)*B9+(J134 >= 1000)*(J134 < 2500)*'Level 1'!B9+(J134 >= 2500)*(J134 < 6000)*'Level 2'!B9+(J134 >= 6000)*(J134 < 12500)*'Level 3'!B9+(J134 >= 12500)*(J134 < 20000)*'Level 4'!B9+(J134 >=20000)*'Level 5'!B9
But I do not want the J134 link to change, everything else should change accordingly, got any ideas...Thanks
Posted by Aladin Akyurek on February 13, 2002 2:26 PM
Freeze J134, i.e.: $J$34 [NT]
Posted by Aladin Akyurek on February 13, 2002 2:27 PM
Typo fix: $J$134 [NT]
