| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Test if a number falls between 2 values
I have a number stored in Cell A1. I want to test whether or not that number falls between 153 and 381 and to return the value TRUE or FALSE in Cell B1. I've tried using the IF function and the AND function but it does not like the expression "A1 between 153 and 381". Can anyone help please?
MJD |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Help - Perform a calculation only if the result falls between 2 values | Excel Discussion (Misc queries) | |||
| Create formula-if value A falls between values B and C in time for | Excel Discussion (Misc queries) | |||
| Function that returns the page number a cell falls on | Excel Worksheet Functions | |||
| Countif if the value falls between 2 other values | New Users to Excel | |||
| Formula to determine whether number falls within range?? | Excel Worksheet Functions | |||
Threaded Mode
