Multiple IF AND Statements with 3 Possible Outcomes?

[c.clavin]

Hi guys, I am tying myself into knots trying to figure this out. I'm sure it's possible to get. I've been working on this for like 3 hours with no success, please help!!

I need the output of one cell to have 3 possible entries; EASY, MEDIUM, and HARD based on if two other cells have text or not.

If both cells have text, then HARD
If cell 1 has text but cell 2 doesn't have text, then MEDIUM
If both cells don't have text, then EASY

 

[c.clavin]

I wrote it down wrong, it should be:

EASY if both blank
MEDIUM if A1 has text and B2 is blank
HARD if A1 and B2 have text

 

[c.clavin]

This is what I am trying to use for my formula, but it's giving me an error code.

=IF(AND(A1=<>"",B2="","MEDIUM",IF(AND(A1=<>"",B2=<>"","HARD",IF(AND(A1="",B2="","EASY")

 

[Tetra201]

Maybe

=IF(AND(A1="",B2=""),"EASY",IF(OR(A1="",B2=""),"MEDIUM","HARD"))

 

[c.clavin]

Wow that worked like charm thanks!

 

[Tetra201]

Glad to have helped.

 

[shift-del]

Hi

=CHOOSE(COUNTA(A1,B2)+1,"easy","medium","hard")