IIF tournament place and prize

[elfranzen]

I have a prize pool and need the prizes to change with the place. so if in first place the text box need to show $500

I tried using this code =iif([text14]=1,500,0)

text14 is a field that I am doing a running sum

I will expand on the on the IIF statement for more prize just want this to work first.

 

[gemma-the-husky]

look at syntax for the function SWITCH, rather than nested iifs

i think it will be easier

 

[elfranzen]

Thanks got this to work.