Download Smart Invoice v1.0 - ASP.NET Invoice Software System Ready to use, Open Source Invoice System Project(ASP.NET, jQuery & MS-SQL)
.Net Articles/Snippets
ASP.NET ASP.NET MVC C#/C Sharp VB/VB.NET ADO.NET LINQ WCF WPF Card Space Win Forms Task Parallel Library Parallel-linq Modern UI Runtime Task-Base-Async-Model
Web Development Articles/Snippets
AJAX CSS HTML HTML5 Javascript jQuery Flash
Database Articles/Snippets
SQL Ms-SQL Server MySQL Oracle
Languages Articles/Snippets
PHP Python Ruby Objective C XML Assembly Language Basic C/C++ CFML Classic ASP Delphi Fortran CGI/Perl Java Pascal
Mobile Development Articles/Snippets
SQL Ms-SQL Server MySQL Oracle
Others Articles/Snippets
SEO VBA
  1. Home
  2. Others
  3. Find Closest Value or Nearest Value in a Range in EXCEL

Find Closest Value or Nearest Value in a Range in EXCEL

Category > OTHERS || Published on : Monday, May 17, 2021 || Views: 1328 || 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

You might also like