Round number to whole No 25

J

Jim Thomlinson

My personal preference as it does not require the Analysis Toolpack is this...

=round(A1/25, 0) * 25

Where the number to be rounded is in A1
 

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

Printing lables LP40 0
Round-Up question 2
How can I Round up to the nearest .25 11
Indenting every other paragraph in Word at the same time? 0
round up to nearest 50p 1
Round up to nearest 25 or 50? 6
Round formula 1
rounding up to nearest specified whole number 1

Top