-
August 16th, 2013, 12:22 PM
#1
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
-
August 16th, 2013, 01:43 PM
#2
Originally Posted by star-gazer777
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).
-
August 16th, 2013, 02:06 PM
#3
Originally Posted by SpywareDr
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
-
August 16th, 2013, 05:12 PM
#4
No problem David.
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
-
Forum Rules
|
|