Hi board members
I am trying to create a formula whereby if I enter a user number in a reference cell, 100 for example, Excel uses
the below tiered pricing to calculate a monthly fee.
100 users should return a result of £13,340.00
9 @ £150
15 @ £150
50 @ £135
26 @ £115
User Tier
1-9...