So I have a formula written that works for what I am trying to do. I have it rounding to the nearest 500, either up or down, but I need it to round down at the 250 mark, not up. So what I am trying to do is....
5250 goes to 5000
6380 goes to 6500
7750 goes to 7500
any help is appreciated.
5250 goes to 5000
6380 goes to 6500
7750 goes to 7500
any help is appreciated.