Multiple criteria and Multiple Results

[Magpie716]

Need a formula that will return one of 4 specific answers based on criteria in multiple cells.
-If someone is hired less than one year (date cell) and does not elect coverage (multiple answers in another cell) then I need the formula to return one variable (ex Class 1)
-If someone is hired less than one year (date cell) and does elect coverage (multiple answers) then I need the formula to return one variable (ex Class 2)
-If someone is hired for one year or more (date cell) and does not elect coverage (multiple answers) then I need the formula to return one variable (ex Class 3)
-If someone is hired for one year or more(date cell) and does elect coverage (multiple answers) then I need the formula to return one variable (ex Class 4)

Is there a way to do this??

[bf0109]

Magpie

I got one hell of a long formula, but it seems to do the job. Hope it works. See attachment

=IF(AND(365>TODAY()-B2,C2="Waived"),"Class 1",IF(AND(365>TODAY()-B2,C2="Buy Up EE"),"Class 2",IF(AND(365>TODAY()-B2,C2="Plus EE"),"Class 2", IF(AND(365>TODAY()-B2,C2="Buy Up ES"),"Class 2", IF(AND(365>TODAY()-B2, C2="Buy Up EC"),"Class 2", IF(AND(365<TODAY()-B2,C2="Waived"),"Class 3", IF(AND(365<TODAY()-B2,C2="Buy Up EE"),"Class 4",IF(AND(365<TODAY()-B2,C2="Plus EE"),"Class 4", IF(AND(365<TODAY()-B2,C2="Buy Up ES"),"Class 4", IF(AND(365<TODAY()-B2, C2="Buy Up EC"),"Class 4"))))))))))