GUIDO22
Registered User.
- Local time
- Today, 22:16
- 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.
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.