| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
drag a formula downa column keeping one value the same?
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| keeping same-row(or column) cell constant in a formula while drag- | Excel Worksheet Functions | |||
| Keeping Formula variable constant when adding new column | Excel Discussion (Misc queries) | |||
| How do I drag a formula keeping cells the same but changing sheets | Excel Worksheet Functions | |||
| Keeping the column constant in a formula | Excel Discussion (Misc queries) | |||
| Right Filling A Formula Whilst Keeping A Static Column | Excel Discussion (Misc queries) | |||
Threaded Mode
