Welsh Mark3
Board Regular
- Joined
- Apr 7, 2014
- Messages
- 164
- Office Version
- 365
I'm looking to build a formula that calculates pricing based on tiered usage.
Cell F7 will contain usage (a number between 1 and 250,000) Cell f9 is where I would like to insert the formula. The pricing structure I would like to use is laid out below.
Example 1 if usage is 30,000 the output would be 30,000 * 1
Example 2 If usage is 175,000 the output would be (50,000 * 1) + (50,000 * 0.75) + (75,000 * 0.5) = 125,000
Column G Column H Column I Column J
I have tried to read similar posts but they seem slightly different from this request. Your help is appreciated.
Cell F7 will contain usage (a number between 1 and 250,000) Cell f9 is where I would like to insert the formula. The pricing structure I would like to use is laid out below.
Example 1 if usage is 30,000 the output would be 30,000 * 1
Example 2 If usage is 175,000 the output would be (50,000 * 1) + (50,000 * 0.75) + (75,000 * 0.5) = 125,000
Column G Column H Column I Column J
| Cost Per API Call < 50,000 | Cost Per API Call > 50,000 <100,000 | Cost Per API Call > 100,000 < 200,00 | Cost Per API Call > 200,000 |
| $1.00 | $0.75 | $0.50 | $0.25 |
I have tried to read similar posts but they seem slightly different from this request. Your help is appreciated.
