I want to be able to enter a single variable of ‘hours’ and return a result of ‘price’ where more hours = higher discount
Here is my sheet with the % discount:hours = price
https://docs.google.com/spreadsheets/d/1SprYlf8buYZ_0Pv04ZPYwzQTn4Awf-iWBj3DiNWLob4/edit?usp=sharing
How can I put this together as a simple calculator for my staff?
Example
Enter hours: 6
Return result: 7,200,000
Additionally a rounded result would be a nice feature, rounding to 100,000
Please sheet sheet for full details
TIA
I dont know where to begin with such a varibale of %