Nested IIF with AND and Multiple Conditions

[Paperback Writer]

Is it possible to use an "AND" with a nested IIF?

Here is my syntax, which isn't working. PLEASE HELP!!!

IIF(AND([Value One]>0,

="Delivery"),[Total Value Two]-[Value
Three],IIF(AND([Value Four]>0,[Code]="Reserve"),[Value Five]-[Value Six],0))

 

[Dirk Goldgar]

Is it possible to use an "AND" with a nested IIF?

Here is my syntax, which isn't working. PLEASE HELP!!!

IIF(AND([Value One]>0,

="Delivery"),[Total Value Two]-[Value
Three],IIF(AND([Value Four]>0,[Code]="Reserve"),[Value Five]-[Value
Six],0))[/QUOTE]


You can use in an IIf expression, though not the way you've tried, but I
can't figure out from your attempt what the actual logical expression is
that you want to evaluate.  Could you state it in simple words, please?

 

[Paperback Writer]

I'd rather not say.

Is it not possible to create something from my formula? Could you
demonstrate a nested IIF / AND / Multiple Conditions expression that works?

Is it possible to use an "AND" with a nested IIF?

Here is my syntax, which isn't working. PLEASE HELP!!!

IIF(AND([Value One]>0,

="Delivery"),[Total Value Two]-[Value
Three],IIF(AND([Value Four]>0,[Code]="Reserve"),[Value Five]-[Value
Six],0))[/QUOTE]


You can use in an IIf expression, though not the way you've tried, but I
can't figure out from your attempt what the actual logical expression is
that you want to evaluate.  Could you state it in simple words, please?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
[/QUOTE]

 

[John Spencer (MVP)]

More like the following:

IIF([Value One]>0 AND

="Delivery",[Total Value Two]-[Value Three]
,IIF([Value Four]>0 AND [Code]="Reserve"),[Value Five]-[Value Six],0))



John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Dirk Goldgar]

I'd rather not say.

I didn't mean you needed to get down to specifics with the actual field
names; just explain the logic you wanted to implement.

Is it not possible to create something from my formula? Could you
demonstrate a nested IIF / AND / Multiple Conditions expression that
works?

See John Spencer's reply. Maybe he figured out correctly what you had in
mind.

 

[KARL DEWEY]

If will not give more explaination no one can help you because your formula
does not make any sense.
What two sets of conditions are you saying must be met with your AND?

Maybe you meant something like this --
CODE: IIF([Value One]>0 AND [Total Value Two]-[Value Three],
"Delivery", IIF([Value Four]>0 AND Value Five]-[Value Six], "Reserve"),"0"))

--
KARL DEWEY
Build a little - Test a little

I'd rather not say.

Is it not possible to create something from my formula? Could you
demonstrate a nested IIF / AND / Multiple Conditions expression that works?

Is it possible to use an "AND" with a nested IIF?

Here is my syntax, which isn't working. PLEASE HELP!!!

IIF(AND([Value One]>0,

="Delivery"),[Total Value Two]-[Value
Three],IIF(AND([Value Four]>0,[Code]="Reserve"),[Value Five]-[Value
Six],0))[/QUOTE]


You can use in an IIf expression, though not the way you've tried, but I
can't figure out from your attempt what the actual logical expression is
that you want to evaluate.  Could you state it in simple words, please?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
[/QUOTE][/QUOTE]

 

[Paperback Writer]

THANK YOU

More like the following:

IIF([Value One]>0 AND

="Delivery",[Total Value Two]-[Value Three]
,IIF([Value Four]>0 AND [Code]="Reserve"),[Value Five]-[Value Six],0))



John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

[QUOTE="Paperback"]
Is it possible to use an "AND" with a nested IIF?

Here is my syntax, which isn't working.  PLEASE HELP!!!

IIF(AND([Value One]>0,[Code]="Delivery"),[Total Value Two]-[Value
Three],IIF(AND([Value Four]>0,[Code]="Reserve"),[Value Five]-[Value Six],0))[/QUOTE]
[/QUOTE]