Sebenzisa i-Goal Funa lapho uhlela amaphrojekthi amasha
I-Excel's Goal Search feature ikuvumela ukuba ushintshe idatha esetshenziselwa ifomula ukuze uthole ukuthi yimiphi imiphumela ezoba nokushintshwa. Lesi sici siyasiza uma uhlela iphrojekthi entsha. Imiphumela ehlukene ingabe iqhathaniswa nokuthola ukuthi yiyiphi ehamba kahle ngokuvumelana nezidingo zakho.
Ukusebenzisa isici sokufuna i-Excel & # 39; s
Lesi sibonelo kuqala sisebenzisa umsebenzi we- PMT ukubala izinkokhelo zenyanga zenyanga. Isebenzisa i-Goal Seek ukunciphisa inkokhelo yenyanga ngenyanga ngokushintsha isikhathi sokubolekwa.
Okokuqala, faka idatha elandelayo kumaseli abonisiwe:
Cell - Idatha
D1 - Ukubuyisela Imali
I-D2 - Linganisa
D3 - Izinkokhelo ezingu- #
D4 - Oyinhloko
D5 - Ukukhokha
I-E2 - 6%
E3 - 60
E4 - $ 225,000
- Chofoza kumakhalekhukhwini E5 bese uthayipha ifomula elandelayo: = pmt (e2 / 12, e3, -4) bese ucindezela inkinobho ENTER ekhibhodi
- Inani elibiza u-$ 4,349.88 kufanele livele kuseli-E5. Lokhu kuyakhokhwa kwenyanga yenyanga mboleko.
Ukuguqula ukukhokha kwenyanga ngokusebenzisa i-Goal Search
- Chofoza kuthebhu yedatha ku-Ribbon.
- Khetha ukuthi-Uma Ukuhlaziya ukuvula uhlu lokudonsa phansi.
- Chofoza ku-Google Search .
- Ebhokisini lebhokisi , chofoza ku- Setha umugqa weseli .
- Chofoza ku- cell E5 kuspredishithi ukuze ushintshe izinkokhelo zenyanga zalomalimboleko.
- Ebhokisini lengxoxo, chofoza ku- To value line.
- Thayipha u- 3000 ukwehlisa inkokhelo yenyanga yonke ku-$ 3000.00.
- Ebhokisini lengxoxo, chofoza ku- Ngokushintsha umugqa weseli .
- Chofoza ku- cell E3 kuspredishithi ukushintsha inkokhelo yenyanga ngokushintsha inani lezinkokhelo okufanele zenziwe.
- Chofoza OK .
- Kuleli phuzu, i-Goal Seek kumele iqale ukufuna isisombululo. Uma ithola eyodwa, ibhokisi lebhokisi lokufuna i- Goal lizokukwazisa ukuthi isisombululo sitholiwe.
- Kulesi simo, isixazululo ukushintsha inani lokukhokha kweseli E3 kuya ku-94.25.
- Ukwamukela lesi sombululo, chofoza u- OK ku-Ibhokisi lengxoxo ye-Goal Search, futhi i-Goal Seek iguqula idatha ku-cell E3.
- Ukuthola isixazululo esithile, chofoza u- Khansela ebhokisini lebhokisi lokufuna le-Goal. I-Goal Funa ibuyisela inani elise-cell E3 kuya ku-60. Manje usulungele ukuqhuba i-Goal Seek futhi.