Thread: test if a value is in a range of values
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
  
Posts: 9,101
Default test if a value is in a range of values
=IF(AND(A1=5,A1<=10),TRUE,FALSE)

"jfrick" wrote:

I am trying to write a formula that tests a cell value to see if it matches
values in a range of values and returns either true or false. Any help
would be greatly appreciated.

Josh

Reply With QuoteReply With Quote