If statements for Racing points


#1

Hi

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)


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

#3

Hi

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