# Round down to nearest 1000 when value ends in 500 (USD - \$35)

• 10% Paid to OzGrid?
Yes

Looking for a formula that will round down to the nearest 1,000 when a value ends in 500. When a value is greater than 500 it will will round up to the nearest 1,000. I'm trying to replicate the logic in outside system so numbers tie out. Thank you in advance for your help. Pre-payment sent.

57,500 = 57,000

57,501 = 58,000

• Subtract 1 and then round normally?

Rory
Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

• ## Post by trunten (Nov 17th 2023).

This post was deleted by the author themselves ().
• OMG...why didn't think of that??? Ugh...was looking at everything else but this. Since you both helped, I'm willing to send you both payments. PM your Paypal info and I will send.

• No need on my part. I didn't even notice this was in the hire help section.

Rory
Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

• Thank you rory!!

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!