Help with IF when multiple answers required

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John C - 29 Jul 2007 17:57 GMT

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

Reply to this Message

Don Guillett - 29 Jul 2007 18:12 GMT

try this

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

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> Hello,
>
[quoted text clipped - 12 lines]
>
> John

Reply to this Message

Sandy Mann - 29 Jul 2007 18:32 GMT

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,"")))

Signature

Regards,

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

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> try this
>
[quoted text clipped - 16 lines]
>>
>> John

Reply to this Message

Gord Dibben - 29 Jul 2007 19:49 GMT

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

>Hello,
>
[quoted text clipped - 12 lines]
>
>John

Reply to this Message

John C - 29 Jul 2007 20:08 GMT

> I assumed you meant >570 for Option 3

Yep I did and that works great.

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

Thank you

Reply to this Message