LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
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?
 
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 06: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 12: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 01:21 AM.

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

About Us

"It's about Microsoft Excel"