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
|