• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 134
  • Last Modified:

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
0
racepro
Asked:
racepro
  • 3
  • 2
  • 2
1 Solution
 
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
 
raceproAuthor Commented:
Hi xtermie,
can you pls insert it into the attached formula in spreadsheet
Thanks
0
 
xtermieCommented:
I will in a bit as I'm on my phone app right now :)
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
raceproAuthor Commented:
ok thanks
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Please try this..

In E14
=MROUND(E3,0.2)

Open in new window

and copy down.
Round-Formula.xlsx
0
 
raceproAuthor Commented:
Thanks Neeraj,
It works
Ian
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome Ian! Glad to help. :)
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now