Question

2:06 + 84% f Expert Q&A + 0.5 B с D m 2 Goal Seeker Example 3 4 Item 5 Pens 6 Pencils 7 Books Quantity Price Amout Due 10 $ 0.30 $ 3.00 20 $0.50 $ 10.00 30 $ 0.60 $ 18.00 Total $ 31.00 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Sheet o Q2 03 04 . Search for anything 0

Answer 1

Below is the solution:

Create a Goal Seek from Data tab and select What-If-Analysis under What-If-Analysis select Goal Seek and now Goal seek dialog box will open.

C6 х for =D6/B6 A B с D E F 1 2 Goal Seeker Example 3 4 Item 5 Pens 6 Pencil 7 Books Quantity Price Amount Due 10 $ 0.30 $ 3.00 20 $ 0.50 $ 10.00 30 $ 0.60 $ 18.00 Total $ 31.00 8 9 Goal Seek ? 10 X 11 Set cell: C6 12 13 To value: 1.25 By changing cell: $B$7 1 14 15 OK Cancel 16

C6 for =D6/B6 A B D E F G 1 2. Goal Seeker Example 3 4 Item 5 Pens 6 Pencil 7 Books 8 9 Quantity Price Amount Due 10 $ 0.30 $ 3.00 20 $ 0.50 $ 10.00 -10066300 $ (0.00) $ 18.00 Total $ 31.00 10 ? X 11 Step 12 Goal Seek Status Goal Seeking with Cell C6 may not have found a solution. Target value: 1.25 Current value: $0.50 13 Pause 14 15 OK Cancel 16

The Goal Seek will not found the solution and then cancel the Goal seek.