tammyanthos
New Member
- Joined
- Apr 6, 2020
- Messages
- 36
- Office Version
- 365
- Platform
- Windows
Blended tier pricing
I need to create a chart and formula that calculates what the price = based on the $ amount of the account
e.g. accounts up to $100k = .50, $100k-$250k = .60, etc. so an account of $175k would be.50 for the first $100k and .60 for the other $75k ?
I need to create a chart and formula that calculates what the price = based on the $ amount of the account
e.g. accounts up to $100k = .50, $100k-$250k = .60, etc. so an account of $175k would be.50 for the first $100k and .60 for the other $75k ?