LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Dragging Formulas

When i drag a formula down a column in excel it does not stay
consistant. I've inputted the following into Cells A100 - A102

in Cell A100: =A1
in Cell A101 = A5
in Cell A102 = A9

When i drag this formula down, i expect Cell A103 to reflect: =A13

However, it actually reflects: =A4

I understand why it is doing this, but how can i make it so the
formula stays consistant?
Cell A103 should reflect: =A13
Cell A104 should reflect: =A17
Cell A105 should reflect: =A21

Any help is appreciated

Thank you,

Jason

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dragging formulas Ben Greenwood Excel Worksheet Functions 7 July 12th 07 06:04 PM
Dragging Formulas J.D. Webster Excel Discussion (Misc queries) 1 February 6th 06 09:32 PM
dragging formulas rmarks Excel Discussion (Misc queries) 5 November 18th 05 11:44 PM
Dragging formulas matt Excel Worksheet Functions 1 December 12th 04 12:27 AM
Dragging formulas matt Excel Worksheet Functions 0 December 11th 04 11:51 PM


All times are GMT +1. The time now is 03:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"