Jump to content

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)

FM_Round.png

Link to comment
Share on other sites

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.