Thread: If a number is between 1 & 4 then do X else do XY
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
muddan madhu muddan madhu is offline
external usenet poster
  
Posts: 747
Default If a number is between 1 & 4 then do X else do XY
can it be ?

=IF((A10)*(A1<5),"X","XY")

On May 28, 7:31*am, Teethless mama
wrote:
=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?- Hide quoted text -

- Show quoted text -

Reply With QuoteReply With Quote