Formula not working in text box

[Zonie32]

Hello. I have a text box on a form that has 3 fields, Balance, Recovery and EarnedCommision. I am trying to put this formula into the Recovery box but keep getting the "#Error" message:

=IIf([Balance]>0,IIf([Balance]-[EarnedCommission]>=0,[EarnedCommission],[Balance]),0)

Am I missing something here?

 

[Remou]

Did you try the Expression Builder?

 

[Zonie32]

Hi. Yes I did try that but I cannot seem to figure this one out.