MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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]