Amfani da Goal nema a Excel

Yi amfani da Goal Gano lokacin shiryawa da sababbin ayyukan

Tasirin neman Goge na Excel yana ba ka damar canja bayanan da aka yi amfani dashi a cikin wata hanya don gano abin da sakamakon zai kasance tare da canji. Wannan fasali yana da amfani yayin da kake shirin sabon aikin. Za a iya kwatanta sakamakon daban-daban don gano ko wane ne mafi dacewa da bukatunka.

Amfani da Mahimmanci na Excel & # 39; s Goal Search

Wannan misali na farko yana amfani da aikin PMT don lissafin biyan kuɗin kuɗin wata na wata bashi. Daga nan yana amfani da Goal na nema ta rage biyan kuɗin kowane wata ta hanyar canza lokacin lokaci.

Na farko, shigar da wadannan bayanai a cikin kwayoyin da aka nuna:

Cell - Data
D1 - Kudin Loan
D2 - Rate
D3 - # na Biyan kuɗi
D4 - Babban
D5 - Biyan kuɗi

E2 - 6%
E3 - 60
E4 - $ 225,000

  1. Danna kan salula E5 kuma rubuta irin wannan tsari: = pmt (e2 / 12, e3, -e4) kuma danna maballin ENTER akan keyboard
  2. Darajar $ 4,349.88 ya kamata ya bayyana a cell E5. Wannan shi ne biya na biyan kwanan wata don wannan bashi.

Sauya Biyan Biyan Kuɗi Tare da Amfani da Goal

  1. Danna kan Data shafin akan rubutun.
  2. Zabi Abin da-Idan Tattaunawa don bude jerin jerin abubuwan da suka rage.
  3. Danna Binciko na Goal .
  4. A cikin akwatin maganganu , danna kan layi na Set cell .
  5. Danna maɓallin E5 a cikin maƙallan rubutu don canza farashin kowane wata na wannan rancen.
  6. A cikin akwatin maganganu, danna kan Don darajar layin.
  7. Rubuta 3000 don rage biyan kuɗi zuwa $ 3000.00.
  8. A cikin akwatin maganganu, danna kan Ƙara canjin layi.
  9. Danna maɓallin E3 a cikin maƙallan rubutu don canza canji na wata ta hanyar canza yawan yawan biyan kuɗi da za a yi.
  10. Danna Ya yi .
  11. A wannan batu, Gudanar da Goal ya kamata fara neman mafita. Idan ya sami ɗaya, akwatin Gidan Goal na Goal zai sanar da kai cewa an samo bayani.
  12. A wannan yanayin, matsalar shine canza yawan adadin kuɗi a cikin cell E3 zuwa 94.25.
  13. Don karɓar wannan bayani, danna Ya yi a cikin akwatin Gidan Goal na Goal, da kuma Goal Bincike ya canza bayanan cikin kwayar E3.
  14. Domin samun bayani daban, danna Soke a cikin Binciken Gano Goal. Binciken Goal ya dawo darajar a cikin cell E3 zuwa 60. Kun kasance a shirye don gudana Goal sake neman sake.