Make sure the Analysis Tool-Pak Add-in is activated. (Tools - Add-ins).
Formula will be something like:

=MROUND(A2,500)-5
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Heather" wrote:

Can anyone help me with a rounding issue

I have a formula that looks like this

F7*F27
16,995*.92134 = 15,658.17

I then need to Round to the nearest 500 and then subtract 5

15,659 rounded to the neares is 15,500 then subtract 5 = 15,495