Hi
I'm working on a pricing model for software licensing. We have the following licensing tiers:
Anything upto 500 licenses is $1000
501-5000 is $2 per license
5001-10000 is $1.50
10001-15000 is $1.00
15001+ is $0.50
What I need is when the user inputs the number of requested licenses the results should output the cost of licenses in each tier. Please see attached sheet.
Thanks
Bookmarks