Hi!

I need help making an Excel tiered pricing calculator/formula for the following pricing model:

# of Users Price per User
1-5 $59.88
6-15 $49.99
16-30 $47.99
31-50 $44.99
51-100 $39.99
101-250 $34.99
251-500 $29.99
501-1000 $24.99
1001+ $19.99

For example, if there were 15 users, it would charge $59.88 for the first 5 users plus $49.99 for the next 10 users.

Thanks in advance!