Catch all range
-
Hi
Assuming I build table of ranges like:
1 to 19 = 0% discount
20 to 69 = 10% discount
70+ = 15% discountHow can I do the 70+ line without giving an upper value, i.e. any quantity above 70 gets 15% discount (whether 71 or a million etc)? Is that possible?
Thanks
Viewing 6 replies - 1 through 6 (of 6 total)
Viewing 6 replies - 1 through 6 (of 6 total)
- The topic ‘Catch all range’ is closed to new replies.