Title: Calculated fields form
Last modified: March 26, 2023

---

# Calculated fields form

 *  [mrwilks](https://wordpress.org/support/users/mrwilks/)
 * (@mrwilks)
 * [3 years, 2 months ago](https://wordpress.org/support/topic/calculated-fields-form-7/)
 * 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](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fcalculated-fields-form-7%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  [Ian Sackofwits](https://wordpress.org/support/users/plantprogrammer/)
 * (@plantprogrammer)
 * [3 years, 2 months ago](https://wordpress.org/support/topic/calculated-fields-form-7/#post-16596285)
 * 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](https://cff.dwbooster.com/documentation)
 *  Thread Starter [mrwilks](https://wordpress.org/support/users/mrwilks/)
 * (@mrwilks)
 * [3 years, 2 months ago](https://wordpress.org/support/topic/calculated-fields-form-7/#post-16596388)
 * 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.

 * In: [Everything else WordPress](https://wordpress.org/support/forum/miscellaneous/)
 * 2 replies
 * 2 participants
 * Last reply from: [mrwilks](https://wordpress.org/support/users/mrwilks/)
 * Last activity: [3 years, 2 months ago](https://wordpress.org/support/topic/calculated-fields-form-7/#post-16596388)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics