In this video, I'll show you how to calculate whether a number is between two values. Excel does not have a native BETWEEN function, so we wrote one to simplify the situation and avoid the need for using the AND and IF functions, which - let's admit - can be somewhat cumbersome. Download DataFX free function library: https://exceldashboardschool.com/free... Chapters: 00:00 Intro 00:09 IF Statement Between Two Numbers in Excel 00:17 Using the Excel BETWEEN function 01:04 Excluding lower and upper limits #exceltips #exceltutorial #excel