Round up

[#1]

How can I round up or round down an expression?

I need to round up the follow expression:

=SUM([Labor Rate])/COUNT([Labor Rate])

Actually the result value is 85.076987481, I need something like: 85.08

how can I do it?

Thanks;
Best regards;

[IAMDV · Accepted solution]

Please use this...

=Round(SUM([Labor Rate])/COUNT([Labor Rate]), 0.01)

OR

=Ceil(SUM([Labor Rate])/COUNT([Labor Rate]), 0.01)

Use FLOOR for...

Rounding of x downwards to the nearest multiple of base with an
offset of offset. The result is a number.

=floor( 2.4 ) returns 2

Rounding of x upwards to the nearest multiple of base with an offset
of offset. The result is a number.

=ceil( 3.88 , 0.1 ) returns 3.9

Please mark the post answered, if this helps!

[#3]

Thanks!

[#4]

Hello kellyhbastos

if you recognized a post as the correct solution, would you mark this post as a varified answer. So the thread will be marked green and can be seen as solved.

Rgeards, Roland

[IAMDV]

kellyhbastos - Roland is right. Please mark the post as verified if it works for you. Or we can help you further...