Hello again.

I’m trying to run a nested iif statement but get getting an error or just won’t run:
the formula is shown below

Expr1: (IIf([Buyer Name]="Diane Grover",([OL_QTY_ORD]-[OL_QTY_CAN_TD])/2,"([OL_QTY_ORD]-[OL_QTY_CAN_TD])"))

Any help would be greatly appreciated

Thanks

Corey

Corey,
What are your datatypes for [OL_QTY_ORD] and[OL_QTY_CAN_TD])?

Loralee

Corey

It looks like you have an additional set of"" in the formula. You dont need them in the false half of the equation.

Jim

That was it. Thanks for the quick responce

Corey

Got it fixed - thanks Loralee