Unit Stake / Rounding Calculations.... (1 Viewer)

GUIDO22

Registered User.
Local time
Today, 11:24
Joined
Nov 2, 2003
Messages
515
Hi All
I am trying to come up with a cell combo that will do the following ..

When betting, sometimes it is necessary to consider a minimum stake. When the stakes are calculated automatically, it is necessary to round up the calculated stake in accordance and to the nearest unit stake.

Consider the following :
Variables :
Rounding Direction : Up/Down
Unit stake as shown in each example below...

Exmaples :
Unit stake : 0.10p
Stake : £4.34 -> is rounded UP to £4.40
Stake : £4.34 -> is rounded DOWN to £4.30

Unit stake : 0.20p
Stake : £4.34 -> is rounded UP to £4.40
Stake : £4.34 -> is rounded DOWN to £4.20

Unit stake : 0.50p
Stake : £4.34 -> is rounded UP to £4.50
Stake : £4.34 -> is rounded DOWN to £4.00

Unit stake : £1.00
Stake : £4.34 -> is rounded UP to £5.00
Stake : £4.34 -> is rounded DOWN to £4.00

Trust this makes sense.....

Can anyone suggest a nice and reasonably simple way to do this in Excel please.....

Thank you in advance.
 

Mile-O

Back once again...
Local time
Today, 11:24
Joined
Dec 10, 2002
Messages
11,316
You want to look into the FLOOR and CEILING functions.
 

GUIDO22

Registered User.
Local time
Today, 11:24
Joined
Nov 2, 2003
Messages
515
Mile-O
Wow - thanks just what I needed!

Cheers
 

Users who are viewing this thread

Top Bottom