You will see that both of these are true, as Cow is alphabetically later than Cat, while Cow is alphabetically ahead of Dog. The function that can be used to determine if the value in cell D7 is in-between values in cell A7 & B7 is =IF(AND(C7>=MIN(A7,B7),C7= MIN(A7, B7) – This expression checks whether the value in cell C7 is greater than (or equal to) the smaller of the two numbers in cell A7 and B7. You need to check whether the number entered in Column C is in between the numbers in Column A & Column B using a creatively formulated BETWEEN formula in Excel. In the example below, you have the start of the range in Column A, end of the range in Column B and the value to be evaluated in Column C. OPTION 1:Using a combination of MIN, MAX & AND function DOWNLOAD EXCEL WORKBOOK Between formula in Excel for Numbers