I have run into problem Ron in the N column I have a formula in each cell and
the macro does not round the number up to multiple of 3. Is it possible to
do the formula in the cell and then round up to multiple of 3.
--
glen


"Ron Rosenfeld" wrote:

On Thu, 2 Apr 2009 06:19:02 -0700, Silverline
wrote:

Thankyou for your help.
--
glen

Glad to help.

Thanks for the feedback.
--ron

On Thu, 2 Apr 2009 08:31:02 -0700, Silverline
wrote:

I have run into problem Ron in the N column I have a formula in each cell and
the macro does not round the number up to multiple of 3. Is it possible to
do the formula in the cell and then round up to multiple of 3.
--
glen

I need more data.

If the *only* change you made in the macro was the range to which AOI is set,
(i.e. the set AOI = range("...") line, then the macro should be replacing the
formula with the value rounded up to the multiple of 3 (unless those cells are
not included in the AOI (Area of Interest).

So what exactly have you done, and what is happening?

--ron

What I have done Ron is entered the range of cells that it is required to
have the number round up to multiple of 3 witch is "B12:B37,N12:N37". The
formula required in cells N12:N37 is =sum (b12*N9)+B12. N9 is a percentage
addition but I want it to round up to muliple of 3.
--
glen


"Ron Rosenfeld" wrote:

On Thu, 2 Apr 2009 08:31:02 -0700, Silverline
wrote:

I have run into problem Ron in the N column I have a formula in each cell and
the macro does not round the number up to multiple of 3. Is it possible to
do the formula in the cell and then round up to multiple of 3.
--
glen

I need more data.

If the *only* change you made in the macro was the range to which AOI is set,
(i.e. the set AOI = range("...") line, then the macro should be replacing the
formula with the value rounded up to the multiple of 3 (unless those cells are
not included in the AOI (Area of Interest).

So what exactly have you done, and what is happening?

--ron

On Thu, 2 Apr 2009 12:58:01 -0700, Silverline
wrote:

What I have done Ron is entered the range of cells that it is required to
have the number round up to multiple of 3 witch is "B12:B37,N12:N37". The
formula required in cells N12:N37 is =sum (b12*N9)+B12. N9 is a percentage
addition but I want it to round up to muliple of 3.
--
glen

Why not just remove N12:N37 from the AOI range, and, in N12:N37, instead use
the formula:

=ceiling(b12*$N$9)+b12,3)

???
--ron

Excel tells me that $n$9 has to few of arguments. ???
--
glen


"Ron Rosenfeld" wrote:

On Thu, 2 Apr 2009 12:58:01 -0700, Silverline
wrote:

What I have done Ron is entered the range of cells that it is required to
have the number round up to multiple of 3 witch is "B12:B37,N12:N37". The
formula required in cells N12:N37 is =sum (b12*N9)+B12. N9 is a percentage
addition but I want it to round up to muliple of 3.
--
glen

Why not just remove N12:N37 from the AOI range, and, in N12:N37, instead use
the formula:

=ceiling(b12*$N$9)+b12,3)

???
--ron

I haven't followed your thread, but maybe:

=ceiling((b12*$N$9)+b12,3)


Silverline wrote:

Excel tells me that $n$9 has to few of arguments. ???
--
glen

"Ron Rosenfeld" wrote:

On Thu, 2 Apr 2009 12:58:01 -0700, Silverline
wrote:

What I have done Ron is entered the range of cells that it is required to
have the number round up to multiple of 3 witch is "B12:B37,N12:N37". The
formula required in cells N12:N37 is =sum (b12*N9)+B12. N9 is a percentage
addition but I want it to round up to muliple of 3.
--
glen

Why not just remove N12:N37 from the AOI range, and, in N12:N37, instead use
the formula:

=ceiling(b12*$N$9)+b12,3)

???
--ron


--

Dave Peterson

-- Thank you Dave for your help it works great.
glen


"Dave Peterson" wrote:

I haven't followed your thread, but maybe:

=ceiling((b12*$N$9)+b12,3)


Silverline wrote:

Excel tells me that $n$9 has to few of arguments. ???
--
glen

"Ron Rosenfeld" wrote:

On Thu, 2 Apr 2009 12:58:01 -0700, Silverline
wrote:

What I have done Ron is entered the range of cells that it is required to
have the number round up to multiple of 3 witch is "B12:B37,N12:N37". The
formula required in cells N12:N37 is =sum (b12*N9)+B12. N9 is a percentage
addition but I want it to round up to muliple of 3.
--
glen

Why not just remove N12:N37 from the AOI range, and, in N12:N37, instead use
the formula:

=ceiling(b12*$N$9)+b12,3)

???
--ron


--

Dave Peterson

On Thu, 2 Apr 2009 14:14:10 -0700, Silverline
wrote:

Excel tells me that $n$9 has to few of arguments. ???
--
glen

You are misreading something.

$N$9 is a cell reference, and cell references cannot have "to few of
arguments".

A function could have too few arguments, but you should be able to read HELP
for that function to figure it out.

If not, please be more complete and accurate in your descriptions of what you
are doing and what is happening.
--ron

Your suggestion had mismatched ()'s.
=ceiling(b12*$N$9)+b12,3)

(I'm not sure how that message got generated, though <vbg.)



Ron Rosenfeld wrote:

On Thu, 2 Apr 2009 14:14:10 -0700, Silverline
wrote:

Excel tells me that $n$9 has to few of arguments. ???
--
glen

You are misreading something.

$N$9 is a cell reference, and cell references cannot have "to few of
arguments".

A function could have too few arguments, but you should be able to read HELP
for that function to figure it out.

If not, please be more complete and accurate in your descriptions of what you
are doing and what is happening.
--ron

--

Dave Peterson