ROUNDING UP OR DOWN depending on percentage result

[Glacombe]

I would like to know what would be the formula to either round up or round down a percentage amount. For example I have the following formula:
= P3/12*AK3
It calculates original percentage amount which is 5%(cell P3) and divides it by 12 and then multiply by amount of months which in this case is 8 months that is identified in AK3.
The result is 3.33333% which I would like the result to be only 3.33 as the .3 is below 5
In another cell I have the percentage 10% and divides it by 12 and then multiply by 7 months which gives the result as 5.83333 which I would like the result to be 5.84 as the .8 is above 5
What would the formula would be to either round down if it is .3 and below or round up if it is .5 above?
Thanks

 

[Glacombe]

Hi Scott
in P3 I have the VLOOKUP formula that gets the data from another sheet in my workbook and the percentage is 5
in AK3 I have a formula that calculates the amount of months from a start date of a cell and end date of another cell which is the number 8
in AD3 is where I have the result which is the formula I inserted from you which is
= ROUNDDOWN(P3/1AK3,2)+((MOD(P3/12*AK3,1)>0.5)*0.01)
The format in P3 and AD3 is in percentage

 

[Scott Huish]

OK, try this:
=ROUND(P3/12*AK3,4)+((MOD(ROUND(P3/12*AK3,4)*100,1)>0.5)*0.0001)

 

[Glacombe]

Thank you so very much for all your time, it works ;o)