Help! IF/AND function in Access Query 1

[RDM23]

I am trying to write a formula in Access to evaluate 2 different parts and return Yes or No based on if both criteria is met. For example: If Field A is not equal to Field B, AND Field C = Null, then Yes, otherwise No.
Can someone let me know what the formula would look like? Thanks in advance.

 

[SuicidED]

SELECT Tablename.FieldA, Tablename.FieldB, Tablename.FieldC, IIf(([FieldA]<>[FieldB]) And IsNull([FieldC]),"Yes","No") AS test
FROM Tablename;

I hope/....

 

[PWise]

Iff (Field A <>Field B AND Field C is Null, True, False)