+ Reply to Thread
Results 1 to 2 of 2

Formula for Glide path

  1. #1
    Forum Contributor
    Join Date
    03-23-2015
    Location
    Manila, Philippines
    MS-Off Ver
    2016
    Posts
    201

    Formula for Glide path

    Hi Experts,

    I would like to ask for help on my formula. I have been looking all over the net and couldn't find anything.
    I have the current scores. The green part are the month on month TARGET to get to 60.
    The rising target to 60 should be increasing based on the YTD Scores.
    It should have an equal distribution in terms of the increment.
    The idea of this tool is we can plug any YTD Scores and it will auto populate the increasing targets. It's like a Score Calculator.
    Please see attached to play around.
    If anyone can share a formula on how to do this I would really appreciate it.
    Test Image.PNG
    Attached Files Attached Files

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,836

    Re: Formula for Glide path

    What are the desired results? (the description is not clear to me).
    May be B2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and copy right/down to whole green range? It will result in linear change of values from starting value to month 6. so:
    -100 -73.33 -46.67 -20 6.67 33.33 60
    50 51.67 53.33 55 56.67 58.33 60
    40 43.33 46.67 50 53.33 56.67 60
    ...
    Best Regards,

    Kaper

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. concatenating the defualt path of browsefolder() to the user input path or folder name
    By Neverending1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-11-2018, 09:52 AM
  2. Capturing 3 inputs for a glide path, graph.
    By MattUK in forum Excel General
    Replies: 5
    Last Post: 11-08-2017, 07:56 PM
  3. Replies: 1
    Last Post: 11-26-2013, 08:46 PM
  4. Variable .Attachment.Add path using Function to pull path from word table
    By aavelyn in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-27-2013, 10:07 PM
  5. How to set GetOpenfile dialog start path to current open files path.
    By Michael Wise in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-03-2010, 02:24 PM
  6. Replies: 7
    Last Post: 10-09-2009, 10:10 AM
  7. Use String Variables in File Path and create path if not existing
    By JanBang in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-26-2007, 09:04 AM

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