Multiply one cell by a factor and make that result round
 

I am trying to multiply A7 by B7, I then want that result to round to the
nearest 0.05. This is what I have and it wont work.Or maybe it cant be done?
=(A7*2.66),Ceiling(B7,0.05)
This formula is in cell B7

Is it possible?
Any help greatful

It sounds like you want this:

=ceiling(a7*b7,.05)

I'm not sure where 2.66 comes from.

I would think that this formula would not go in B7--you'll end up with a
circular reference problem if you use it this way.

Machel_C wrote:

I am trying to multiply A7 by B7, I then want that result to round to the
nearest 0.05. This is what I have and it wont work.Or maybe it cant be done?
=(A7*2.66),Ceiling(B7,0.05)
This formula is in cell B7

Is it possible?
Any help greatful

--

Dave Peterson

Have your tried mround()
=MROUND(A7*2.66,0.05)

"Machel_C" wrote in message
...
I am trying to multiply A7 by B7, I then want that result to round to the
nearest 0.05. This is what I have and it wont work.Or maybe it cant be
done?
=(A7*2.66),Ceiling(B7,0.05)
This formula is in cell B7

Is it possible?
Any help greatful

Whoops, forgot to pass the infomation Celing() rounds up, not to the
nearest.


"Steve R" wrote in message
...
Have your tried mround()
=MROUND(A7*2.66,0.05)

"Machel_C" wrote in message
...
I am trying to multiply A7 by B7, I then want that result to round to the
nearest 0.05. This is what I have and it wont work.Or maybe it cant be
done?
=(A7*2.66),Ceiling(B7,0.05)
This formula is in cell B7

Is it possible?
Any help greatful

Steve, Ceiling rounds to the nearest multiple that you specify,ie. 0.05.

"Steve R" wrote:

Whoops, forgot to pass the infomation Celing() rounds up, not to the
nearest.


"Steve R" wrote in message
...
Have your tried mround()
=MROUND(A7*2.66,0.05)

"Machel_C" wrote in message
...
I am trying to multiply A7 by B7, I then want that result to round to the
nearest 0.05. This is what I have and it wont work.Or maybe it cant be
done?
=(A7*2.66),Ceiling(B7,0.05)
This formula is in cell B7

Is it possible?
Any help greatful

Dave, the 2.66 is the multiplying factor I want to use. Here is what I have.
On one sheet I have costing for multiple products. On a second sheet I have
our multiplying factor to use for our costing. Lets say product A costs us
$2.50 to buy and our selling price is 2.66% markup. I want our markup
percentage to multiply by our cost and round to the nearest nickel for our
pricebooks. I dont want to have to create a 3rd sheet to do this.

"Dave Peterson" wrote:

It sounds like you want this:

=ceiling(a7*b7,.05)

I'm not sure where 2.66 comes from.

I would think that this formula would not go in B7--you'll end up with a
circular reference problem if you use it this way.

Machel_C wrote:

I am trying to multiply A7 by B7, I then want that result to round to the
nearest 0.05. This is what I have and it wont work.Or maybe it cant be done?
=(A7*2.66),Ceiling(B7,0.05)
This formula is in cell B7

Is it possible?
Any help greatful

--

Dave Peterson

maybe...

=ceiling(a7*$b$7*2.66%,.05)

Machel_C wrote:

Dave, the 2.66 is the multiplying factor I want to use. Here is what I have.
On one sheet I have costing for multiple products. On a second sheet I have
our multiplying factor to use for our costing. Lets say product A costs us
$2.50 to buy and our selling price is 2.66% markup. I want our markup
percentage to multiply by our cost and round to the nearest nickel for our
pricebooks. I dont want to have to create a 3rd sheet to do this.

"Dave Peterson" wrote:

It sounds like you want this:

=ceiling(a7*b7,.05)

I'm not sure where 2.66 comes from.

I would think that this formula would not go in B7--you'll end up with a
circular reference problem if you use it this way.

Machel_C wrote:

I am trying to multiply A7 by B7, I then want that result to round to the
nearest 0.05. This is what I have and it wont work.Or maybe it cant be done?
=(A7*2.66),Ceiling(B7,0.05)
This formula is in cell B7

Is it possible?
Any help greatful

--

Dave Peterson


--

Dave Peterson

From Help:
Ceiling()
Returns number rounded up, away from zero, to the nearest multiple of
significance.
Mround()
Returns a number rounded to the desired multiple.

Steve

"Machel_C" wrote in message
...
Steve, Ceiling rounds to the nearest multiple that you specify,ie. 0.05.

"Steve R" wrote:

Whoops, forgot to pass the infomation Celing() rounds up, not to the
nearest.


"Steve R" wrote in message
...
Have your tried mround()
=MROUND(A7*2.66,0.05)

"Machel_C" wrote in message
...
I am trying to multiply A7 by B7, I then want that result to round to
the
nearest 0.05. This is what I have and it wont work.Or maybe it cant be
done?
=(A7*2.66),Ceiling(B7,0.05)
This formula is in cell B7

Is it possible?
Any help greatful