Excel IF Statement – If Number is Between Two Values 

nnnn

Microsoft Excel Tips and Tricks

nIn 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.nnnn

Credit Chester Tugwell

n