The owner of my company is looking for FM to figure out commission structures. We currently have all of our products in FM and they are split up into 9 tiers. We would like a formula that allows us to type in the dollar amouns sold and the sq ft amount sold and have FM tells us that it falls between Tier 1 and 3 and the sales person should receive x%.
Below is what he emailed me.
(10,000 Dollars sold)/1000 (Sqft Sold) = 10.00 a sqft
that sqft price would be evaluated against the sales price tiers in the database and return a commission percent earned.
Any suggestions how to write it.