Else, If Statement

  • Thread starter Thread starter Lisa
  • Start date Start date
L

Lisa

Is there any way to build an else, if statement. For
example I need to say that IF Reserve type = 70/25, then
perform this, else IF reserve Type = 70/30,perform this.
Here is what I have so far and it is working but I can't
get the second part into it. I am pulling the 70/25 and
70/30 from a combo box.

=IIf([RESERVE TYPE]="70/25",([APR]-[FIXED RATE])*0.75/[APR]
*[FINANCE CHARGE])
 
Is there any way to build an else, if statement. For
example I need to say that IF Reserve type = 70/25, then
perform this, else IF reserve Type = 70/30,perform this.
Here is what I have so far and it is working but I can't
get the second part into it. I am pulling the 70/25 and
70/30 from a combo box.

=IIf([RESERVE TYPE]="70/25",([APR]-[FIXED RATE])*0.75/[APR]
*[FINANCE CHARGE])
Click to expand...

Lisa,
This is information is available in VBA Help.

=IIf([SomeField] = some criteria,Do the True part,Do something else
here)

So....
=IIf([Reserve Type]="70/25",([APR]-[FIXED RATE])*0.75/[APR]
*[FINANCE CHARGE],Otherwise what else do you want to do here)

Additionally, several IIf statements can be nestled:
=IIf([Field] = 10,Do This,IIf([Field] = 20, Do this part,Otherwise do
something else))
 
Suggest you look up in the HELP file the If..Then..ElseIf..End If procedure.
It is more flexible than the Immediate If (IIF) statement and is faster to
process.
If..Then..ElseIf..End If is easy to use and more intuitive.

Cheers,
Henry
 
Back
Top