=IIF(AND( [Expr1] >30, [Expr1] <=60), [Amount Due Remaining/Applie

[Guest]

Help, does not work. Could it be the "AND". This was an Excel formula.

 

[George Nicholson]

Yep. AND() is an Excel-only function.

Try:
iif([Expr1]>30 AND [Expr1]<=60, true output, false output)

HTH,

 

[Guest]

For some reason, it did not like that. This is in a form, if that helps.

Yep. AND() is an Excel-only function.

Try:
iif([Expr1]>30 AND [Expr1]<=60, true output, false output)

HTH,

Help, does not work. Could it be the "AND". This was an Excel formula.

 

[Guest]

As in your previous Thread, try

=IIf([Expr1]>30,IIf([Expr1]<=60,[Amount Due Remaining/Applied],0),0)

Performs the same as And (If >30 then amount due) (If <= 60 Then AmountDue)
Else 0 if not either case.

Expr1 = 29 (Answer 0)

Expr1 = 30 or greater but less than or equal to 60 (Answer Amount Due
Remaining/Applied)

Expr1 61 (Answer = 0)

Let me know how you get on???

Mike B
--
An Engineers Prayer:
At the very end of the day,
when all else fails,
you have tried all,
you have shouted at and blamed the innocent,
and asked everyone you know,

READ THE INSTRUCTION MANUAL.

For some reason, it did not like that. This is in a form, if that helps.

Yep. AND() is an Excel-only function.

Try:
iif([Expr1]>30 AND [Expr1]<=60, true output, false output)

HTH,

Help, does not work. Could it be the "AND". This was an Excel formula.