round function

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
raceproretiredAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
Please try this..

In E14
=MROUND(E3,0.2)

Open in new window

and copy down.
Round-Formula.xlsx
0
 
xtermieCommented:
=round(number, 2) for two decimals
If you want it to round to thousands
=ROUND(number,-3)

Number can be a formula too
0
 
raceproretiredAuthor Commented:
Hi xtermie,
can you pls insert it into the attached formula in spreadsheet
Thanks
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
xtermieCommented:
I will in a bit as I'm on my phone app right now :)
0
 
raceproretiredAuthor Commented:
ok thanks
0
 
raceproretiredAuthor Commented:
Thanks Neeraj,
It works
Ian
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome Ian! Glad to help. :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.