Forum Discussion
Excel question
Hello. From a spreadsheet, I have calculated the percentage of answers for each category rating that we have within the company. However, we have goals that we would like to achieve (70, 20, 10). ...
Hi Stephanie,
3% x 667 = 20, so you have 20 "a" answers.
5% x 667 = 34 (rounding up). The difference gives you the answer of 14.
If you want to vary the "Goal" percent, you can format a cell to be %, say cell b1.
You can use algebra minus a countif equation, =(b1*667)-countif(a1:a667,"a") or just plain math
=(b1*667)-(b2*667), placing the 3% number in b2. You can use a counting formula to get to the 667 if that varies as well.