Please help me writing this simple formula

  • Thread starter Thread starter John
  • Start date Start date
J

John

How can you look up for data in a particular cell and freeze that cell
while draging the formula to other cells. In need for example A2 and
A11 remain the same while I am copying this formula to other cells.
The problem is when I am copying this formula A2 and A11 will change
to A3 and A12

=IF(C2=A2,TIME(10,30,0)+(D2-1)*A11)


Thank you very much for your help


John
 
make cells A2 and A11 absolute instead of relative. edit the formula so A2 looks like $A$2. do the same for A11
 
or at least row absolute

=IF(C2=A$2,TIME(10,30,0)+(D2-1)*A$11)


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Blazer Bob said:
make cells A2 and A11 absolute instead of relative. edit the formula so
Click to expand...
A2 looks like $A$2. do the same for A11
 
Back
Top