I am relatively new at doing advanced formulas any help would be greatly
appreciated. Here is my situation I am building a spread sheet that will
calculate commissions for employees.
Column c = national price
Column d = lowest price they can sell the item for
Column u = the price that they sold the item at
Column x is their commission per unit sold
Here is the logic:
If they sell the item for national price (c) they earn 50cents
If they sell the item for lowest price they can sell the item for (d) they
earn 10 cents
If they sell the item for something in between D and C they get 10% of the
difference from where they sold it and the lowest price they can sell it for
Also the lowest commission they can earn is 10 cents on any item sold
Example:
c9=52
d9=49
So if u9=52 then their commission is .50
If u9=49 then their commission is .10
If u9=51 then their commission is 51-49=2.00*.10= .20
The formula I wrote is:
IF(U9=C9,0.5,(U9-D9)*0.1)+IF(D9=U9,0.1)
The problem I am having is if there is no value in U9 then I get a #value!
Error in x9
I want x9 to be blank if there is no value in u9
Thank you again for any help