if, and, or

[twyckoff]

I will try to describe the problem that I haven't been able to solve for days. Maybe it's really easy, but I haven't been able to string together my logical tests so that they work together. E1 will contain one of 4 values (They are the words "Elite", "Preferred", "Traditional" and "Non-Traditional"). The word that appears in E1 is dependent on lots of other data, which all works fine. The value of a related cell (where the formula will reside) will populate depending on the word. So, =if("Elite",6, if("Preferred",4, if("Traditional",8, if("Non-Traditional",7 Again, it seems like it should be so simple but I can't get it. Any help? Thank you in advance. Tom

[judgeh59]

give this a try

Please Login or Register  to view this content.

[FDibbins]

Hi, welcome to the forum

Perhaps a small addition to that?
=if("Elite",6, if("Preferred",4, if("Traditional",8,7))) Agai

[PMC_93]

Gotcha. This formula will work:

=IF(E1="Elite",6, IF(E1="Preferred",4,IF(E1="Traditional",8,IF(E1="Non-Traditional",7))))

-PMC_93

[judgeh59]

twyckoff - thanks for the rep point - glad we could all help...

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[FDibbins]

glad we could help and thanks for the feedback