What's wrong with this =if and =and and =or statement

[soysoy05]

=IF(AND(I14="Full Time",D14>2,OR(G14=$C$7,$C$6,)),J14*$F$9,0)

Basically If I14=Full time
AND
D14>2
AND
G14=C7 or C6

then J14*F9

If not,
0

I'm not sure what's wrong with the function, is it the AND or OR part?

Thanks!

[zbor]

Your OR syntax is wrong...

instead of: OR(G14=$C$7,$C$6,)

use OR(G14=$C$6, G14=$C$7)

[zbor]

You could also use this:

=(I14="Full time")*(D14>2)*((G14=$C$6)+(G14=$C$7))*F9*$J$14

[soysoy05]

Your OR syntax is wrong...

instead of: OR(G14=$C$7,$C$6,)

use OR(G14=$C$6, G14=$C$7)

yarrr..its been a long day

thank you!!!