round function

Ian Bell
Ian Bell used Ask the Experts™
on
Hi,
I would like help to add a round formula on attached sheet column E (Yellow background)
round to nearest 0.2
Thanks
Ian
Round-Formula.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2011

Commented:
=round(number, 2) for two decimals
If you want it to round to thousands
=ROUND(number,-3)

Number can be a formula too
Ian Bellretired

Author

Commented:
Hi xtermie,
can you pls insert it into the attached formula in spreadsheet
Thanks
Top Expert 2011

Commented:
I will in a bit as I'm on my phone app right now :)
Angular Fundamentals

Learn the fundamentals of Angular 2, a JavaScript framework for developing dynamic single page applications.

Ian Bellretired

Author

Commented:
ok thanks
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
Please try this..

In E14
=MROUND(E3,0.2)

Open in new window

and copy down.
Round-Formula.xlsx
Ian Bellretired

Author

Commented:
Thanks Neeraj,
It works
Ian
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
You're welcome Ian! Glad to help. :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial