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
|