Excel 2007 : Rounding a %

[stevetothink]

Is it possible to round a % to the nearest 5? For example, 134% becomes 135%.

Thanks

[shg]

=MROUND(134%, 5%) (requires Analysis Toolpak in Excel 2003-)

or

=ROUND(134%/5%, 0)*5%

[MarvinP]

Put a value in A1 and try this formula on it:

Please Login or Register  to view this content.

See if that does it for you. Ponder the 1.33 though, does it round to 1.35 or 1.30? I have all .03 rounding up.

[stevetothink]

=MROUND(134%, 5%) (requires Analysis Toolpak in Excel 3003-)

or

=ROUND(134%/5%, 0)*5%

Beautiful - thank you!