If and AND?

Giganews Newsgroups
Subject: If and AND?
Posted by:  mldancing
Date: Thu, 16 Aug 2007

I have a question and hope someone can help:

Col A
AA, AB, AC, BB, DDD
AC, DDD
CD, GH, DDD

I want to create a formula in another column where if  each row has

AA or AB, show "Class 1"
DDD show "Class 2"
AC or CD or GH show "Class 3"
BB show class "4"

Please help. Thank you.

Replies