Copy value of a cell if it is closest
Closed
Travis
-
Jun 21, 2010 at 07:16 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 21, 2010 at 07:34 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 21, 2010 at 07:34 PM
Related:
- Copy value of a cell if it is closest
- Conditional formatting if cell contains text - Excel Forum
- If cell contains date then return value - Excel Forum
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- Count if cell contains number - Excel Forum
- If cell A1 has text then cell B2 has today's Date ✓ - Excel Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 21, 2010 at 07:34 PM
Jun 21, 2010 at 07:34 PM
=IF(ABS(F1-A1)<=MIN(ABS(F1-B1),ABS(F1-C1),ABS(F1-D1)), A1,IF(ABS(F1-B1)<=MIN(ABS(F1-A1),ABS(F1-C1),ABS(F1-D1)),B1,IF(ABS(F1-C1)<=MIN(ABS(F1-A1),ABS(F1-B1),ABS(F1-D1)),C1,D1)))