Rounding down to the nearest 5
Posted by M. Theriault on January 08, 2002 4:06 PM
I would like to know how to go about rounding a calculated
value down to the nearest 5. Example-If I get a calculated
value of 47.5,(49 to 45), etc. the end value I want to produce
is 45. I am currently using Excel 97.
Posted by Tom Dickinson on January 08, 2002 4:17 PM
=INT(A2/5)*5 (NT)
Posted by Mark W. on January 09, 2002 7:25 AM
=FLOOR(A2,5) (nt)
