Remember Me?

#1
Posted to microsoft.public.excel.misc
 external usenet poster Posts: 40
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?
#2
 Excel Super Guru Posts: 1,867
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!
__________________
I am not human. I am an Excel Wizard
#3
Posted to microsoft.public.excel.misc
 external usenet poster Posts: 1,560
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?

#4
Posted to microsoft.public.excel.misc
 external usenet poster Posts: 921
Round price to end in .99

"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?

#5
Posted to microsoft.public.excel.misc
 external usenet poster Posts: 913
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

#6
Posted to microsoft.public.excel.misc
 external usenet poster Posts: 40
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

#7
Posted to microsoft.public.excel.misc
 external usenet poster Posts: 35,218
Round price to end in .99

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
#8
 Junior Member Posts: 1
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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Ms. Latte[_2_] Excel Discussion (Misc queries) 1 August 8th 08 12:29 PM Ian_W-at-GMail Excel Discussion (Misc queries) 5 March 21st 07 06:45 PM Philippa Excel Worksheet Functions 2 January 12th 06 12:57 PM JJ Excel Discussion (Misc queries) 1 May 27th 05 03:57 PM Millsy Excel Worksheet Functions 1 May 18th 05 02:20 PM

All times are GMT +1. The time now is 04:14 PM.