Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Can do this without Macros?

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Rochetser, NY
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Below is an example of my spreadsheet.

    Time 0 months (time required for profits to be earned)
    Month 1 2 3 4 5 6 7 8 9 10 11 12
    Profits($)10 20 30 40 50 60 70 80 90 100 110 120 (Profit #s are made-up, what if the numbers have no pattern and random)

    My situation is as follows:
    The profits depends of Time. If it is 5 months, then all the profits will be ****ed 5 months later; $10 would be appear under Month 6 and so on. Changing the # of Months will automatically shift the profits back and forth. What formula or tricks should I use to attain this. I tried using the IF function but it's too tedious and wasn't successful as it only allows 7 levels whereas there are 12 months(13 possibilities) in a year. Any advise would be great.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Please refer to this post as this has been posted twice.


    Cheers

    http://www.mrexcel.com/board/viewtop...1947&forum=2&3
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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