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

Hello,

I would like to compare cells A1, B1, C1, D1 with cell F1. I would like to copy the value of the Cell from A1, B1, C1, D1 that is closest to the value of cell F1. Any ideas on how to do this in vba or with some crazy functions. I could do the comparisons manually, but who wants to do that.

Thanks

Copy value of a cell if it is closest
Conditional formatting if cell contains text - 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 contains date then return value ✓ - Excel Forum
An example of a cell is a blank cell ✓ - Programming Forum

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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)))

Similar discussions

If a cell contains any text then add a value

If cell = date return yes or no.

Excel: If Date =, then enter a value

Excel "IF" function w/ date in test cell

Excel formula to check if cell contains a date

Similar discussions

Subscribe To Our Newsletter!