Thread: Larger than X - Smaller than Y
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Larger than X - Smaller than Y
=IF(AND(F131,F13<10),F13,"outside")
--
Gary's Student
gsnu200705


"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