Problems using ROUNDUP function in MS Excel 2010
Results 1 to 4 of 4

Thread: Problems using ROUNDUP function in MS Excel 2010

Hybrid View

  1. #1
    Join Date
    Apr 2013
    Location
    Provo, Utah - USA
    Posts
    159

    Problems using ROUNDUP function in MS Excel 2010

    Hi all,

    I guess there's something I don't understand in my new attempt at using the ROUNDUP function in MS Excel 2010.

    I have a column which previously (in the top-most cell) had the formula "E4*0.76", which I used to calculate take-home income after 24% deductions (figures in column 'E' were gross pay).

    This formula was working fine, but the results (in dollars) included the 'cents', which I don't want to have shown. So, I decided to try using the ROUNDUP function. I revised the formula to read "ROUNDUP(E4*0.76)" but a message now tells me I've "entered too few arguments for this function.

    I'm sure I'm staring the problem right in the face, but I'm not seeing it (after a short night's sleep).

    Thanks in advance,
    - David G.
    Northern Virginia, USA

  2. #2
    Join Date
    Apr 2005
    Location
    Maryland, USA
    Posts
    17,806
    Quote Originally Posted by star-gazer777 View Post

    ROUNDUP(E4*0.76)
    Simply insert a:

    ,0

    between the 6 and ), like so:

    ROUNDUP(E4*0.76,0)

    ("0" is the number of digits you want displayed).

  3. #3
    Join Date
    Apr 2013
    Location
    Provo, Utah - USA
    Posts
    159
    Quote Originally Posted by SpywareDr View Post
    Simply insert a:
    ,0

    between the 6 and ), like so:
    ROUNDUP(E4*0.76,0)

    ("0" is the number of digits you want displayed).

    Ahh, thanks, Doc !! I knew it would be something stupidly obvious. Works like a charm -- appreciate it !

    - David

  4. #4
    Join Date
    Apr 2005
    Location
    Maryland, USA
    Posts
    17,806

Thread Information

Users Browsing this Thread

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

Posting Permissions

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