Round up to the next number in the set
 

Hi,

Probably a simple one, but I can't think of an easy way of rounding up to
the next number in a set - eg the set is 305, 610 and 915. The calculation
will produce an answer which I want rounded up to one of the 3 numbers above
- eg, 200 is rounded up to 305; 400 is rounded up to 610 etc.

Many thanks for any help.

Will

Round up to the next number in the set
 

Hi,

Try this

=MIN(IF({305,610,915}=your formula,{305,610,915}))

Mike

"will" wrote:

Hi,

Probably a simple one, but I can't think of an easy way of rounding up to
the next number in a set - eg the set is 305, 610 and 915. The calculation
will produce an answer which I want rounded up to one of the 3 numbers above
- eg, 200 is rounded up to 305; 400 is rounded up to 610 etc.

Many thanks for any help.

Will

Round up to the next number in the set
 

Hi,

Neglected to mention this is an array formula

This is an array formula which must be entered by pressing CTRL+Shift+Enter
'and not just Enter. If you do it correctly then Excel will put curly brackets
'around the formula {}. You can't type these yourself. If you edit the formula
'you must enter it again with CTRL+Shift+Enter.

Mike

"will" wrote:

Hi,

Probably a simple one, but I can't think of an easy way of rounding up to
the next number in a set - eg the set is 305, 610 and 915. The calculation
will produce an answer which I want rounded up to one of the 3 numbers above
- eg, 200 is rounded up to 305; 400 is rounded up to 610 etc.

Many thanks for any help.

Will

Round up to the next number in the set
 

A1 being 200, 400, etc.

=INDEX({915,610,305},MATCH(A1,{915,610,305},-1))

Regards,
Stefi

€žwill€� ezt Ã*rta:

Hi,

Probably a simple one, but I can't think of an easy way of rounding up to
the next number in a set - eg the set is 305, 610 and 915. The calculation
will produce an answer which I want rounded up to one of the 3 numbers above
- eg, 200 is rounded up to 305; 400 is rounded up to 610 etc.

Many thanks for any help.

Will

Round up to the next number in the set
 

No it isn't :(

"Mike H" wrote:

Hi,

Neglected to mention this is an array formula

This is an array formula which must be entered by pressing CTRL+Shift+Enter
'and not just Enter. If you do it correctly then Excel will put curly brackets
'around the formula {}. You can't type these yourself. If you edit the formula
'you must enter it again with CTRL+Shift+Enter.

Mike

"will" wrote:

Hi,

Probably a simple one, but I can't think of an easy way of rounding up to
the next number in a set - eg the set is 305, 610 and 915. The calculation
will produce an answer which I want rounded up to one of the 3 numbers above
- eg, 200 is rounded up to 305; 400 is rounded up to 610 etc.

Many thanks for any help.

Will

Round up to the next number in the set
 

You may try using some IF statements, ie if <305 then 305, if 306 and <610,
then 610, if 611 then 910

It's been a long time since I used something like this, obviously the above
is not the exact formula - but someone else may chime in with the right
formula

"will" wrote:

Hi,

Probably a simple one, but I can't think of an easy way of rounding up to
the next number in a set - eg the set is 305, 610 and 915. The calculation
will produce an answer which I want rounded up to one of the 3 numbers above
- eg, 200 is rounded up to 305; 400 is rounded up to 610 etc.

Many thanks for any help.

Will

Round up to the next number in the set
 

=CEILING(A2,305)
--
David Biddulph

"Christina" wrote in message
...
You may try using some IF statements, ie if <305 then 305, if 306 and
<610,
then 610, if 611 then 910

It's been a long time since I used something like this, obviously the
above
is not the exact formula - but someone else may chime in with the right
formula

"will" wrote:

Hi,

Probably a simple one, but I can't think of an easy way of rounding up to
the next number in a set - eg the set is 305, 610 and 915. The
calculation
will produce an answer which I want rounded up to one of the 3 numbers
above
- eg, 200 is rounded up to 305; 400 is rounded up to 610 etc.

Many thanks for any help.

Will

Round up to the next number in the set
 

Very edifying! One has to try to read the OP's thoughts and notice that
610=2*305 and 915=3*305.
Stefi


€žDavid Biddulph€� ezt Ã*rta:

=CEILING(A2,305)
--
David Biddulph

"Christina" wrote in message
...
You may try using some IF statements, ie if <305 then 305, if 306 and
<610,
then 610, if 611 then 910

It's been a long time since I used something like this, obviously the
above
is not the exact formula - but someone else may chime in with the right
formula

"will" wrote:

Hi,

Probably a simple one, but I can't think of an easy way of rounding up to
the next number in a set - eg the set is 305, 610 and 915. The
calculation
will produce an answer which I want rounded up to one of the 3 numbers
above
- eg, 200 is rounded up to 305; 400 is rounded up to 610 etc.

Many thanks for any help.

Will