ROUNDING FUNCTION [Solved/Closed]

Report
Posts
23
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 28, 2018
-
Posts
23
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 28, 2018
-
Hello,

Good day!!


For the Excel rounding function normally is 4 down 5 up is it possible that rounding the digit as below request?

115.21 - 115.22 = 115.20
115.23 - 115.24 = 115.25
115.26 - 115.27 = 115.25
115.28 - 115.29 = 115.30

my work file normally need 2 decimal and I need the last reading read as 0 or 5

I need a formula help me done my work auto adjust instead manual work.

thank you very much!



1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
792
download the file from

http://speedy.sh/c4chT/winndixie-150605.xlsx

and see column B. is it ok?
Posts
23
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 28, 2018

Thank you very much!! is work !! :D

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!