View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sanger sanger is offline
external usenet poster
 
Posts: 3
Default how do i drag a formula

here is the formula I am using =F23/(1+0.04)^(A23-18)

how do I copy or drag the formula down and have it change to

=F23/(1+0.04)^(A23-18) then copy or drag it to change in the rows following
each other
=F24/(1+0.04)^(A24-18)
=F25/(1+0.04)^(A25-18) and so on