drag a formula downa column keeping one value the same?

  • Thread starter column formula with a constant value
  • Start date
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct where cell values are the same in a sorted column 1
keeping same-row(or column) cell constant in a formula while drag- 1
Try to be more precise 4
Click and drag a formula 2
Formula constants? 2
Dragging a formula in a column 1
using the =page! feature to transpose a row to column 0
How do I increment the row and column of a cell in a formula? 2

Top