Muthukrishnan V
Active Member
- Joined
- May 29, 2008
- Messages
- 269
- Office Version
- 365
- Platform
- 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,
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,