Not sure this is the best way, but

=IF(OR(A5="Brochure",A5="Datasheet",A5="SolutionBr ief"),"A",IF(OR(A5="Whitepaper",A5="ExecutiveBrief "),"B",IF(A5="CESuper","C",IF(A5="CaseStudy","D"," "))))

"Karen Smith" wrote:

I need a formula to say if cell A5 = Brochure OR Datasheet OR SolutionBrief,
than place an A in the cell, if A5 = Whitepaper or ExecutiveBrief, than place
a B in the cell, if A5 = CESuper, than place a C in the cell or if cell A5 =
CaseStudy, than place a D in the cell.

Can anyone help? Thanks in advance