We are able to check if a number is between two values by using the AND function. AND evaluates all logical tests and returns TRUE only if all conditions are met. Otherwise, it returns FALSE. Figure 1. Final result: If number is between two values Syntax of AND =AND(logical1, [logical2],...
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.