LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default I need to Round Cells up to next .99$

i have all kinds of different prices for items that i need to make all of
them no matter what the margin i give it it turns that cell to the next .99$
never rounding down only up even if its 15.01$ i need it to go to 15.99$
thanks for 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
Sumif trying to Sum cells with Round Function Mike H. Excel Discussion (Misc queries) 5 August 14th 08 01:27 PM
How do I format cells to round up? Tom Excel Worksheet Functions 6 March 3rd 08 10:50 PM
Increase all cells by a % and round up? sacredarms Excel Discussion (Misc queries) 1 December 11th 05 03:04 AM
round up cells to $xx.99 RVV Excel Worksheet Functions 2 March 31st 05 08:31 PM
How do I format cells to round to the nearest thousands without .. excel user Excel Discussion (Misc queries) 1 March 16th 05 08:10 PM


All times are GMT +1. The time now is 02:01 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"