danyra Posted December 14, 2019 Share 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 Link to comment Share on other sites More sharing options...
hanhphuc Posted December 14, 2019 Share Posted December 14, 2019 search lee mac round Quote Link to comment Share on other sites More sharing options...
Lee Mac Posted December 14, 2019 Share 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 Link to comment Share on other sites More sharing options...
danyra Posted December 15, 2019 Author Share 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 Link to comment Share on other sites More sharing options...
danyra Posted December 15, 2019 Author Share Posted December 15, 2019 16 hours ago, hanhphuc said: search lee mac round THANKS ALSO FOR RECOMENDATION Quote Link to comment Share on other sites More sharing options...
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.