The latest articles on DEV Community by dan-simiyu (@dansimiyu). https://dev.to/dansimiyu https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F401419%2F6bd4d2eb-de8c-42b3-8f90-91ee4b5efbd4.jpeg https://dev.to/dansimiyu en dan-simiyu Tue, 08 Sep 2020 07:54:00 +0000 https://dev.to/dansimiyu/answer-mysql-round-up-to-nearest-5-cents-p4b https://dev.to/dansimiyu/answer-mysql-round-up-to-nearest-5-cents-p4b <div class="ltag__stackexchange--container"> <div class="ltag__stackexchange--title-container"> <div class="ltag__stackexchange--title"> <h1> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--7Gn-iPj_--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev.to/assets/stackoverflow-logo-b42691ae545e4810b105ee957979a853a696085e67e43ee14c5699cf3e890fb4.svg" alt=""> <a href="https://stackoverflow.com/questions/13081897/mysql-round-up-to-nearest-5-cents/46329732#46329732" rel="noopener noreferrer"> <span class="title-flare">answer</span> re: MySQL Round Up to Nearest 5 Cents </a> </h1> <div class="ltag__stackexchange--post-metadata"> <span>Sep 20 '17</span> </div> </div> <a class="ltag__stackexchange--score-container" href="https://stackoverflow.com/questions/13081897/mysql-round-up-to-nearest-5-cents/46329732#46329732" rel="noopener noreferrer"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--Y9mJpuJP--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev.to/assets/stackexchange-arrow-up-eff2e2849e67d156181d258e38802c0b57fa011f74164a7f97675ca3b6ab756b.svg" alt=""> <div class="ltag__stackexchange--score-number"> 7 </div> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--wif5Zq3z--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev.to/assets/stackexchange-arrow-down-4349fac0dd932d284fab7e4dd9846f19a3710558efde0d2dfd05897f3eeb9aba.svg" alt=""> </a> </div> <div class="ltag__stackexchange--body"> <p>Since 100/5 = 20 all we do is multiply by 20, round up to the nearest whole number, and then divide by 20. </p> <p>(To round up in MySQL use CEIL)</p> <p>Example for $1.03: </p> <pre><code>1.03 * 20 = 20.60 CEIL(20.60) = 21.0000 21 / 20 = 1.0500 </code></pre> <p>NOTE: I also round…</p> </div> <div class="ltag__stackexchange--btn--container"> <a href="https://stackoverflow.com/questions/13081897/mysql-round-up-to-nearest-5-cents/46329732#46329732" rel="noopener noreferrer">Open Full Answer</a> </div> </div>