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

    • New
    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

    • New

    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 ().

    This post was deleted by the author themselves ().
    • New

    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.

    • New

    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

Participate now!

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

Register Yourself Login