Not sure if I need OR, AND or IF statement? Can you help?

[sobeitjedi]

Hi, I'll try to explain the sheet setup ...

Column F has one of two entries
PROJECT
SCHOOL

Column AB can contain a department code or be blank
MID
CNC
DEA
EDU
PGR
CCT
INT
RIP
(the list of codes goes on)

In column AJ I want a formula that says if column F=school and column AB=INT or MID or EDU or PGR then put 6705 in the cell. If F=School and AB is not INT or MID or EDU or PGR then put 7705 in the cell. Any other combination (ie, where f=project), put 9705 in the cell.

Hope that makes sense and you can help - please!. Thanks.

 

[Fluff]

Try
=IF(AND(F2="School",OR(AB2="INT",AB2="MID",AB2="EDU",AB2="PGR")),6705,IF(F2="School",7705,9705))

 

[Joe4]

Try this (for row 2):

=IF(F2="SCHOOL",IF(OR(AB2="INT",AB2="MID",AB2="EDU",AB2="PGR"),6705,7705),9705)

 

[sobeitjedi]

Try
=IF(AND(F2="School",OR(AB2="INT",AB2="MID",AB2="EDU",AB2="PGR")),6705,IF(F2="School",7705,9705))

Great - thank you sooooo much

 

[Fluff]

Glad to help & thanks for the feedback.
the formula from Joe4 is a lot simpler & probably better