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