Thread: Larger than X - Smaller than Y
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
SteveW SteveW is offline
external usenet poster
  
Posts: 427
Default Larger than X - Smaller than Y
=if(and(x1,x<10),x,"whatever")

Steve


On Fri, 09 Feb 2007 14:01:49 -0000, amirstal wrote:

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