Use Contain with And extension?

maineL

Hi,

I'm trying to pull the correct tuition rate based on MS/M.S. or PhD status and if their department contains Engineering. This is my Active sheet.

The formula I'm currently using: =IF(CONTAINS("Engineering", [Grad Field of Instruction]@row), 14750, 10400). So I thought adding the ADD Degree Program = M.S. MS, but unsure of how to make it work.

Any help is greatly appreciated!

Nic Larsen

Try:

=IF(AND(OR([Degree Program]@row = "MS", [Degree Program]@row = "M.S."), CONTAINS("Engineering", [Grad Field of Instruction]@row)), 14750, 10400)