Find Closest Value or Nearest Value in a Range in EXCEL

Category > OTHERS || Published on : Monday, May 17, 2021 || Views: 1270 || Find Closest Value or Nearest Value in a Rangein EXCEL


Here Pawan Kumar will explain how to Find Closest Value or Nearest Value in a Range in EXCEL

=INDEX(B1:B7,MATCH(MIN(ABS(B1:B7-C1)),ABS(B1:B7-C1),0))

B1:B7  will be the range column

C1 Will be the number which you want to find in the range colum