It's hard to believe they worked in their original form considering that the
expressions have different numbers of opening and closing parentheses.
It looks as if the responder copies the same thing for the Then and the
Else. It should be something like:
=IIf([NOVRATE]>1,
([CUMPERCENTOVNOV] - 1) *
[EMPLOYEE DATA subform].Form!TOVCOMP2 *
[NOVRATE] +
[EMPLOYEE DATA subform].Form!TOVCOMP2,
[NOVRATE] *
[EMPLOYEE DATA subform].Form!TOVCOMP2 *
[CUMPERCENTOVNOV])
The spaces and line breaks are for clarity only.
There is no need for parentheses around field names. Parentheses otherthan
those required for the IIf function (or other functions, if you had used
them) are for grouping data as needed to perform the calculations.
Assuming NOVRATE is never 1, then the 2nd IIF is the else to the first IIF
=IIf([NOVRATE]>1,[CUMPERCENTOVNOV]-1*[EMPLOYEE DATA
subform].Form!TOVCOMP2*[NOVRATE]+[EMPLOYEE DATA
subform].Form!TOVCOMP2,[CUMPERCENTOVNOV]-1*[EMPLOYEE DATA subform].Form!
TOVCOMP2*[NOVRATE]+[EMPLOYEE DATA subform].Form!TOVCOMP2)
I need help merging the following IIF statements on a form. Both work
seperately but I need them to work together. Both are seperat IIF
statements without else. Else can be anything or zero etc...
=IIf([NOVRATE]>1,([CUMPERCENTOVNOV])-1)*([EMPLOYEE DATA subform].Form!
TOVCOMP2)*([NOVRATE])+([EMPLOYEE DATA subform].Form!TOVCOMP2)
=IIf([NOVRATE]<1,([NOVRATE])*([EMPLOYEE DATA subform].Form!TOVCOMP2)*
([CUMPERCENTOVNOV])- Hide quoted text -
That didn't work. Can someone help with maybe IIF THEN, IIF THEN,
ELSE?- Hide quoted text -
- Show quoted text -