If statements for Racing points



Im looking to do an if statment to calculate the following. If(Position =1,25) this much works but i can add the rest of the positions to the statement eg If (Position =2,20) If (position =3,16). There is one other requirement that some round give double points and i have a check box for this so IF (“DPS” is checked *x2)

   1, 25,
   2, 20
   3, 16
) * IF(DPS, 2, 1)



Thank you very much that worked a treat I never heard of switch before this could be very useful.