Test if a number falls between 2 values
=ABS(A1-267)<114
=IF(A1153,A1<381)
=AND(A1153,A1<381)
Gotcha by 2 Characters :)
--
Dana DeLouis
"Ron Rosenfeld" wrote in message
...
On Sat, 21 Jul 2007 10:47:25 -0700, Gord Dibben <gorddibbATshawDOTca
wrote:
=IF(AND(A1153),(A1<381)
Interesting formula (although needs another close parentheses).
After I understood the logic, I could simplify it to:
=IF(A1153,A1<381)
Which is one keystroke shorter than mine:
=AND(A1153,A1<381)
--ron
|