Calculated fields form

  • I’ve built a handicap calculator to tell visitors and members alike what their playing handicap is for our golf course, according to the new World Handicap System. I then built the same thing to work out the strokes gained by team 1/2 in a doubles match. The latter works great, other than my inability to figure how to adapt the equation to make it round up the returned answer. This base formula I’ve used is IF(fieldname31>fieldname33,(fieldname31-fieldname33)/2,0) This works but if it return 7.5, I would prefer it displayed 8

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)

  • Hey, mrwilks, I’m guessing you’re using the Calculated Fields Form plugin based on the parameters in the URL you supplied.

    If you are using the plugin, I would take a look at using the ceil function.

    This is the documentation for the plugin: https://cff.dwbooster.com/documentation

    Thread Starter mrwilks

    (@mrwilks)

    Hi Ian, thank you for your response. I wasn’t sure where to add the CEIL function in my equation, but having tried it in various places, I couldn’t get the equation to continue calculating an answer.

    Thanks, Iain

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Calculated fields form’ is closed to new replies.