# Round Function - Results seem incorrect

This topic is 3063 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

I have a system for calculating golf handicaps. I noticed that a handicap of 14.5 rounded to 14 instead of 15.

A players playing handicap for a round of golf is calculated as Handicap Index / 113 * Course Slope Rating. In this case the Handicap Index is 14.5 and the Slope is 113. The playing handicap is 14.5, which rounds to 15.

So I opened a data viewer window and entered Round(14.5, 0). The result is 15, which is correct.

Again in the data viewer  I entered Round(14.5/113*113) and the result is 14. That seems wrong to me.

I entered 14.5 / 113 * 113 on my calculator (an old Casio), and strangely, the answer is 14.4999999.

On my phone calculator and in excel, 14.5/113*113 evaluates correctly to 14.5

Round(14.5/113*113) correctly evaluates to 15 in Excel.

Am I doing something wrong?

(This is in FMPA13)

##### Share on other sites

Short answer: this is a (rare) rounding error. To avoid it, multiply first, then divide.

Edited by comment
##### Share on other sites

OK, that works, thank you

##### Share on other sites

This topic is 3063 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account