options in excel to calculate certain fields for 10, 15 or 2
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: options in excel to calculate certain fields for 10, 15 or 2

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I am trying to have an option in the model to calculate the certain fields for 10, or 15, or 20 years.

    What are the options in Excel to be able to do it.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can you explain a little further ? not sure what you mean.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Sydney/Brisbane , Australia
    Posts
    538
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    try a sumif function

  4. #4
    . MrExcel's Avatar
    Join Date
    Feb 2002
    Location
    Merritt Island Florida
    Posts
    858
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try an OFFSET function.
    View a collection of recent Excel articles in the Excel Daily News

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-17 17:48, lsmoly wrote:
    I am trying to have an option in the model to calculate the certain fields for 10, or 15, or 20 years.

    What are the options in Excel to be able to do it.
    Okay, here's my guess...

    I believe you're describing a one or two-input data table.

    For example, a 1-input table to project future values would produce...

    {10,45000
    ;15,67500
    ;20,90000}

    ...in cells A2:B4 using the formula, =TREND({0,4500},{0,1},MAX(0,D1)), in B1 and specify cell D1 as the column input cell using the Data | Table... menu command.

    [ This Message was edited by: Mark W. on 2002-04-18 11:46 ]

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Use scenarios. Gotta be.

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
  •  

 

 
DMCA.com