The formula = F1/F266. As i drag this along I get F2/F267. What i need is for F266 to remain the same with only the first cell changing (F2/F266)
Quick Excel help
Started by
bhr
, Apr 09 2007 04:01 AM
#1
Posted 09 April 2007 - 04:01 AM
The formula = F1/F266. As i drag this along I get F2/F267. What i need is for F266 to remain the same with only the first cell changing (F2/F266)
#2
Posted 09 April 2007 - 08:53 AM
make the forumula =F1/$F$266
if you put a $ before a portion of the formula...like a cell reference...then it will stay the same when you copy the formula down...instead of changing to reflect the new formula locatioin
if you put a $ before a portion of the formula...like a cell reference...then it will stay the same when you copy the formula down...instead of changing to reflect the new formula locatioin
Similar Topics
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users