However, if we simply applied the SUMPRODUCT function to the above ranges, we would get a result that really doesn’t mean anything because the priorities were not expressed as a fraction of a whole. When we enter the score for each goal, there is a way to arrive at the company’s overall score for all goals as one figure. It can be seen here that priority is just another word for weight. The item considered highest priority is listed with the largest number, and the number with the lowest priority is assigned the smallest number.
0 Comments
Leave a Reply. |