I am trying to create a tool in excel that will calculate a payment based on # of credits achieved based on the table below.
For example:
50 credits = $1,000
250 credits = $1,500
Any credit amount greater than or equal to 50, and less than 250 would be $1000.
Any credit amount greater than or equal to 250, and less than 500 would be $1,500.
Etc etc.
The excel sheet would start with a question asking a user to input the number of credits they have (cell labeled credits) and then would automatically provide the payment in a cell marked "payment"
Payment would be calculated based on the formulas above (referencing the table below)
The table is going to have numbers in the millions which is why I need a formula...
Credits Payment
<tbody>
</tbody>
For example:
50 credits = $1,000
250 credits = $1,500
Any credit amount greater than or equal to 50, and less than 250 would be $1000.
Any credit amount greater than or equal to 250, and less than 500 would be $1,500.
Etc etc.
The excel sheet would start with a question asking a user to input the number of credits they have (cell labeled credits) and then would automatically provide the payment in a cell marked "payment"
Payment would be calculated based on the formulas above (referencing the table below)
The table is going to have numbers in the millions which is why I need a formula...
Credits Payment
50 | $1000 | |
100 | ||
150 | ||
200 | ||
250 | $1500 | |
300 | ||
350 | ||
400 | ||
450 | ||
500 | $2000 | |
550 | ||
600 | ||
650 | ||
700 | ||
750 | $2500 | |
800 | ||
850 | ||
900 | ||
950 | ||
1000 | $3000 | |
<tbody>
</tbody>