Division Formula & ROUNDING UP

[RudeBoy]

Im running a league and I have x amount of players paying $13.50 a week.

I am trying to get a formula set-up for this that ROUNDSUP

Example for week #1 the total money collected was $1,374
If I divide that =C9/13.5 by $13.50 it comes up with 101.7777778

Now what I am trying to come up with is 102 by rounding up as it did not come up even meaning something was off but still needed it to be 102 players. Because 102 x 13.50 = 1377 which is close enough 3 dollars off.

How can I accomplish this with a formula? Helpppppppp Thanks so much

 

[RudeBoy]

Need Help with results for a Division Formula =D9/1350

I am running a League and have X amount of Players.

Total Money amount for Week # 2 = $1,822.50

I am taking this number and dividing it by the amount each player payes each week which is 13.50

So I am using Formula =D9/1350 but the result is not coming up 135 which is the number of players that paid $13.50 instead it is showing 1.35

How can I correct this by either using a custom format or by changing my FORMULA - Helpppppppppppppppppppp

Thanks so much

 

[shg]

Re: Need Help with Division Formula & ROUNDING UP - Thanks

=CEILING(C9/13.5, 1)

or

=ROUNDUP(C9/13.5, 0)

 

[shg]

Re: Need Help with results for a Division Formula =D9/1350

=d9/13.50

 

[Fluff]

Re: Need Help with results for a Division Formula =D9/1350

@RudeBoy
Please do not post duplicate threads.
I have merged both threads.