Hi all
My first post here. I'm looking for some formula help for the follow
I have field techs who are paid a percentage of the size of a job on a sliding table. I'm trying to do this in a 1 cell calculation
Between 0-2000 sq ft the tech receives a flat rate of 50
between 2001-5500 the rate is .02 x the difference between 5500-2001
between 5501 - 10000 the rate is .015 x the difference between 10000-5501
above 10,000 the rate is .01 x the amount over 10000
I can have the above details in their own cells and refer to them, but i'd like to have a formula in 1 line that will calculate a dollar amount based on a number from the cell
These total amounts are imported from a scheduling software, and it reports 1 number. Hopefully that makes sense
Here is an example of what I am trying to achieve
12501 sq ft
Formula to calculate
Base rate $50
2201-5500 is $65.98
5501-10000 is $67.49
10001+ is $25
Total amount is $208.47
Bookmarks