Skip to main content

If statements for Racing points

  • December 28, 2018
  • 2 replies
  • 31 views
A

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)

    This topic has been closed for replies.

    2 replies

    J
    Forum|alt.badge.img+18
    SWITCH(
   Position,
   1, 25,
   2, 20
   3, 16
) * IF(DPS, 2, 1)
      A
      • Aidan_O_Connor
      • Author
      • New Participant
      • December 30, 2018
      SWITCH(
   Position,
   1, 25,
   2, 20
   3, 16
) * IF(DPS, 2, 1)

      Hi

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

      Terms & ConditionsAccessibility statement