Thread: Larger than X - Smaller than Y
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Fred Smith Fred Smith is offline
external usenet poster
  
Posts: 623
Default Larger than X - Smaller than Y
=if(and(x1,x<10),true,false)

--
Regards,
Fred


"amirstal" wrote in message
oups.com...
How can I get the IF function to return any number that is larger than
1 and smaller than 10 (1<X<10)?



Reply With QuoteReply With Quote