C
column formula with a constant value
I need to drag a formula down a column, but keep one value constant (when I
drag the formula down, the values in the formula change according to the row,
but I need to keep one constant so each cell's formula refers to one specific
cell.)
Ex. - =IF(L30>40000,L1*.60,=IF(L30<20000,L1*.5,=IF(L30<40000,L1*.55,0)))
I need to keep the L30 values the same, while the L1 changes for each row,
but when I drag this formula down the column, the L30 changes.
Thanks!
drag the formula down, the values in the formula change according to the row,
but I need to keep one constant so each cell's formula refers to one specific
cell.)
Ex. - =IF(L30>40000,L1*.60,=IF(L30<20000,L1*.5,=IF(L30<40000,L1*.55,0)))
I need to keep the L30 values the same, while the L1 changes for each row,
but when I drag this formula down the column, the L30 changes.
Thanks!