Using Excel Goal Seek

[featured_image]
  • Version
  • Download 8
  • File Size 907.20 KB
  • File Count 1
  • Create Date May 9, 2022
  • Last Updated May 10, 2022

Using Excel Goal Seek

The Using Excel Goal Seek PPT presentation describes a very handy built-in Excel tool when you have a “formula” but you cannot solve it explicitly into a y=f(x) “formula”. Many engineering problems involve “guessing” a value for the solution, and you have to keep guessing over-and-over. If you can write an equation where the left hand side is: 0=(your formula that depends on x), then you can use Goal Seek to keep automatically guessing x until the left-hand-side equals zero.