I am running a business and i am trying to make a formula so that whenever my employee types in a certain number (which will have a range) it automatically gives the profit.
For example I work with Credit Scores and Monthly Monitoring Fees.
Example... Credit Score is 650 - they pay 40/month - - - Profit $10.
But i need the credit score to have a range like lets say 600-650 is average with a 40/month package... i want it to automaticly put the profit ill get depending on the range of numbers between the credit score and monthly rates.
Any ideas? It's kind of confusing, any help will be appreciated.
Thanks
Bookmarks