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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks