Round up to the next number in the set

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
 
M

Mike H

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
 
S

Stefi

A1 being 200, 400, etc.

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

Regards,
Stefi

„will†ezt írta:
 
M

Mike H

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
 
C

Christina

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
 
D

David Biddulph

=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
 
S

Stefi

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top