Logical Statement

[Harley]

I need to find fx, fl, vr in A2 AND if C2 = N assign it a value of 500,
otherwise 0 OR find SE in A2 AND if C2=N assign a value of 1000, otherwise 0.
Can this work with an If, then statement?


Thanks,

Harley

 

[Teethless mama]

=IF(AND(OR(A2={"fx","fl","vr"}),C2="N"),500,0)

=IF(AND(A2="SE",C2="N"),1000,0)