Page 225 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

Solution: Use Goal Seek to find out the minimum number of "Yes" votes you need to get:
• Set cell - the formula that calculates the percentage of the current "Yes" votes (C2).
• To value - the required percentage of "Yes" votes (66.67%).
• By changing cell - the number of "Yes" votes (B2).

Result: What-If analysis with Goal Seek shows that to achieve the two-thirds mark or 66.67%, you need 133 “yes”
votes.

Excel Goal Seek not working
Sometimes Goal Seek is not able to find a solution simply because it does not exist. In such situations, Excel will
get the closest value and inform you that Goal Seeking may not have found a solution.

212

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77