AnsweredAssumed Answered

Formula Help

Question asked by Jenifer on Jul 23, 2010
Latest reply on Jul 23, 2010 by philmodjunk


Formula Help


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.