NESTED IIF STATEMENT. PLEASE HELP.

  • Thread starter Thread starter clawdogs
  • Start date Start date
C

clawdogs

I need help merging the following IIF statements on a form. Both
work
seperately but I need them to work together. Both are seperate IIF
statements without else. My problem is this is calculating math and
I'm having trouble with the brackets in order to get the correct
results. Else can be the 2nd if statement but I can't seem to get it
to work.

=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])
 
There have been some responses in your original thread.




I need help merging the following IIF statements on a form.  Both
work
seperately but I need them to work together.  Both are seperate IIF
statements without else.  My problem is this is calculating math and
I'm having trouble with the brackets in order to get the correct
results.  Else can be the 2nd if statement but I can't seem to get it
to work.
Click to expand...
=IIf([NOVRATE]>1,([CUMPERCENTOVNOV])-1)*([EMPLOYEE DATA
subform].Form!
TOVCOMP2)*([NOVRATE])+([EMPLOYEE DATA subform].Form!TOVCOMP2)
Click to expand...
=IIf([NOVRATE]<1,([NOVRATE])*([EMPLOYEE DATA subform].Form!TOVCOMP2)*
([CUMPERCENTOVNOV])- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

Thanks but none of the responses helped and I had to elaborate.
 
Both work seperately
What results do they produce when the IIF is not TRUE?
What is output of first one if [NOVRATE] =1 or less than 1?
 
Try
IIf([NOVRATE] > 1, ([CUMPERCENTOVNOV] - 1) * ([EMPLOYEE DATA
subform].Form!TOVCOMP2 * [NOVRATE]) + [EMPLOYEE DATA subform].Form!TOVCOMP2,
[NOVRATE] * [EMPLOYEE DATA subform].Form!TOVCOMP2 * [CUMPERCENTOVNOV])
 
Then stay within that thread, or announce n tha htread that you are starting
a new one.

There have been some responses in your original thread.




I need help merging the following IIF statements on a form. Both
work
seperately but I need them to work together. Both are seperate IIF
statements without else. My problem is this is calculating math and
I'm having trouble with the brackets in order to get the correct
results. Else can be the 2nd if statement but I can't seem to get it
to work.
Click to expand...
=IIf([NOVRATE]>1,([CUMPERCENTOVNOV])-1)*([EMPLOYEE DATA
subform].Form!
TOVCOMP2)*([NOVRATE])+([EMPLOYEE DATA subform].Form!TOVCOMP2)
Click to expand...
=IIf([NOVRATE]<1,([NOVRATE])*([EMPLOYEE DATA subform].Form!TOVCOMP2)*
([CUMPERCENTOVNOV])- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

Thanks but none of the responses helped and I had to elaborate.
 
Back
Top