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]

Thank you Scott my mistake I meant 3.84, its Friday and I have been working on this all day.

 

[Scott Huish]

Then the formulas provided should work, can you please provide the values in the cells where it doesn't?

 

[Glacombe]

Thanks again Scott, there is a cell that the result is 5.83333, when it should be 5.84

 

[Scott Huish]

And what are the values in the cells referenced in the formula? And can you post which formula you're using?

 

[Glacombe]

Thank you Scott, the values in the cells referenced are:
P3: The percentage from a VLOOKUP formula
AK3: is a formula that calculates amount of months from start date and end date and then divides the percentage reference in P3 by 12 and multiply by amounts of months reference in AK3

 

[Scott Huish]

That's not what I mean, what are the actual numbers in the cells? I can't try and replicate the problem if I don't know what the numbers are.

 

[Glacombe]

Sorry Scott, in one of the rows the number in P3 is 5% and the number in AK3 is 8 which the result is 3.333333 (I need this one to round to 3.33)
in another row, the number in P3 is 10% and the number in AK3 is 7 which the result is 5.833333 (I need this one to round to 5.84)

 

[Scott Huish]

And it does. I have always assumed for the sake of this thread that your value in P3 is not actually a percent; 10% (which would be .1) but the actual number 10.

Excel 2010
	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL
3	10																					7	5.84
Sheet1

Cell Formulas
Range	Formula
AL3	=ROUNDDOWN(P3/12*AK3,2)+((MOD(P3/12*AK3,1)>0.5)*0.01)

 

[Glacombe]

Thank you Scott, tried the above formula and the result gives me a rounddown to 3.00%

 

[Scott Huish]

Are the values in your cells exactly as in my sample?
Can you post the formula exactly as you have used it?