Help to create this formula:

[andysvision]

Hello guys nice to join this forum Happy New Year to all.
Now basically i need to create 2 simple formula (i think so)..

The first one is when i put a number (X) i want to return the min and max value from a table witch it fits in ( A and B) please check the screenshots atached.

The second formula after achieving the first one i want for the min value to return the near cell value (factor 2)...

Please i remind you that i want to do all above things as an array .. i dont know if you understand what i want...

Thnak you in advace!

[xor]

Take a look at the attached.

[andysvision]

Originally Posted by xor

Take a look at the attached.

What what.. wooooooow so fastttttt and super accurate you made my day my friend!
God bless you !

See ya!

[andysvision]

Originally Posted by xor

Take a look at the attached.

My friend i am thinking to take this equation a little further if you can help me , check out the exel file i sending now. Thanks in advance!

[xor]

If I understand you correct.

[andysvision]

Originally Posted by xor

If I understand you correct.

Nono i didnt explain very well. check again please i got something to work but i need to expand it or make it easier:

[xor]

You seem to be gradually adding conditions. It would
be best if you listed your full specifications initially.

[andysvision]

Originally Posted by xor

You seem to be gradually adding conditions. It would
be best if you listed your full specifications initially.

wow many thanks this was all i needed. Again many thanks my friend !
See ya around.