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

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

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

try this idea
=ROUNDUP(D8/3,0)*3
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Richard" wrote in message
...
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

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?

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

"Stan Brown" wrote in message
t...

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

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

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?