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