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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pgarcia - 21 Feb 2007 22:22 GMT

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

Reply to this Message

George Nicholson - 21 Feb 2007 22:29 GMT

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.

Reply to this Message

pgarcia - 21 Feb 2007 22:37 GMT

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

> Yep. AND() is an Excel-only function.
>
[quoted text clipped - 4 lines]
>
> > Help, does not work. Could it be the "AND". This was an Excel formula.

Reply to this Message

MikeJohnB - 21 Feb 2007 22:57 GMT

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

Signature

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.
>
[quoted text clipped - 6 lines]
> >
> > > Help, does not work. Could it be the "AND". This was an Excel formula.

Reply to this Message