i need a formula to return a specific number depending on the total amount in the adjacent cell. Example : if the number is 10000 or above, formula should return 200, if the number is between 7500 and 10000, formula should return 175, and for anything less than 7500, formula should return 0.
Solved by E. S. in 25 mins