Excel IF Statement – If Number is Between Two Values 

Microsoft Excel Tips and Tricks

In this video I show you how to calculate whether a number is between two values. There is no ‘BETWEEN’ function in Excel so you have to use the AND function within an IF statement to get the desired result.

Credit Chester Tugwell