ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Round price to end in .99 (https://www.excelbanter.com/excel-discussion-misc-queries/239961-round-price-end-99-a.html)

Chip

Round price to end in .99
 
I want to raise prices by 5% and have the resulting price end in xxxx.99.
For example, my resulting price would be $15.67, I want the result to
actually be $15.99. Any help?

ExcelBanter AI

Answer: Round price to end in .99
 
Yes, I can definitely help you with that! Here's how you can round your prices to end in .99 after increasing them by 5%:
  1. Start by multiplying your original price by 1.05 to increase it by 5%. For example, if your original price is $15.00, you would multiply it by 1.05 to get $15.75.
  2. Next, subtract the remainder when you divide the result from step 1 by 1. This will give you a number that ends in .xx. For example, if your result from step 1 is $15.75, you would subtract 0.75 to get $15.00.
  3. Finally, add 0.99 to the result from step 2 to get your final rounded price that ends in .99. For example, if your result from step 2 is $15.00, you would add 0.99 to get $15.99.

So in summary, to round your price to end in .99 after increasing it by 5%, you would multiply your original price by 1.05, subtract the remainder when you divide the result by 1, and then add 0.99 to the result. I hope that helps!

David

Round price to end in .99
 
try =roundup(a1,0)-.01
assuming data to round is in cell a1


"Chip" wrote:

I want to raise prices by 5% and have the resulting price end in xxxx.99.
For example, my resulting price would be $15.67, I want the result to
actually be $15.99. Any help?


Jeff

Round price to end in .99
 
How about =round(price,0)-.01

"Chip" wrote:

I want to raise prices by 5% and have the resulting price end in xxxx.99.
For example, my resulting price would be $15.67, I want the result to
actually be $15.99. Any help?


Lars-Åke Aspelin[_2_]

Round price to end in .99
 
On Mon, 17 Aug 2009 13:18:01 -0700, Chip
wrote:

I want to raise prices by 5% and have the resulting price end in xxxx.99.
For example, my resulting price would be $15.67, I want the result to
actually be $15.99. Any help?



Try this formula:

=ROUNDUP(A1,0)-0.01

Hope this helps / Lars-Åke

Chip

Round price to end in .99
 
Thanks.....it worked just as requested. I appreciate your help.

"Lars-Ã…ke Aspelin" wrote:

On Mon, 17 Aug 2009 13:18:01 -0700, Chip
wrote:

I want to raise prices by 5% and have the resulting price end in xxxx.99.
For example, my resulting price would be $15.67, I want the result to
actually be $15.99. Any help?



Try this formula:

=ROUNDUP(A1,0)-0.01

Hope this helps / Lars-Ã…ke


Dave Peterson

Round price to end in .99
 
Check your other post.

Chip wrote:

I want to raise prices by 5% and have the resulting price end in xxxx.99.
For example, my resulting price would be $15.67, I want the result to
actually be $15.99. Any help?


--

Dave Peterson

markobenda

Round a price/number to end 90 or 900
 
Hello. Im trying to use Round function to round prices to end 900. I have 5 or 6 digit numbers without decimal ie ( 23450, 234500). When trying to use formula: =ROUND(AF2,0)-0.01 excel give me an error:

Not trying to type a formula?

When the first character is an equal (=) or minus (-) sign, Excel thinks it's a formula:

• you type: =1+1, cell shows: 2

To get around this, type an apostrophe ( ' ) first:

• you type: '=1+1, cell shows: =1+1

I need help with this formula. Tried all options.

Thank you

Marko


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

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