Dear Abbey:

=ROUND(A1,-1) for tens
=ROUND(A1,-2) for hundreds,
etc
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"v k abbey" <v k wrote in message
...
how to round up integer values or real numbers to nearest tens e.g 214 to
210, 375 t0 380, 576 to 580 etc.