+ Reply to Thread
Results 1 to 2 of 2

How to select preceeding cell in a formula?

  1. #1
    Dennis
    Guest

    How to select preceeding cell in a formula?

    I need to replicate a formula down a column, where each cell is the value of
    the preceeding cell (directly above it) + 1. I have no idea how to do this,
    being new to Excel. Any ideas would be really helpful.

    Thanks!

  2. #2
    Forum Contributor
    Join Date
    08-02-2005
    Posts
    102
    Dennis,

    I hope that this is no more difficult than it seems:

    If you have the number 50 in cell B3 and write the formula that follows in cell B4: =b3+1, the result should be 51. If you then copy this formula into cell b5, the answer should be 52 and so on.

    Is this what you're after?

    Jon

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1