Ian Bell
asked on
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
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
ASKER
Hi xtermie,
can you pls insert it into the attached formula in spreadsheet
Thanks
can you pls insert it into the attached formula in spreadsheet
Thanks
I will in a bit as I'm on my phone app right now :)
ASKER
ok thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Neeraj,
It works
Ian
It works
Ian
You're welcome Ian! Glad to help. :)
If you want it to round to thousands
=ROUND(number,-3)
Number can be a formula too