+ Reply to Thread
Results 1 to 4 of 4

ROUNDDOWN Formula not working

  1. #1
    Registered User
    Join Date
    04-20-2012
    Location
    Saint Paul, Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    52

    ROUNDDOWN Formula not working

    I am trying to apply the ROUNDDOWN formula to an averaging formula and it is saying I have too few arguments. Can any of you see what I'm missing? Here's my formula:

    =ROUNDDOWN(AVERAGE(B31,F31,J31,N31,R31,V31,Z31))


    thanks

  2. #2
    Valued Forum Contributor
    Join Date
    03-16-2012
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    992

    Re: ROUNDDOWN Formula not working

    You need to state to how many digits your formula should round down. If you want it to round down to no digits, then:

    =ROUNDDOWN(AVERAGE(B31,F31,J31,N31,R31,V31,Z31),0)
    Sincerely
    S?ren Larsen

    "Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"

  3. #3
    Registered User
    Join Date
    04-20-2012
    Location
    Saint Paul, Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    52

    Re: ROUNDDOWN Formula not working

    That worked. Thank you!

  4. #4
    Valued Forum Contributor
    Join Date
    03-16-2012
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    992

    Re: ROUNDDOWN Formula not working

    You're welcome. If you could mark this thread as solved, it would be a great help.

+ 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