the expression you entered has a function containing the wrong num

  • Thread starter Thread starter GM7
  • Start date Start date
G

GM7

How can I combine these 2 IIf statements withour getting the error message in
the subject line?

Final Price: IIf([Premium Package]=True And [SemiPrice]<936,936,[SemiPrice],
IIF([Premium Package]= False And [SemiPrice]<780,780,[SemiPrice]))

The first part of the IIf statement works fine.
 
Try this --
Final Price: IIf([Premium Package]=True And [SemiPrice]<936,936,
IIF([Premium Package]= False And [SemiPrice]<780,780,[SemiPrice]))
 
Perhaps what you want is the following:

Final Price: IIf([Premium Package]=True And [SemiPrice]<936,936,
IIF([Premium Package]= False And [SemiPrice]<780,780,[SemiPrice]))

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
How can I combine these 2 IIf statements withour getting the error message in
the subject line?

Final Price: IIf([Premium Package]=True And [SemiPrice]<936,936,[SemiPrice],
IIF([Premium Package]= False And [SemiPrice]<780,780,[SemiPrice]))

The first part of the IIf statement works fine.
Click to expand...

The syntax for a multiple IIf statement is:

IIf(Criteria1 = True,TruePart1,IIf(Criteria2 = True, TruePart2
,FalsePart))


Final Price: IIf([Premium Package]=True And [SemiPrice]< 936,936,
IIF([Premium Package]= False And [SemiPrice]<780, 780,[SemiPrice]))
 
Back
Top