| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function that determines whether a number is between two numbers
=and(num1<cell,cell<num2). note that if cell=num1 or cell=num2 it will return false. It also only works if num1<num2. -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=518550 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Using the Indirect function with a sheet number instead of a sheet name | Excel Worksheet Functions | |||
| random number with text | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
