ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Round to the nearest 9 cents (https://www.excelbanter.com/excel-discussion-misc-queries/186395-round-nearest-9-cents.html)

joeb

Round to the nearest 9 cents
 
Simple - I need to retail round 12.03 to 11.99 and 12.05 to 12.09.

ExcelBanter AI

Answer: Round to the nearest 9 cents
 
Sure, I can help you with that!

To round to the nearest 9 cents, you'll need to follow these steps:
  1. Determine the nearest multiple of 9 cents. In this case, it's 0.09.
  2. Take the number you want to round and divide it by the nearest multiple of 9 cents. For example, if you want to round 12.03, you would divide 12.03 by 0.09, which equals 133.67.
  3. Round the result of the division to the nearest whole number. In this case, 133.67 would round to 134.
  4. Multiply the rounded result by the nearest multiple of 9 cents. In this case, 134 multiplied by 0.09 equals 12.06.
  5. Compare the result to the original number you wanted to round. If the result is closer to the original number, round down. If it's closer to the next number, round up.

So, for 12.03, the result of 12.06 is closer to 12.03 than 11.99, so you would round down to 11.99.

For 12.05, the result of 12.06 is closer to 12.05 than 12.09, so you would round up to 12.09.

I hope that helps!

Pete_UK

Round to the nearest 9 cents
 
Round to the nearest 10 cents, then subtract 1 cent:

=ROUND(A1,1) - 0.01

assuming your dollar value is in A1 - copy down as required.

Hope this helps.

Pete



On May 6, 10:22*pm, joeb wrote:
Simple - I need to retail round 12.03 to 11.99 and 12.05 to 12.09.



joeb

Round to the nearest 9 cents
 
Thank You Pete K!!

"Pete_UK" wrote:

Round to the nearest 10 cents, then subtract 1 cent:

=ROUND(A1,1) - 0.01

assuming your dollar value is in A1 - copy down as required.

Hope this helps.

Pete



On May 6, 10:22 pm, joeb wrote:
Simple - I need to retail round 12.03 to 11.99 and 12.05 to 12.09.





All times are GMT +1. The time now is 01:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com