View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dana DeLouis Dana DeLouis is offline
external usenet poster
 
Posts: 947
Default 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