Help with IF when multiple answers required

  • Thread starter Thread starter John C
  • Start date Start date
J

John C

Hello,



I'm trying to create a IF statement in a cell that will show the following
results:-



If cell A1 is between

0-520 display "Option 1"

521-570 display "Option 2"

greater that 571 display "Option 3"



Thanks in advance

John
 
I think the Don intended:

=if(a1>570,3,if(a1>520,2,if(a1>0,1,"")))

or

=if(a1>=571,3,if(a1>=521,2,if(a1>=0,1,"")))

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
One more method........

=LOOKUP(A1,{0,521,571},{"Option 1","Option 2","Option 3"})

I assumed you meant >570 for Option 3


Gord Dibben MS Excel MVP
 
Back
Top