# Round function

#### Muthukrishnan V

##### Board Regular
Office 365

Round function

I want to round the sum amount to the nearest 10s. Decimals to be ignored.

For example the Cell contains 12924.85 (in numerical format). I want
this rounded to 12920 ignoring decimals and last digit <5 reduced to lower 10.

If Cell contains 12925.15, this is to be rounded to 12930 ignoring decimals
and the last digit =>5 to higher 10

Kindly advise formula. Thanking you,

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

#### joeu2004

##### Well-known Member
ROUND(12924.85, -1) returns 12920.

ROUND(12925.15 , -1) returns 12930.

Let us know if there is an example where ROUND(...,-1) does not do what you want.

Thank you Sir

Replies
3
Views
48
Replies
1
Views
84
Replies
3
Views
48
Replies
5
Views
120
Replies
1
Views
266

1,114,194
Messages
5,546,487
Members
410,742
Latest member
WalterSil