Rounding to Multiples of Integers?

[ConfusedNHouston]

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

 

[Ron Coderre]

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

 

[Bob Phillips]

=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)

 

[Sandy]

Try using the "MROUND" function...

Sandy

 

[Dave O]

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.

 

[yngpro59]

Ron,

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