nested IIF statement

[slames]

I have a report with a text box that needs to be populated with a number of different possibilities depending on the content of two other text boxes.
For example if text1 = 1 and text2 = 2 then I need text3=22, but if text1=2 and text2=2 text3 must equal 35.
What is the format for nested iif statements?, I can't seem to get it to work.
Thanks

Steph

 

[Aubs010]

Steph,

IIF([text1]=1 And [text2]=2,22,IIF([text1]=2 And [text2]=2,35,"&quot)

This is one I have used before:
=IIf([Number]=1 Or [Number]=2 Or [Number]=3,"Yes","No&quot

Hope it helps

Aubs

 

[slames]

Thanks, that's great, I've got that working now.