# question

## 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

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

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

image.png (74.8 KiB)
· 1 ·

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)))
][1]

1 Vote 1 ·
image.png (57.2 KiB)

@LupuCiprianConstantinWPBVSHC-2826

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

Hope the above is helpful to you.

image.png (13.9 KiB)
image.png (13.8 KiB)
·

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