Round function

Muthukrishnan V

Board Regular
Joined
May 29, 2008
Messages
179
Office Version
  1. 365
Platform
  1. Windows
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,
 

Some videos you may like

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
Joined
Mar 2, 2014
Messages
2,842
Office Version
  1. 2010
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

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