Two IIF statements possible?

[Randy]

I have a text box on my report that can have 3 different results depending
on the situation. The first 2 situations are as follows
=IIf([Text97]+[Text99]+[Text101]<50,50,[Text97]+[Text99]+[Text101]) This
works fine with the 2 possibilities, but I have a third situation of when a
check box is checked on my form (True). If the checkbox [Retest] is
checked, I need to have the previous IIf statement to have a result of 0.
Something like:
IIF([Retest]=True,0,IIf([Text97]+[Text99]+[Text101]<50,50,[Text97]+[Text99]+
[Text101]) I know this is not a correct statement, but what would be a
correct statenment? Thanks...Randy

 

[Douglas J. Steele]

Very close. All you're missing is an additional closing parenthesis.

 

[Randy]

That did it, Thank you...Randy

Very close. All you're missing is an additional closing parenthesis.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

I have a text box on my report that can have 3 different results depending
on the situation. The first 2 situations are as follows
=IIf([Text97]+[Text99]+[Text101]<50,50,[Text97]+[Text99]+[Text101]) This
works fine with the 2 possibilities, but I have a third situation of

when

a
check box is checked on my form (True). If the checkbox [Retest] is
checked, I need to have the previous IIf statement to have a result of 0.
Something like:

IIF([Retest]=True,0,IIf([Text97]+[Text99]+[Text101]<50,50,[Text97]+[Text99]+

[Text101]) I know this is not a correct statement, but what would be a
correct statenment? Thanks...Randy

 

[Steven Chan]

Yes, you can use the statement that you have; just add
another ) bracket at the end and it will worked.

 

[Barbara]

I have used as many as 8 nested IIF's. I am not certain
if there is a limit.