Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
|
|||
|
|||
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%:
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
|
|||
|
|||
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
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
#8
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help in round up or down price to specific ending number | Excel Discussion (Misc queries) | |||
Help: Need Excel formula to return correct price from price history table | Excel Discussion (Misc queries) | |||
How do I tell a price list to round up and down to the nearest 25 | Excel Worksheet Functions | |||
How do I round a price up or down to ##.99 | Excel Discussion (Misc queries) | |||
How do i round up a price to the nearest 5,10,15 etc pence | Excel Worksheet Functions |