Form Calculation Assistance

[chrisguk]

Hi,

Is there anyone that is able to tell me whats wrong with the following:

=IIf([OriginalAmount]-[RebillAmount]=0,0,(Nz([OriginalAmount]-[RebillAmount]=0,0,Nz([OriginalAmount],0)/(DateDiff("d",[dteOriginalFrom],[dteOriginalTo]))*365)+Nz([CashReturn]))

 

[jdraw]

Your syntax is incorrect.
It would help if you told us what you are trying to do.

Generally,

iif(condition,True,false)

if you have more conditions

iif(condition1,True,
iif(condition2,True,
iif(conditionX,true,False)))