I have two formulas that both work by themselves:
1. IIf(Nz([Approved])=0,0)
2. IIf(Nz([Allocated])+(Nz([Carryover]))=0,0)
But what I really need is to combine these formulas so that if either is true a zero is returned. Here is one combined version I tried:
IIf(Nz([Allocated])+(Nz([Carryover]))=0 OR (Nz([Approved])=0,0)))
I keep getting a "wrong number of arguments" message. I've tried many combinations of parentheses but can't find the fix. Can anyone tell me what's going wrong?
Thx, William
1. IIf(Nz([Approved])=0,0)
2. IIf(Nz([Allocated])+(Nz([Carryover]))=0,0)
But what I really need is to combine these formulas so that if either is true a zero is returned. Here is one combined version I tried:
IIf(Nz([Allocated])+(Nz([Carryover]))=0 OR (Nz([Approved])=0,0)))
I keep getting a "wrong number of arguments" message. I've tried many combinations of parentheses but can't find the fix. Can anyone tell me what's going wrong?
Thx, William