Previous Topic Next Topic

ROUNDING FUNCTION

Solved/Closed
Winndixie Posts 20 Registration date Monday March 10, 2014 Status Member Last seen September 28, 2018 - Jun 4, 2015 at 10:39 PM
Winndixie Posts 20 Registration date Monday March 10, 2014 Status Member Last seen September 28, 2018 - Jun 5, 2015 at 10:25 AM
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!



Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jun 5, 2015 at 06:46 AM
download the file from

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

and see column B. is it ok?
0
Winndixie Posts 20 Registration date Monday March 10, 2014 Status Member Last seen September 28, 2018
Jun 5, 2015 at 10:25 AM
Thank you very much!! is work !! :D
0

Similar discussions

"Sorry, this feature isn't available ... " how to fix this?
Anonymous User -
heclam -

3 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to disable Fn keys
HENRY -
ZiaRahman -

30 responses
If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response