Multiple Iff in same field

[cbenisch]

I have a player database for a tournament. I am having an issue with calculating the cost to enter. Here is the calculated field I am using.



IIf([Player1] Is Null,0,70)+([Player1ExtraDinner]*20)-IIf([Player1Pass]=True,17,0)

Player1 is a field in the table with a name. If it is blank I want the calculated field to be zero for the fees. If it is not then I need to charge the $70 plus another $20 x the number of Player1ExtraDinner then I need to subtract 17 if the Player1Pass field is true.

Examples
Null is $0
Player1 = bob and no dinners value should be $70
Player1 = bob and 2 dinners value should be $110
Player1 = bob and 2 dinners and Player1Pass = true value should be $93

I have tried many different ways to try and get this to come out right and finally decided to ask for some help.

Can someone help me with this? Nesting seems to cause me troubles.


Thanks you in advance.

[June7]

Try:

IIf([Player1] Is Null, 0, 70 + [Player1ExtraDinner] * 20 - IIf([Player1Pass], 17, 0))

[cbenisch]

I have a player database for a tournament. I am having an issue with calculating the cost to enter. Here is the calculated field I am using.

IIf([Player1] Is Null,0,70)+([Player1ExtraDinner]*20)-IIf([Player1Pass]=True,17,0)

Player1 is a field in the table with a name. If it is blank I want the calculated field to be zero for the fees. If it is not then I need to charge the $70 plus another $20 x the number of Player1ExtraDinner then I need to subtract 17 if the Player1Pass field is true.

Examples
Null is $0
Player1 = bob and no dinners value should be $70
Player1 = bob and 2 dinners value should be $110
Player1 = bob and 2 dinners and Player1Pass = true value should be $93

I have tried many different ways to try and get this to come out right and finally decided to ask for some help.

Can someone help me with this? Nesting seems to cause me troubles.


Thanks you in advance.

I looked at it again and used


=((IIf([Player1] Is Null,0,70)+([Player1ExtraDinner]*20))-(IIf([Player1Pass]=True,17,0)))

Which seems to work as expected.

[June7]

Glad you have a solution but really don't know why your original expression failed.