We help IT Professionals succeed at work.

round function

Ian Bell
Ian Bell asked
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

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 :)
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. :)