danyra Posted December 14, 2019 Posted December 14, 2019 I have two instances: 1) I have the number for example 1.025, and I want the computer give me as answer 1.10, other example will be: I have 1.08, and I want the computer give me as answer 1.10. its like a rounding up. 2)I have the number for example 0.7625, and I want the computer give me as answer 0, 7 other example will be: I have 0.51, and I want the computer give me as answer 0.5 (can use the first decimal) its like a rounding down ¿How can I do? the code "round" doesnt exist anymore. Quote
Lee Mac Posted December 14, 2019 Posted December 14, 2019 You may use my LM:roundup & LM:rounddown functions, supplied with a rounding multiple of 0.1: _$ (LM:roundup 1.025 0.1) 1.1 _$ (LM:roundup 1.08 0.1) 1.1 _$ (LM:rounddown 0.7625 0.1) 0.7 _$ (LM:rounddown 0.51 0.1) 0.5 @hanhphuc Thanks for the recommendation 1 Quote
danyra Posted December 15, 2019 Author Posted December 15, 2019 13 hours ago, Lee Mac said: _$ (LM:roundup 1.025 0.1) 1.1 _$ (LM:roundup 1.08 0.1) 1.1 _$ (LM:rounddown 0.7625 0.1) 0.7 _$ (LM:rounddown 0.51 0.1) 0.5 THANKS ITS WORKS Quote
danyra Posted December 15, 2019 Author Posted December 15, 2019 16 hours ago, hanhphuc said: search lee mac round THANKS ALSO FOR RECOMENDATION Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.