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.
57,500 = 57,000
57,501 = 58,000
57,500 = 57,000
57,501 = 58,000