I want to build a bonus worksheet
Asked By
10 points
N/A
Posted on - 01/16/2012
Hello experts,
I want to build a bonus worksheet which will linked to an invoice spreadsheet via use of macro.
It is based upon invoice sales , the bonus, I would like to have on a sliding scale, but I don’t know what formula to use?
As an example, I want to do is, if sales value is in cell A1=$100-$200, then cell C1 (which will calculate the bonus that staff will get) must be the figure shown in A1*A%. I A1 = the sum of $300-$400, this should be calculated at slightly higher percentage.
Please reply me if you need more explanation.
