Unit Stake / Rounding Calculations....

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.

Unit Stake / Rounding Calculations....