| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
is it possible to check
Hi all,
I need help... I would like to know how to go about an if statement to validate if a number is between 2 numbers? For example, an entered number then if the number is between 5 and 50, then....something |
|
#2
|
|||
|
|||
|
=IF(AND(A1=5,A1<=50),"between","outside")
Regards, KL "leeyowh" wrote in message ... Hi all, I need help... I would like to know how to go about an if statement to validate if a number is between 2 numbers? For example, an entered number then if the number is between 5 and 50, then....something |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allowing only 1 check box to be ticked | Excel Discussion (Misc queries) | |||
| Check boxes - when one box is checked, I want a 2nd box to auto ch | Excel Discussion (Misc queries) | |||
| How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
| Auto spell check as in word | Excel Discussion (Misc queries) | |||
| Creating a check box that does not require security clearance. | Excel Worksheet Functions | |||
Linear Mode
