• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need help with round of values

udprocks

Member
Hallo All,

Can anyone please help me with this.

i want to rounding the values.

For example:

figure which is close 5 should be rounded to 5 ie 3202 should be 3205
and 3207 should be 3210.

Have also attached a sample file with desired result.

Thanks in advance.
 

Attachments

  • rounding value.xlsx
    8.9 KB · Views: 0
Hallo All,

Can anyone please help me with this.

i want to rounding the values.

For example:

figure which is close 5 should be rounded to 5 ie 3202 should be 3205
and 3207 should be 3210.

Have also attached a sample file with desired result.

Thanks in advance.
hello

pls check if this works for u..

regards,
 

Attachments

  • Copy of rounding value.xlsx
    9.6 KB · Views: 0
hello

pls check if this works for u..

regards,

Hallo Again mam,

from this formula all thing is ok but in one case i have another query

when amount is 2180.04 and from this formula its giving me 2185, but we need to keep it 2180 only, see the attached file plz in highlighted yellow cell,.
 

Attachments

  • Copy of rounding value.xlsx
    9.5 KB · Views: 0
Hallo Again mam,

from this formula all thing is ok but in one case i have another query

when amount is 2180.04 and from this formula its giving me 2185, but we need to keep it 2180 only, see the attached file plz in highlighted yellow cell,.
in that case u need to use this =MROUND(A21,5)
 
Hi:

Try the following formula.
Code:
=IF(RIGHT(ROUND(A2,0))+0<=5,MROUND(A2,5),MROUND(A2,10))

Thanks
Hi Nebu,

Thanks for formula and efforts, there is still one diffrence with this formula.

but thanks a lot for this formula also.
 
Back
Top