Hi,
I was wondering if it's possible to incorporate a few different rules into the same rounding formula? Basically, what I'm trying to achieve is rounding based on these rules:
If number in reference cell is 0-1000
o Round up (or down) to nearest 10 increment. Instead of landing on 100 increment, end with 90.
o So: 10, 20, 30, 40, $0, 60, 70, 80, or 90.
1000-5000
o Round up (or down) to nearest 25 increment. Instead of landing on 100 increment, end with 90.
o So: 25, 50, 75, or 90.
5000+
o Round up (or down) to nearest 25 increment. At this point, can land on 100 increments.
o So: 25, 50, 75, 100
Thanks so much for you help with this! Hopefully it is possible.
I was wondering if it's possible to incorporate a few different rules into the same rounding formula? Basically, what I'm trying to achieve is rounding based on these rules:
If number in reference cell is 0-1000
o Round up (or down) to nearest 10 increment. Instead of landing on 100 increment, end with 90.
o So: 10, 20, 30, 40, $0, 60, 70, 80, or 90.
1000-5000
o Round up (or down) to nearest 25 increment. Instead of landing on 100 increment, end with 90.
o So: 25, 50, 75, or 90.
5000+
o Round up (or down) to nearest 25 increment. At this point, can land on 100 increments.
o So: 25, 50, 75, 100
Thanks so much for you help with this! Hopefully it is possible.