Round to nearest 5000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to round down (always) to the nearest 5000? If the
calculation yielded 13,000, the answer would show as 10,000. Thanks
 
I'm kind of looking for an MROUND function that is combined with ROUNDDOWN.
 
Assuming you have only positive numbers

=FLOOR(A1,5000)

where A1 contains your number
 
You must log in or register to reply here.

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

How can I round a number in Excel to the nearest 5000? 6
Round time to nearest 15 minutes in decimal format 4
rounding down to nearest 1/32 3
rounding up to nearest specified whole number 1
Average rounded to nearest 0.50 4
round up to nearest 50p 1
Round Down to the nearest multiple 2
advice on rounding or ceilng a 24 hour time value 3

Back
Top