Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Worksheet Functions > Roundup or rounddown
 
 
LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Heather
 
Posts: n/a
Default Roundup or rounddown
HI, I need a way to roundup if = .50 and rounddown <.49

1.86 = 2
1.5 = 2
1.49 = 1
7.25 = 7

Thanks


--
Heather
Reply With QuoteReply With Quote
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Threaded Mode Threaded Mode

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
roundup within a formula fwb Excel Worksheet Functions 2 February 18th 09 08:23 PM
ROUNDUP copy/paste and fill handle not working Jason Southco Excel Worksheet Functions 1 October 10th 05 05:41 PM
Roundup for multiple cells STK Excel Discussion (Misc queries) 1 September 28th 05 04:21 PM
roundup within a formula David Billigmeier Excel Worksheet Functions 0 September 7th 05 01:10 AM
Roundup K.S.Warrier Excel Worksheet Functions 0 November 24th 04 10:05 AM


All times are GMT +1. The time now is 03:52 PM.

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"

 

Contact Us ExcelBanter forum home Privacy Statement