The closest number

[avinashraste]

Dear all,
Hi, I have a set of numbers in the range of D1:G17. And a master number in cell A1. Now as I change the master number in cell A1, the numbers in the range also change.

1. Now is this possible to find the closest number which is higher than the master number ?
2. The second higher number ? till fifth higher number ?
3. The same way for lower side. The closest number which is lower than the master number.
4. The second lower number ? till fifth lower number.

please guide and help

Thanks & Regards

Avinash Raste

 

[avinashraste]

Still duplicate numbers are keep comming and I have to take a chance by changing the last number. Sometimes it works if I put 2 after 1, but next row if I put 3, it duplicates and if I put 4 it gives proper result...

Thanks for all the trouble you are taking to solve the problem,
Avinash Raste

 

[barry houdini]

With my final suggestion you shouldn't need 2, 3, 4 or 5 ....every formula should use 1 so that it picks up the smallest number greater than the last......

 

[avinashraste]

I got it...I got it....my mistake. extreamly sorry, insted of taking the M2 ( my previous cell ) I was taking my original master number cell, A1. Now evertything is fine and atlast the problem solved.

Thank you very very much. This is exectly what I wanted. You are terrific.

I am relieved now. Thanks a ton

Avinash Raste

 

[avinashraste]

Some times, a novice makes such a silly mistake like I did just now, and creat troubles for the seniors, and still the senior members are solving the issues so calmly, its a great great help to all of us.

Thank you very much once again,

Avinash Raste