If statement

[chrisguk]

Hi,

Can someone advise on how I would turn the following code into an IF statement returning the following values?

=(Nz([OriginalAmount]-[RebillAmount])) IF more than Zero then return "1" If less than Zero or 0 then return "0"

Thanks in advance

 

[boblarson]

=IIf(Nz([OriginalAmount],0) - Nz([RebillAmount],0) > 0, 1, 0)

You have to use the NZ on each part, not just on the calculation.