{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Home","Overview","Highest Loan","Time for Desired Profit","Minimum Number for Grade","Automate Goal Seek","Goal Seek Not Working"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home","index":0,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Goal Seek in Excel"]
[]
[null,"Learn how to perform Goal Seek in Excel with this free workbook. Read the article we provided and practice these in the practice section."]
[]
[]
[null,"Prepared By","Md. Junaed-Ar-Rahman"]
[null,"Reviewed By","Aung Shine"]
[null,"Last Update","2023-12-04"]
[null,"Article Link"]
[]
[null,"Examples"]
[]
[null,"1. Overview"]
[null,"2. Highest Loan"]
[null,"3. Time For Desired Profit"]
[null,"4. Minimum Number to Get a Fixed Grade"]
[null,"5.How to Automate Goal Seek Excel"]
[null,"6. Goal Seek Not Working"]
[]
[]
[null,"Copyright © 2013-2023 ExcelDemy.com | All rights reserved."]

{"sheet":"Overview","index":1,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"Goal Seek in Excel"]
[]
[null,"Loan Amount",148155.26228599675]
[null,"Annual Rate",0.04]
[null,"Years",10]
[null,"Monthly Payable",{"$f":"PMT(C4/12,C5*12,C3)","v":-1499.9999999999998}]
[null,"Target Value",1500]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home"]

{"sheet":"Highest Loan","index":2,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Goal Seek in Excel",null,null,null,"Goal Seek in Excel"]
[]
[null,"Highest Loan for Fixed Monthly Installment",null,null,null,"Try Yourself"]
[]
[null,"Loan Amount",148155.26228599675,null,null,"Loan Amount",200000]
[null,"Annual Rate",0.04,null,null,"Annual Rate",0.04]
[null,"Years",10,null,null,"Years",10]
[null,"Monthly Payable",{"$f":"PMT(C7/12,C8*12,C6)","v":-1499.9999999999998},null,null,"Monthly Payable",{"$f":"PMT(G7/12,G8*12,G6)","v":-2024.9027632976297}]
[null,"Target Value",1500,null,null,"Target Value",1800]
[]
[]
[null,"Back to Home"]

{"sheet":"Time for Desired Profit","index":3,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Goal Seek in Excel",null,null,null,"Goal Seek in Excel"]
[]
[null,"Time Required for Desired Profit",null,null,null,"Practice Yourself"]
[]
[null,"Fixed Deposit",50000,null,null,"Fixed Deposit",50000]
[null,"Interest Rate",0.03,null,null,"Interest Rate",0.03]
[null,"Years",2.9999999983858987,null,null,"Years",2.9999999983858987]
[null,"Return on Investment",{"$f":"FV(C7,C8,0,-C6,0)","v":54636.349997393248},null,null,"Return on Investment",{"$f":"FV(G7,G8,0,-G6,0)","v":54636.349997393248}]
[null,"Desired Return on Investment",{"$f":"FV(C7,3,0,-C6,0)","v":54636.35},null,null,"Desired Return on Investment",60000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home"]

{"sheet":"Minimum Number for Grade","index":4,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Goal Seek in Excel",null,null,null,null,null,"Goal Seek in Excel"]
[]
[null,"Minimum Number for Fixed Grade",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Exam","Student 1 ","Student 2","Student 3",null,null,"Exam","Student 1 ","Student 2","Student 3"]
[null,"Exam 1",56,76,48,null,null,"Exam 1",56,76,48]
[null,"Exam 2",88,81,62,null,null,"Exam 2",88,81,62]
[null,"Exam 3",75,59,86,null,null,"Exam 3",75,59,86]
[null,"Exam 4",80.999999999999986,63.999999999999993,75.999999999999986,null,null,"Exam 4"]
[]
[null,"Final Marks",{"$f":"AVERAGE(C7:C10)","v":75},{"$f":"AVERAGE(D7:D10)","v":70},{"$f":"AVERAGE(E7:E10)","v":68},null,null,"Final Marks",{"$f":"AVERAGE(I7:I10)","v":73},{"$f":"AVERAGE(J7:J10)","v":72},{"$f":"AVERAGE(K7:K10)","v":65.333333333333329}]
[]
[]
[null,"Back to Home"]

{"sheet":"Automate Goal Seek","index":5,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Goal Seek in Excel"]
[]
[null,"Automate Goal Seek for Multiple Cells"]
[]
[null,"Project Name","Scheduled Hours","Project Progress","Completed Hours",null,"Desired Project Progress"]
[null,"NexusPulse",40,{"$f":"E7/C7","v":0.35},13.999999999999998,null,0.35]
[null,"CelestialCipher",35,{"$f":"E8/C8","v":0.35},12.25]
[null,"SwiftVista",28,0.35000000000000003,9.8000000000000007]
[null,"CipherForge",50,0.34999999999999992,17.499999999999996]
[null,"SynthWave",25,0.35,8.75]
[null,"PhoenixRise",38,0.35,13.299999999999999]
[null,"PulseSync",20,0.35,7]
[null,"HyperLoom",45,0.35,15.749999999999998]
[null,"EclipticEdge",15,0.35,5.25]
[]
[]
[null,"Back to Home"]

{"sheet":"Goal Seek Not Working","index":6,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Goal Seek in Excel"]
[]
[null,"Goal Seek Not Working"]
[]
[null,"Exam","Student 1 "]
[null,"Exam 1",56]
[null,"Exam 2",88]
[null,"Exam 3",75]
[null,"Exam 4",80.999999999999986]
[]
[null,"Final Marks",{"$f":"IF(C12=\"\",C12,B9)","v":0}]
[]
[]
[]
[]
[null,"Back to Home"]