Expression for matching a column

[chiefsguy12]

Hello,



I am trying to find a formula that will do two things at once. I have a column that says Match or No Match. I need my expression to work like this: if it is a Match, I want the expression to return a null value, if it is No Match, I would like it to then give me the difference between the 2 columns the "Match or No Match" gets its data from. If you guys have any insight, I would greatly appreciate hearing it.

Thank you for your help

[June7]

Sounds like a simple IIf()

IIf([fieldname]="Match", Null, [field1]-[field2])