View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
column formula with a constant value[_2_] column formula with a constant value[_2_] is offline
external usenet poster
 
Posts: 1
Default drag a formula downa column keeping one value the same?

Perfect...Thank you Paul!

"Paul C" wrote:

Change your L30 to a absolute reference $L$30
--
If this helps, please remember to click yes.


"column formula with a constant value" wrote:

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(L3040000,L1*.60,=IF(L30<20000,L1*.5,=IF(L30<4 0000,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!