Forum Discussion
Solved
DEFINING LAST 4 PLACES IN PRICE POINTS
Hi There, I have a massive list of prices that I need to set price points to. I have used the CEILING formula in the past to go in increments of 50 but our price points are more dynamic now so t...
With a price in P2:
=LET(d,P2+0.05, m, MOD(d, 100), p, IFS(m<15, 0, m<40, 30, m<65, 50, m<90, 80, TRUE, 100), w, FLOOR(d, 100), MAX(w+p-0.05, 0))
With a price in P2:
=LET(d,P2+0.05, m, MOD(d, 100), p, IFS(m<15, 0, m<40, 30, m<65, 50, m<90, 80, TRUE, 100), w, FLOOR(d, 100), MAX(w+p-0.05, 0))