LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mj99
 
Posts: n/a
Default Roundup to .99 endings


Trying to get every number in an excel file to roundup for retail price
points....

20.34 = 20.99
38.75 = 38.99

thanks in advance!


--
mj99
------------------------------------------------------------------------
mj99's Profile: http://www.excelforum.com/member.php...o&userid=35647
View this thread: http://www.excelforum.com/showthread...hreadid=554321

 
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
how to use roundup r4319hb Excel Discussion (Misc queries) 2 December 24th 05 01:27 PM
Roundup to the nearest number that is divisible by 3 Raju Boine. Excel Worksheet Functions 1 June 22nd 05 01:15 PM
How do I apply the ROUNDUP formula to a range of calculated data IslandGreenHouse Excel Worksheet Functions 1 May 28th 05 10:12 PM
How do I use Roundup in a logical test in excel DC Excel Worksheet Functions 3 March 9th 05 05:27 PM
roundup seconds to minute obi-akpere Excel Worksheet Functions 1 January 7th 05 12:50 PM


All times are GMT +1. The time now is 05:50 AM.

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

About Us

"It's about Microsoft Excel"