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

 

[Nine Zero]

try this out assuming your number is in P3

=CEILING.MATH(P3, 0.01)

EDIT: sorry this will not work.. tyring to get you anther answer

 

[Glacombe]

try this out assuming your number is in P3

=CEILING.MATH(P3, 0.01)

EDIT: sorry this will not work.. tyring to get you anther answer

The percentage amout is identified in P3 and the formula identified in my question is in AC3, this is where I would like to either round up or down

 

[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

I have not received any suggestions yet does anybody know what the formula would be? thanks

 

[Indystick]

It may not be the most elegant solution, but I found this to work in limited testing (A1 is cell where I had my test number):

=IF(NUMBERVALUE(MID(A1,SEARCH(".",A1),2))>=0.5,ROUNDUP(A1,2),ROUNDDOWN(A1,2))

For my test number I used this formula to generate a random test number:

=RANDBETWEEN(1,10)+RAND()

 

[Scott Huish]

=rounddown(p3/12*ak3,2)+((mod(p3/12*ak3,1)>0.5)*0.01)

 

[Indystick]

=rounddown(p3/12*ak3,2)+((mod(p3/12*ak3,1)>0.5)*0.01)

Good idea using the MOD()! Here is what I came up with:

=IF[MOD(P3/12*AK3,1)>.5,ROUNDUP(P3/12*AK3,2),ROUNDDOWN(P3/12*AK3,2))

Scott's code does the same thing I believe.

 

[Glacombe]

Thanks for this I would like it to be:
if result is 3.333333 round to 3.33
if result is 3.833333 round to 3.34

 

[Indystick]

That is what the formulas suggested do.

 

[Scott Huish]

Why would the second one be 3.34 when the value in the tenths place is 8? Shouldn't it be 3.84?