ROUNDUP Function

I'm somewhat familiar with Excel, but I'm having some issues with the Roundup function. Right now, the value of the cell looks like this:

=(M6+N6)/0.08

which equals 412.5

I'd like it to round up to the nearest round number, which would be 413, but whenever I use the roundup function, as I understand it, it doesn't work. This is what I'm trying, which obviously isn't working:

=ROUNDUP((M6+N6)/0.08,0)

Any help?

When you say "obviously isn't working", could you explain why it's not working?
Works for me...

BSB

Hi,

I'm new to this site and I don't know how to post a new thread so forgive me if replied to this thread with a different question.
I just need help for below data. I have the data available for column A,B,& C and I want the result showing in column D&E.
Can someone help me with the formula for D&E. Thanks in advance.

A B C D E
JIL MALAKIE 1232 AB20 1234F 117 3/9/2016 8:45 N*=.96 ANA-1232-1234F 09/Mar/16 08:45:00
MALAKIE 1232 AB20 1234 118 3/7/2016 7:20 S=1.43 ANA-1231-1234 07/Mar/16 07:20:00

Thanks,
goya

hello,

thanks for your reply. actually I did visit the FAQ..but I can't find the blue button "post new thread" all I can see is "reply to this thread"

Thanks,
anabelle

ERRATA....

Originally Posted by goya

I can't find the blue button "post new thread" all I can see is "reply to this thread"

The "+Post New Thread" button appears on the first webpage when you go to excelforum.com and click on a Forum category.

But only after you log in.

Originally Posted by bebo021999

What is value of M6 and N6?

Bizarrely, I randomly chose 11 and 22 to test this and it worked. Lucky guess!

Originally Posted by joeu2004

Gosh, I hope not! Are you being facetious?

Not at all, I really did just pic the numbers at random and hey presto!

And for the OP. Here's your file with the formula you put in your original post. Works fine.

BSB

Agree with BSB, it's not 'Obvious' what is wrong.
It works fine for me as well.

Describe in what way it's not working, do you get the wrong result? What result DID you get?
What are the values in the 2 cells?
Perhaps post a sample workbook.

Originally Posted by jamesberg

I'm Right now, the value of the cell looks like this:
=(M6+N6)/0.08
which equals 412.5
I'd like it to round up to the nearest round number, which would be 413, but whenever I use the roundup function, as I understand it, it doesn't work. This is what I'm trying, which obviously isn't working:
=ROUNDUP((M6+N6)/0.08,0)
Any help?

When you say it "isn't working", what do you mean? What result do you see?

=ROUNDUP(412.5,0) results in 413 on my computer. The devil is in the details. Please attach an Excel file that demonstrates the problem. In a reply, click on Go Advance, then click on the Attach File.

M6 = 10
N6 = 23

I used "=ROUNDUP ((M6+N6)/0.08,1)", and it's still showing 412.5.

I've attached a sample.

Sample.xlsx

Originally Posted by jamesberg

M6 = 10
N6 = 23
I used "=ROUNDUP ((M6+N6)/0.08,1)", and it's still showing 412.5.
I've attached a sample.

I believe you were following a misdirection that someone had posted to this thread, then deleted somehow. (I saw it once. I do not see it now.)

Changing ",1" to ",0" returns 413 in your sample file.

So we need to see an example Excel file that demonstrates the error with your original formula, to wit: =ROUNDUP((M6+N6)/0.08,0).

I suspect the problem will have gone away because you unconsciously corrected whatever "silly mistake" you had in the first place.

Thanks!

Sorry about all the confusion, but it is working now.