question

LupuCiprianConstantinWPBVSHC-2826 avatar image
0 Votes"
LupuCiprianConstantinWPBVSHC-2826 asked ·

Excel | TREND Function

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-deploymentmicrosoft-graph-workbooks
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LupuCiprianConstantinWPBVSHC-2826 avatar image
0 Votes"
LupuCiprianConstantinWPBVSHC-2826 answered ·

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



image.png (74.8 KiB)
· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@LupuCiprianConstantinWPBVSHC-2826

Maybe you could try the following formula.
=(VLOOKUP(ROUNDDOWN($A$10,0),A1:B6,2,FALSE))+((VLOOKUP(ROUNDUP($A$10,0),A1:B6,2,FALSE)-VLOOKUP(ROUNDDOWN($A$10,0),A1:B6,2,FALSE))*($A$10-ROUNDDOWN($A$10,0)))
![78186-image.png][1]

1 Vote 1 ·
image.png (57.2 KiB)
erinding-msft avatar image
0 Votes"
erinding-msft answered ·

@LupuCiprianConstantinWPBVSHC-2826

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.


image.png (13.9 KiB)
image.png (13.8 KiB)
·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LupuCiprianConstantinWPBVSHC-2826 avatar image
0 Votes"
LupuCiprianConstantinWPBVSHC-2826 answered ·

Thank you for your answer

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.