I'm confused here now as I cant get the answer to change.
Have a look at the attached, assuming the sales person generates over £35k of business then it works fine.
However when they generate less than that the numbers are not correct.
On the attached c12 should display 5% of 1000 and c26 should show 10% of 1000
Comms Summary DQa.xlsx
Bookmarks