Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding problems
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding problems
=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) "Ste101" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding problems
Thanks that great, just need the rounding up to a non-multiple problem
solving now "Bob Phillips" wrote: =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) "Ste101" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding problems
=CEILING(A1,50)
-- David Biddulph "Ste101" wrote in message ... 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. .... |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding problems
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 On Jul 26, 12:54 pm, Ste101 wrote: Thanks that great, just need the rounding up to a non-multiple problem solving now "Bob Phillips" wrote: =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) "Ste101" wrote in message ... 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- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding problems
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. -- David Biddulph "Pete_UK" wrote in message oups.com... 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 On Jul 26, 12:54 pm, Ste101 wrote: Thanks that great, just need the rounding up to a non-multiple problem solving now "Bob Phillips" wrote: =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) "Ste101" wrote in message ... 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- Hide quoted text - - Show quoted text - |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding problems
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 On Jul 26, 1:32 pm, "David Biddulph" <groups [at] biddulph.org.uk wrote: 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. -- David Biddulph "Pete_UK" wrote in message oups.com... 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 On Jul 26, 12:54 pm, Ste101 wrote: Thanks that great, just need the rounding up to a non-multiple problem solving now "Bob Phillips" wrote: =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) "Ste101" wrote in message ... 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- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
Problems: rounding & formatting Text/# combinations | Excel Discussion (Misc queries) | |||
Problems: rounding & formatting Text/# combinations | Excel Discussion (Misc queries) | |||
Rounding up/down problems ? | Excel Worksheet Functions | |||
Rounding | Excel Worksheet Functions |