Shandisa Chinangwa Tsvaka pakuronga mapurogiramu matsva
Chinangwa cheCexcel Tsvaga chiitiko chinokubvumira kuti uchinje dashandisi inoshandiswa mumurairo kuitira kuti uwane kuti zvii zvichazove nekugadzirisa. Izvi zvinobatsira kana uri kuronga basa idzva. Mhinduro dzakasiyana dzinogona kuenzaniswa nekuwana kuti ndiani anonyatsokodzera zvaunoda.
Kushandisa Excel & # 39; s Goal Seek Feature
Muenzaniso uyu unotanga kushandisa basa re PMT kuverenga kubhadhara kwemwedzi kune chikwereti. Icho chinoshandisa Chinangwa Chekutsvaga kuderedza mutero wemwedzi wega wega nekuchinja nguva yechikwereti.
Kutanga, shandisa data inotevera mumasero akaratidzirwa:
Cell - Data
D1 - Kubhadhara mari
D2 - Terera
D3 - # Kwokubhadhara
D4 - Mukuru
D5 - Kubhadhara
E2 - 6%
E3 - 60
E4 - $ 225,000
- Dzvanya pane cell E5 uye nyora inotevera fomula: = pmt (e2 / 12, e3, -4) uye shandisa ENTER key pane keyboard
- Kukosha kwe $ 4,349.88 kunofanira kuonekwa muchitokisi E5. Iyi ndiyo mari yekubhadhara kwemwedzi.
Kuchinja Mutero weMwedzi uchishandisa Goal Seek
- Dzvanya paData Data pane ibhoni.
- Sarudza Chii-Kana Kuongorora kuzarura dhesi-pasi.
- Dzvanya paGomo Tsvaka .
- Mubhokisi rebhokisi , tora pa Set Set cell line.
- Dzvanya pane cell E5 mune pepadheet kuti uchinje kubhadhara kwemwedzi kune chikwereti ichi.
- Mubhokisi rebhokisi, chengetera ku Kukoshesa mutsara.
- Tora 3000 kuderedza mutero wemwedzi wega we $ 3000.00.
- Mubhokisi rebhokisi, chengetedza paKushandura sejeri mutsara.
- Dzvanyira pane cell E3 mune pepanheetti kuti uchinje kubhadhara kwemwedzi wega kwega nekuchinja huwandu hwekubhadhara kunofanira kuitwa.
- Dzvanya OK .
- Panguva ino, Goal Seek inofanira kutanga kutsvaga mhinduro. Kana ikawana imwe, chinangwa chinangwa chebhokisi chinokurudzira kuti sarudzo yawanikwa.
- Muchiitiko ichi, mhinduro ndeyokuchinja nhamba yebhadharo muchitsetse E3 kusvika ku 94.25.
- Kugamuchira iyi sarudzo, sarudza OK muGoal Search dialog box, uye Goal Seek inoshandura data iri muchitsetse E3.
- Kuti uwane mhinduro yakasiyana, bhura Chengetera muGomo Tsvagai bhokisi rebhokisi. Chinangwa Tsvaga kudzorera kukosha muchitokisi E3 kusvika ku 60. Iwe zvino wakagadzirira kumhanya Goal Search zvakare.