Coverting Excel If statement to Access

[Nancyade]

I need help to convert the below excel if statement to access.
=IF(AND(H6>M6),H6-M6)

I did the convertion but it is not working properly, please find below my convertion

Awaiting Outcome: IIf([Number New referrals]>[Total Outcome],[Number new referrals]-[Total Outcome])

 

[plog]

Looks good. What are your input values, result and expected result?

 

[Beetle]

The IIf statement in Access has three arguments;

IIf(expression, true part, false part)

What result do you want if [Number New Referrals]>[Total Outcome] is not true?

 

[Brianwarnock]

I need help to convert the below excel if statement to access.
=IF(AND(H6>M6),H6-M6)

I did the convertion but it is not working properly, please find below my convertion

Awaiting Outcome: IIf([Number New referrals]>[Total Outcome],[Number new referrals]-[Total Outcome])

Why the AND ? and if not true you end up with FALSE in the cell, is that what you wanted, I doubt that that is the correct Excel formula

Brian