Round Down whole integer to nearst 25 possible?

F

Frank Kabel

Hi
try
=ROUNDDOWN(A1/25,0)*25

or
=FLOOR(A1,25)
-----Original Message-----
Would like to know if it's possible to round down a whole
Click to expand...
integer to the nearest 75, 50, 25, or 00. . . . .every
rounding feature I've found ONLY deals with decimals.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Divide a # into 3 #'s rounded to a whole # 9
Round it off 3
Int rounding down (calculated) whole numbers 2
Rounding down to .00 .25 .50 .75 1
Rounding numbers into .25 intervals 2
Price rounding - exception formula required 2
Problem rounding down Access 2000 2
Change value to an integer on a form 4

Top