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
Maybe
=int(a1) + if(mod(a1,1)<=0.49, 0.49, 0.99)
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks