+ Reply to Thread
Results 1 to 2 of 2

Formula help - rounding up and down within an if statement

  1. #1
    Registered User
    Join Date
    01-24-2007
    Posts
    3

    Formula help - rounding up and down within an if statement

    Can someone help me please as I don't know how to construct the formula to round up or down within an if statement?
    I have a spreadsheet with data in column F and if the data is greater than .5, i want it to round up to the next whole number. if it is less than 0.5 then it would round down e.g. 2.20 in column F would round to 2, 0.99 would round up to 1.

    Can anyone help me construct this formula please as I don't know if I should be using roundup, floor, ceiling or some other function?

    Thanks in advance.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,423

    Re: Formula help - rounding up and down within an if statement

    Have you tried the ROUND function? It works in the way you describe, i.e.:

    =ROUND(F6,0)

    Hope this helps.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] If statement not rounding correctly.
    By msmith1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-24-2016, 02:03 PM
  2. [SOLVED] Rounding an IF Statement
    By sonicsiesta in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-16-2015, 05:23 AM
  3. [SOLVED] Custom Rounding And IF Statement In One Formula....
    By HobbesIsReal in forum Excel General
    Replies: 8
    Last Post: 08-03-2013, 06:48 PM
  4. rounding numbers and =if statement
    By mheinmiller in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-29-2010, 11:34 AM
  5. Rounding & IF statement Question
    By SOMLSS1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-03-2007, 10:57 AM
  6. If statement w/ rounding but not all numbers
    By AMarie in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-10-2005, 04:05 PM
  7. rounding decimals in an IF statement
    By static69 in forum Excel General
    Replies: 1
    Last Post: 05-04-2005, 09:20 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1