Between two numbers formula in Excel

January 6, 2022
714 Views 0

We may need to compare values when analyzing data. Here we will talk about how to mark the values that are between two given values.


Here we take a table as an example. We want to know whether the values are between Number 1 and Number 2.

We can use this formula: =AND(val>MIN(num1,num2),val.


In this case, we can enter:=AND(C2>MIN(A2,B2), C2 

If the value is between Number 1 and Number 2, the result is TRUE; otherwise, it is FALSE.

Between two numbers formula in Excel.gif  

Anyway, WPS Office suite makes your work easy. Free download WPS Office for PC, Mobile, Windows, Mac, Android, and iOS online.

Was this helpful?