Thread: Test if a number falls between 2 values
View Single Post
  #1   Report Post  
dalymjl dalymjl is offline
Junior Member
  
Location: Ireland
Posts: 29
Default Test if a number falls between 2 values
I have a number stored in Cell A1. I want to test whether or not that number falls between 153 and 381 and to return the value TRUE or FALSE in Cell B1. I've tried using the IF function and the AND function but it does not like the expression "A1 between 153 and 381". Can anyone help please?

MJD
Reply With QuoteReply With Quote