Excel | TREND Function

Lupu, Ciprian-Constantin WP/BVS-HC 96 Reputation points
2021-03-12T06:37:00.263+00:00

Hello, I have a simple question for which probably there will be many experts that can help me. And for that I would like to thank you in advance!
I have a set of values that looks like this:
EVAL.RESULT | PERCENTAGE.LEVEL

1 | 50%
2 | 75%
3 | 90%
4 | 95%
5 | 99%

I want to know if the TREND function could help me to find the "Percentage.level" for a known EVAL.RESULT? To make myself more clear - if the known EVAL.RESULT is 1.5 then the PERCENTAGE.LEVEL should be in the middle of 50% and 75%. If the EVAL.RESULT will be 4.5 then the PERCENTAGE.LEVEL should be 97% (in the middle of 95% and 99% So, with trend it is creating a linear function based the entire set of data but for me is important to see if there is a function that will return the correct value on the line that the actual set of data is drawing. Thank you once again for your help

Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,012 questions
0 comments
Accepted answer
  1. Lupu, Ciprian-Constantin WP/BVS-HC 96 Reputation points
    2021-03-12T08:50:46.637+00:00

    Thank you for your answer but the problem is that for each value formula is different - I need to check where's the value (between which min and max) and then apply formula for that section.
    I was thinking if there is a formula that will automatically return the right value depending where the searched X is located

    Something like in the picture bellow
    77162-image.png

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erin Ding-MSFT 4,456 Reputation points
    2021-03-12T08:02:46.693+00:00

    @Lupu, Ciprian-Constantin WP/BVS-HC

    Based on your description, I use the formulas as below screenshots.

    77066-image.png
    77019-image.png

    More information about TREND function, you could refer to this official document.

    Hope the above is helpful to you.

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  2. Lupu, Ciprian-Constantin WP/BVS-HC 96 Reputation points
    2021-03-16T10:01:17.46+00:00

    Thank you for your answer

    0 comments