Creating a formula to determine cost based on different factors
I am trying to find a formula. Basically, in column A I have a number (example-1500) and I am looking to find a formula that will calculate the cost based on range.
I.E. if the number in Column A is 0-1500...multiple by 5. If the number in Column A is 1501-2000, multiple by 10.
Can anyone guide me in the right direction?
Help Article Resources
Check out the Formula Handbook template!