# Rounding 2 decimals to specific 2 decimals

1. ## Rounding 2 decimals to specific 2 decimals

Hello,
I have an column filled with numbers like :
1.25
0.89
2.32
1.07
1.25
1.07
etc.

I can't figure out how to approximate the decimals , in the next column , with a function with the next conditions :
if decimals are between 00 and 24 the result should be 00.
if decimals are between 25 and 75 the result should be 50.
if decimals are between 76 and 99 the result should be rounding up the number.

Thank you.

2. ## Re: Rounding 2 decimals to specific 2 decimals

Try this ...

=MROUND(A1,0.5)

3. ## Re: Rounding 2 decimals to specific 2 decimals

=int(a1)+lookup(mod(a1,1),{0,0.25,0.76},{0,0.5,1})

4. ## Re: Rounding 2 decimals to specific 2 decimals

Originally Posted by nflsales
=int(a1)+lookup(mod(a1,1),{0,0.25,0.76},{0,0.5,1})
It worked , thank you.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1