Thread: If a number is between 1 & 4 then do X else do XY
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default If a number is between 1 & 4 then do X else do XY
=IF(AND(A1=1,A1<=4),"X","XY")


"Maggie" wrote:

I want to find out how to do an If formula which gives a result if the
condition is between two numbers?
Reply With QuoteReply With Quote