Let's say we have the following numbers in cells A1, B1, C1...:
3 5 12 16 22
In F1, the given value is 10.
In G1, I need a formula which will pick the closest match to the given number 10 (in this case it would be 12).
Thanks!
Let's say we have the following numbers in cells A1, B1, C1...:
3 5 12 16 22
In F1, the given value is 10.
In G1, I need a formula which will pick the closest match to the given number 10 (in this case it would be 12).
Thanks!
=INDEX(A1:E1, MATCH(MIN(ABS(A1:E1-F1)), ABS(A1:E1-F1), 0))
The formula MUST be confirmed with Ctrl+Shift+Enter.
Entia non sunt multiplicanda sine necessitate
Thanx!! It works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks