Home // Blog & Excel Tips // Excel Between function

Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.
2. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'

 

 

Excel Between function

Comments Closed
Uncategorised

Excel Between Function

Spreadsheet users eventually all require the ability to do an Excel between function. However, no such function exists in Excel and any attempt to play with the logical operators does not work.

So for example if you want X to be between say 5 and 15, Excel users often try and enter 5>X<15 or similar. This doesn’t work.

In order to see if a number is between two numbers you need to use the AND function ( click here to see the video clip on the AND function).

The AND function checks if 2 or more conditions are met e.g. X is bigger than 5 AND X is less than 15 ( in Excel terms this would be =AND(X>5, X<15). This achieves the same as a between as only numbers between 5 and 15 can both be bigger than 5 AND less than 15. The end result is a True or False which can then be used in an IF or other functions.