NESTED IIF STATEMENT. PLEASE HELP.

[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])

 

[BruceM]

There have been some responses in your original thread.

 

[clawdogs]

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.

=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 -

- Show quoted text -

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

 

[KARL DEWEY]

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?

 

[R Fourt]

Try
IIf([NOVRATE] > 1, ([CUMPERCENTOVNOV] - 1) * ([EMPLOYEE DATA
subform].Form!TOVCOMP2 * [NOVRATE]) + [EMPLOYEE DATA subform].Form!TOVCOMP2,
[NOVRATE] * [EMPLOYEE DATA subform].Form!TOVCOMP2 * [CUMPERCENTOVNOV])

 

[BruceM]

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.

=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 -

- Show quoted text -

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