ROUNDUP

[NOCHOKE]

I am pretty much a novice at this, so if you can and would like to help, please keep your suggestions simple... You've heard of Napolean's Idiot, right? btw, I am using Office 97.

So, what I am trying to do is to get the result of a formula to roundup. I am the secretary for a golf league and want my spreadsheet to compute players' handicaps. Our league uses a simple 80% of the difference between par and your score (rounded up to the next whole number) as the handicap.

Say a player shoots a 39, and par is 36, the difference is 3. 80% of 3 is 2.4. The formula I use to get to the 2.4 is:

=(A1-36)*80%

A1 is the score the player shot. How do I get Excel to round this result up to the next whole number?

 

[Mark W.]

On 2002-05-08 19:37, NOCHOKE wrote:
Aladin, I couldn't get yours to work.

Mark, With yours I get the right result in A2, but it does not change when I add test figures in B1, C1, D1, etc. What am I missing?

You need to copy (or fill) my formula [ =ROUNDUP((SUM(OFFSET(A1,,-MIN(3,COLUMN()-1),,MIN(4,COLUMN())))-MIN(4,COLUMN())*36)*80%,0) ] entered into cell A2 to B2, C2, D2, E2, etc. As you requested ("After week 4, we go to a handicap based on the same 80% as noted above, except that we use the last four rounds only.") my formula provides results in A2 based on A1, in B2 based on A1:B1, in C2 based on A1:C1, in D2 based on A1:D1, in E2 based on B1:E1, in F2 based on C1:F1, etc.
This message was edited by Mark W. on 2002-05-09 08:09