+ Reply to Thread
Results 1 to 3 of 3
  1. 01-10-2010, 11:56 AM #1
    thford
    thford is offline
    Registered User
    Join Date
    01-09-2010
    Location
    Pepperell, MA usa
    MS-Off Ver
    Excel 2003
    Posts
    1

    roundup in an "IF" function

    I am using a simple "IF" function, but I need to express the result rounded up to the next whole number. I've tried to insert "ROUNDUP" into the "IF" function, but I keep getting errors.
    Reply With Quote Reply With Quote
  2. 01-10-2010, 12:01 PM #2
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Cochrane,Alberta
    MS-Off Ver
    XL 2003,2007
    Posts
    6,259

    Re: roundup in an "IF" function

    SOmething like this?
    =IF(A1>1,ROUNDUP(A1,2),"")
    Dave

    Reply With Quote Reply With Quote
  3. 01-10-2010, 12:03 PM #3
    DonkeyOte
    DonkeyOte is offline
    Forum Moderator DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Suffolk, UK
    MS-Off Ver
    2002, 2007 & 2010
    Posts
    21,379

    Re: roundup in an "IF" function

    For whole number:

    ROUNDUP(calculation,0)

    or

    CEILING(calculation,1)

    (Thread moved from Outlook to Excel Worksheet Functions forum)
    Last edited by DonkeyOte; 01-10-2010 at 12:05 PM.
    My Recommended Reading:

    Volatility
    Sumproduct & Arrays
    Pivot Intro
    Email from XL - VBA & Outlook VBA
    Function Dictionary & Function Translations
    Dynamic Named Ranges
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0