Help with an excel calculation

[leftos]

Hello to the brains out there,

I am trying to work out how to round down a hcp to the whole number.
Example if a bowler finished with a 188.78 average the handicap shows 10.098 Based on 90% of 200.

I tried using the rounddown calc but either i entered it wrong and or too silly to follow it

thanks lefty

I have attached it if someone can help tar

 

[ratty133]

right click the cell, click 'format cell', click on number down the side panel, then change the number of decimal points option to 0.

hope this helps.

 

[DaleS]

Hi lefty,

The formula in your spreadsheet in the cell should be =rounddown(c2*90%, 0).To do this you just click on the field you want the formula in and type in the formula bar =rounddown(C2*90%, 0) and press enter, then excel will do the rest.

 

[leftos]

Hello

Thanks guys. Dale worked like a treat


lefty

 

[poppy62]

To show a handicap as a whole number only, you need to format that cell. Go into format cells, click on number & reduce decimal places to zero.
I used to use the IF command when calculating handicaps. Based on your sheet of 90% of 200, try typing into cell D2 the following:
if(B2>=199,0,(200-B2)*90%)
Go to another cell, It should now show the handicap for cell B2.
The good thing about this formula is if your average goes above 199, it will automatically show a zero.
Good Luck