Thread
:
Need Help with ROUNDUP
View Single Post
#
4
Posted to microsoft.public.excel.misc
pedro
external usenet poster
Posts: 14
Need Help with ROUNDUP
On Thu, 19 Nov 2015 07:36:42 -0800 (PST),
wrote:
Neither of these work. Though I thought I'd tried every variation of your suggestion before posting my original message, I'd obviously not tried the first one.
The first yields a value of "#NAME" in the cell. When the second is entered I get a an error message indicating that "there are too few arguments for this function".
Perhaps this has to do with the D3 and E3 cells? These cells contain formulas that yield numerical values rather than hard entered values.
My error - the NAME# is triggered by the unintended space after SUM
which I copied from your post.
To test this out, I just entered a couple of random numbers (27.4 and
83.2) into two cells, and in D3 and E3 I copied these (=A3, and =B3).
With the formula =ROUNDUP((SUM(D3:E3)/31),0) in F3 I get 4.
The second suggested expression was based on the HELP description of
ROUNDUP, which infers the 0 (num_places) can be omitted but doesn't
show whether the "," is still required. I hadn't tested that, and yes
I get that error. It turns out that the comma separator IS required:
=ROUNDUP((SUM(D3:E3)/31),) works for me.
Reply With Quote
pedro
View Public Profile
Find all posts by pedro