ROUNDING FUNCTION [Solved/Closed]

Report
Posts
23
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 28, 2018
-
Winndixie
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
790
download the file from

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

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

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