Formula to round a percentage to the nearest multiple of 10

[Maqsood]

Hi,
Is there a formula in excel which help to round up the percentage to the nearest multiple of 10.
Eg: if there is a value in cell A1 which is 103%, the formula should round up the value as 100%.
If value is 106 it should consider the value as 110%.

Please advise

Thanks
Abdul rahiman

 

[Khalid NGO]

Hi Abdul,
Can you share more example?

Not sure this is okay:
=ROUND(A1,1)

Regards,

 

[Hui]

Adbul

=MROUND(A1,0.1)

Remember that 103% is actually 1.03 with a Custom Format display

MRound allows formatting to any place and so a value of 0.1 will do the trick for you

 

[NARAYANK991]

Hi ,

Please see this file for some strange behaviour.

Narayan

 

[Maqsood]

Hi,

Thank you. Both Round & MRound function helped in fixing my file. it is working fine for percentage calculation.
but for decimal points as in the attachment above, these functions show strange behavior.

Abdul Rahiman

 

[Deepak]

Hi,

Check this...

=ROUND(A1/0.1,0)*0.1