rounding question

[ACtrafficengr]

I'm looking for a way to round a value down to the next lower multiple of 5. For example, 39 is rounded to 35, not 40.

MROUND will round to the nearest multiple of 5. 39 will be rounded to 40.
ROUNDDOWN will round down to the nearest 10. 39 will be rounded to 30.

MROUND(n-2.5,5) seems to work. Any other ideas how to do this?

"...students of traffic are beginning to realize the false economy of mechanically controlled traffic, and hand work by trained officers will again prevail." - Wm. Phelps Eno, ca. 1928

"I'm searching for the questions, so my answers will make sense." - Stephen Brust

 

[PatBethea]

=FLOOR(X, 5)

Where "X" is the value you want rounded down.

 

[ACtrafficengr]

Perfect!

Thank you!

"...students of traffic are beginning to realize the false economy of mechanically controlled traffic, and hand work by trained officers will again prevail." - Wm. Phelps Eno, ca. 1928

"I'm searching for the questions, so my answers will make sense." - Stephen Brust

 

[yogia]

Hi ACtrafficengr:

for using ROUNDDOWN, try ... =ROUNDDOWN(B2/A2,0)*A2

where B2=39, and A2=5

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
ANAND Enterprises LLC

http://www.energyefficientbuild.com