IIf Statements

[Guest]

I am currently using the following IIF statement- if ConditionA is met, a
value of 750 is returned, otherwise 0 is returned:

IIf([ConditionA]=true,750,0)

I would like to amend this statement so that if Condition A is true, then
the greater of 750 or .0125*[AmountA] is returned. A value of 0 would still
be returned if Condition A is not true.

What should my IIF statement look like to achieve this?

Many thanks

 

[Guest]

RickJ:

While I haven't ever used/tried this, my first effort would be a nested IIF
statement, like this:

IIf([ConditionA]=true,iif(([ConditionA]*.0125)>750,([ConditionA*.0125),750),0)

HTH.

Sharkbyte

 

[fredg]

I am currently using the following IIF statement- if ConditionA is met, a
value of 750 is returned, otherwise 0 is returned:

IIf([ConditionA]=true,750,0)

I would like to amend this statement so that if Condition A is true, then
the greater of 750 or .0125*[AmountA] is returned. A value of 0 would still
be returned if Condition A is not true.

What should my IIF statement look like to achieve this?

Many thanks

I would reverse the logic.
=IIf(Not [ConditionA] = True,0, IIf(750> 0.0125*[AmountA],
750,0.0125*[AmountA]))

 

[Guest]

Works perfect- thanx for your expertise--

RickJ:

While I haven't ever used/tried this, my first effort would be a nested IIF
statement, like this:

IIf([ConditionA]=true,iif(([ConditionA]*.0125)>750,([ConditionA*.0125),750),0)

HTH.

Sharkbyte

I am currently using the following IIF statement- if ConditionA is met, a
value of 750 is returned, otherwise 0 is returned:

IIf([ConditionA]=true,750,0)

I would like to amend this statement so that if Condition A is true, then
the greater of 750 or .0125*[AmountA] is returned. A value of 0 would still
be returned if Condition A is not true.

What should my IIF statement look like to achieve this?

Many thanks

 

[Guest]

Glad I could help. However, I just noticed that you may want to add an "="
in the nested IIF. To cover a situation of things being equal. The result
would look like this:

IIf([ConditionA]=true,iif(([ConditionA]*.0125)>=750,([ConditionA*.0125),750),0)


Sharkbyte

Works perfect- thanx for your expertise--

RickJ:

While I haven't ever used/tried this, my first effort would be a nested IIF
statement, like this:

IIf([ConditionA]=true,iif(([ConditionA]*.0125)>750,([ConditionA*.0125),750),0)

HTH.

Sharkbyte

I am currently using the following IIF statement- if ConditionA is met, a
value of 750 is returned, otherwise 0 is returned:

IIf([ConditionA]=true,750,0)

I would like to amend this statement so that if Condition A is true, then
the greater of 750 or .0125*[AmountA] is returned. A value of 0 would still
be returned if Condition A is not true.

What should my IIF statement look like to achieve this?

Many thanks