Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 17th 09, 09:18 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 40
Default 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   Report Post  
Old August 17th 09, 09:27 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,560
Default 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?

  #3   Report Post  
Old August 17th 09, 09:30 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 921
Default 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?

  #4   Report Post  
Old August 17th 09, 09:31 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2008
Posts: 913
Default 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
  #5   Report Post  
Old August 17th 09, 09:49 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 40
Default 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



  #6   Report Post  
Old August 17th 09, 09:51 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default 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
  #7   Report Post  
Old November 15th 18, 03:52 PM
Junior Member
 
First recorded activity by ExcelBanter: Nov 2018
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help in round up or down price to specific ending number Ms. Latte[_2_] Excel Discussion (Misc queries) 1 August 8th 08 12:29 PM
Help: Need Excel formula to return correct price from price history table Ian_W-at-GMail Excel Discussion (Misc queries) 5 March 21st 07 07:45 PM
How do I tell a price list to round up and down to the nearest 25 Philippa Excel Worksheet Functions 2 January 12th 06 01:57 PM
How do I round a price up or down to ##.99 JJ Excel Discussion (Misc queries) 1 May 27th 05 03:57 PM
How do i round up a price to the nearest 5,10,15 etc pence Millsy Excel Worksheet Functions 1 May 18th 05 02:20 PM


All times are GMT +1. The time now is 06:20 PM.

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017