Help Please!!! I am stumped!
Been using Excel for years and Lotus 123 even before that, but I'm stumped. I always thought I was pretty proficient, but guess not. Here's what I'm struggling with:
I need to bill some clients based on some usage of services. They are charged based on tiers. For example,
Tier 1: 0 - 8 Bill 10 cents per unit
Tier 2: 9 - 24 Bill 12 cents per unit
Tier 3: 25 - 36 Bill 15 cents per unit
Tier 4: 37 & up Bill 25 cents per unit
So, let's say I have a client that uses 33 units, I would bill the first 8 units at 10 cents, the second 16 units at 12 cents, and the remaining 9 units at 15 cents per unit.
Of course, if I can extract out the property units by tier, I can do the basic formula to bill and produce an invoice, but it's having my sheet automatically calculate the amounts by tiers that's had me stumped for a couple of weeks now.
Any help would be appreciated.
Been using Excel for years and Lotus 123 even before that, but I'm stumped. I always thought I was pretty proficient, but guess not. Here's what I'm struggling with:
I need to bill some clients based on some usage of services. They are charged based on tiers. For example,
Tier 1: 0 - 8 Bill 10 cents per unit
Tier 2: 9 - 24 Bill 12 cents per unit
Tier 3: 25 - 36 Bill 15 cents per unit
Tier 4: 37 & up Bill 25 cents per unit
So, let's say I have a client that uses 33 units, I would bill the first 8 units at 10 cents, the second 16 units at 12 cents, and the remaining 9 units at 15 cents per unit.
Of course, if I can extract out the property units by tier, I can do the basic formula to bill and produce an invoice, but it's having my sheet automatically calculate the amounts by tiers that's had me stumped for a couple of weeks now.
Any help would be appreciated.