Thread: Test if a number falls between 2 values
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Test if a number falls between 2 values
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
Reply With QuoteReply With Quote