Round up to 3

[Richard]

Formula now is =B3/E3/F3*G3 I need the results to round up in increments of
3. Example if results are even, 3,6,9,12 etc... thats fine but if it's
something like 3.9 I need it to round up to 6, 7.1 up to 9 etc... Thanks in
advance

 

[Ron Rosenfeld]

Formula now is =B3/E3/F3*G3 I need the results to round up in increments of
3. Example if results are even, 3,6,9,12 etc... thats fine but if it's
something like 3.9 I need it to round up to 6, 7.1 up to 9 etc... Thanks in
advance

You can use the CEILING function

e.g: =CEILING(A1,3)

or

=CEILING(B3/E3/F3*G3,3)

One caveat:

As written, this will work for positive values. If you might have negative
values, you need to decide on the behavior (round towards or away from zero)
you want, and also either change the function or the sign of number or
significance.
--ron

 

[Don Guillett]

try this idea
=ROUNDUP(D8/3,0)*3

 

[Stan Brown]

Sat, 23 Feb 2008 05:11:01 -0800 from Richard

Formula now is =B3/E3/F3*G3 I need the results to round up in increments of
3. Example if results are even, 3,6,9,12 etc... thats fine but if it's
something like 3.9 I need it to round up to 6, 7.1 up to 9 etc... Thanks in
advance

= 3*round((...)/3, 0)

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
A: Maybe because some people are too annoyed by top posting.
Q: Why do I not get an answer to my question(s)?
A: Because it messes up the order in which people normally read text.
Q: Why is top posting such a bad thing?

 

[David Biddulph]

I assume you intended to say ROUNDUP, rather than ROUND, Stan?

 

[Stan Brown]

Sat, 23 Feb 2008 19:47:25 -0000 from <"David Biddulph" <groups [at]
biddulph.org.uk>>:

I assume you intended to say ROUNDUP, rather than ROUND, Stan?

Good catch; you're right.

Please don't use a "-- " signature delimiter before quoted material.
That makes it impossible to carry the quote forward. Thanks!

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
A: Maybe because some people are too annoyed by top posting.
Q: Why do I not get an answer to my question(s)?
A: Because it messes up the order in which people normally read text.
Q: Why is top posting such a bad thing?