I need some help with rounding to the nearest .01 if for example a calculation equals 1.005 I want it to round to 1.00 not 1.01.
By default Round(x,2) rounds 1.005 to 1.01 but I need it to round down to 1.00 if the thousands place is 5.
Any help would be much appreciated.
Try:
Formula:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Nope does not work, its still rounding up when the 000 place is 5.
Try this formula
=CEILING(A1-0.005,0.01)
Audere est facere
Bingo! Thank you.
It worked for me?
A1=1.005
B1=MROUND(A1*100,1)/100
B1=1
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks