Rounding problems

[Guest]

How would I round up to the nearest 50 in an excell cell? MROUND won't work
as I always want to round up not down.

Also can I round up to non multples? I.e round up to to the nearest value
out of the following: 80, 100, 125, 160, 200, 250, 315

Thanks

 

[Bob Phillips]

=CEILING(A1,50)

any number can be used instead of 50

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Thanks that great, just need the rounding up to a non-multiple problem
solving now

 

[David Biddulph]

=CEILING(A1,50)
--
David Biddulph

How would I round up to the nearest 50 in an excell cell? MROUND won't
work
as I always want to round up not down.

....

 

[Pete_UK]

You could set up a table like this (eg in X1:Y7:

0 80
81 100
101 125
126 160
161 200
201 250
251 315

then use

=CEILING(A1,VLOOKUP(A1,X$1:Y$7,2))

Not sure what you want to happen if the number is above 315.

Hope this helps.

Pete

 

[David Biddulph]

I don't think the OP wanted a *multiple* of the numbers listed, he just
wanted to round up to that value.

Hence perhaps:
=VLOOKUP(A1,X$1:Y$7,2)
with the caveat you mentioned.

 

[Pete_UK]

Yeah, thanks David, much simpler - though I think mine would produce
the same results, as you couldn't get multiples.

I had assumed that the OP only had integers, but if he has a value
like 80.5 this would actually be rounded down to 80, so perhaps a more
robust solution is:

=VLOOKUP(ROUNDUP(A1,0),X$1:Y$7,2)

with the table as quoted earlier.

Hope this helps.

Pete