Rounding to Multiples of Integers?
 

I have a process which involves taking a product of two numbers and then
rounding down to the nearest multiple of five.

Can I write a cell-formula that will ..EITHER .. multiply the two terms AND
round the product to a multiple of five .. OR.. a formula that will take a
single value from a neighboring cell and round it down to the nearest
multiple of five?

Thanks

Rounding to Multiples of Integers?
 

If you want to ROUND DOWN to multiples of 5, try this:

For values in A1 and B1
C1: =FLOOR(A1*B1,5)

Example:
2x2=4......rounded down to 0
2x7=14....rounded down to 10

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"ConfusedNHouston" wrote:

I have a process which involves taking a product of two numbers and then
rounding down to the nearest multiple of five.

Can I write a cell-formula that will ..EITHER .. multiply the two terms AND
round the product to a multiple of five .. OR.. a formula that will take a
single value from a neighboring cell and round it down to the nearest
multiple of five?

Thanks

Rounding to Multiples of Integers?
 

=FLOOR(A1*B1,5)

if really round down. If just round, then

=ROUND(A1*B1/5,0)*5

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ConfusedNHouston" wrote in
message ...
I have a process which involves taking a product of two numbers and then
rounding down to the nearest multiple of five.

Can I write a cell-formula that will ..EITHER .. multiply the two terms
AND
round the product to a multiple of five .. OR.. a formula that will take a
single value from a neighboring cell and round it down to the nearest
multiple of five?

Thanks

Rounding to Multiples of Integers?
 

Try using the "MROUND" function...

Sandy


ConfusedNHouston wrote:
I have a process which involves taking a product of two numbers and then
rounding down to the nearest multiple of five.

Can I write a cell-formula that will ..EITHER .. multiply the two terms AND
round the product to a multiple of five .. OR.. a formula that will take a
single value from a neighboring cell and round it down to the nearest
multiple of five?

Thanks

Rounding to Multiples of Integers?
 

The formula for "multiply the two terms AND round the product to a
multiple of five" is
=MROUND(A1*B1,5) where A1 and B1 contain your two terms.

The formula for "a formula that will take a single value from a
neighboring cell and round it down to the nearest multiple of five" is
=INT(A1/5)*5 where A1 is the cell reference.

Rounding to Multiples of Integers?
 

Ron,

The floor thing was EXACTLY what I needed. It actually worked!
Thank you,
Yngpro59

"Ron Coderre" wrote:

If you want to ROUND DOWN to multiples of 5, try this:

For values in A1 and B1
C1: =FLOOR(A1*B1,5)

Example:
2x2=4......rounded down to 0
2x7=14....rounded down to 10

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"ConfusedNHouston" wrote:

I have a process which involves taking a product of two numbers and then
rounding down to the nearest multiple of five.

Can I write a cell-formula that will ..EITHER .. multiply the two terms AND
round the product to a multiple of five .. OR.. a formula that will take a
single value from a neighboring cell and round it down to the nearest
multiple of five?

Thanks