Need a formula that allows me to do the following:
any price that is .49 and lower, round to .49
any price that is .50 and greater, round to .99
So for example 1.39 or 1.49, would round to 1.49
And 1.50 or 1.60 would both round to 1.99
Need a formula that allows me to do the following:
any price that is .49 and lower, round to .49
any price that is .50 and greater, round to .99
So for example 1.39 or 1.49, would round to 1.49
And 1.50 or 1.60 would both round to 1.99
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks