Round up to the next number in the set

  • Thread starter Thread starter will
  • Start date Start date
W

will

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
 
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
 
A1 being 200, 400, etc.

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

Regards,
Stefi

„will†ezt írta:
 
No it isn't :(

Mike H said:
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
Click to expand...
 
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
 
=CEILING(A2,305)
--
David Biddulph

Christina said:
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
Click to expand...
 
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:
 
Back
Top