+ Reply to Thread
Results 1 to 2 of 2

Solved - rounddown function

  1. #1
    Registered User
    Join Date
    10-21-2007
    Posts
    2

    Solved - rounddown function

    I have a formula in a cell that, when calculated, returns a number with 2 decimal places. I want it to round down to the integer and so i have not used the formatting where I can choose to have no decimal places incase it rounds it up.
    How do I insert the ROUNDDOWN function.
    e.g. my formula is
    =E10/((E8-G9)/2)

    this may give me a 2 decimal place answer. I only want a whole number, rounded down.
    I have put in the ROUNDDOWN function using the insert function buttons but it adds the rounded down figure to the original result, thus doubling the answer. I don't want this, I only want the rounded down figure to appear. Can it be done in one cell?
    Last edited by VBA Noob; 10-21-2007 at 12:39 PM.

  2. #2
    Registered User
    Join Date
    10-21-2007
    Posts
    2

    Smile

    Thanks qwopzxnm. Found your explanation straight away and it works. Great! now I can get on with it.

    http://www.excelforum.com/showthread.php?t=606887
    Last edited by VBA Noob; 10-21-2007 at 01:14 PM.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1