How to Use Goal Seek in Excel | Explained with 2 Examples

Learn how to use the goal seek tool of Excel. It is basically used to find out the unknown values from few known values.
Download the practice workbook file from link below.
Workbook Number: 5

[davidjobe]

Can you make a tutorial of the Solver option in google sheets or in excel.
In fact, I have a worksheet with Data in google sheets and a separate worksheet best adjustment in this worksheet I use =filter(Data!C7:AK, Data!D7:D=C3, Data!J7:J<>E3, Data!C7:C<=B3, Data!I7:I>=H3)
Cell D3 contains the sum of my profit here I want to maximise.
Cell A2 may be changed and so may cell H3 but H3 must be greater than 1.
Here is an example of what I do
Set Objective:D3
I tick the Max function.
By Changing:H3, A2
Subject To:
H3 >= 1
A2 >= 0
I always get an error message => The PSI interpreter was not able to parse the model correctly.
Unexpected end of formula[Computed_value"] at cell $D$6

Thanks in advance.