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

Quote:

---

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).

Quote:

---

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

No problem David. :)