Imisebenzi yezezimali ku-Microsoft Excel

I-Microsoft Excel ihlinzeka ngezinhlobonhlobo zemisebenzi ekuvumela ukuthi ukwazi ukubhekana nemisebenzi yezibalo, ezomnotho, yezezimali neminye. Lolu hlelo lungenye yamathuluzi ayinhloko asetshenziswa ezinhlanganweni ezincane, eziphakathi nezinkulu ekugcineni izinhlobo ezahlukene zokubala, ukwenza izibalo, njll. Ngezansi sizobheka imisebenzi yezezimali edingeka kakhulu ku-Excel.

Ifaka umsebenzi

Okokuqala, ake sikhumbule indlela yokufaka umsebenzi kuseli yetafula. Ungakwenza lokhu ngezindlela ezahlukene:

1. Ngemva kokukhetha iseli oyifunayo, chofoza isithonjana "fx (Faka umsebenzi)" kwesokunxele sebha yefomula.
2. Noma shintshela kuthebhu "Amafomula" bese uchofoza inkinobho efanayo etholakala ekhoneni elingakwesokunxele leribhoni yohlelo.

Kungakhathaliseki ukuthi iyiphi inketho ekhethiwe, iwindi lomsebenzi wokufaka lizovuleka, lapho udinga ukukhetha isigaba “Ezezimali”, nquma ngomsebenzi omfunayo (isibonelo, INGENISO), bese ucindezela inkinobho OK.

Iwindi lizovela esikrinini elinama-agumenti omsebenzi okufanele uwugcwalise, bese uchofoza inkinobho ethi KULUNGILE ukuze uyengeze kuseli ekhethiwe futhi uthole umphumela.

Ungakwazi ukucacisa idatha ngesandla usebenzisa okhiye bekhibhodi (amanani athile noma ireferensi yeseli), noma ngokufaka endaweni ephambene ne-agumenti oyifunayo, khetha izinto ezihambisanayo kuthebula ngokwalo (amaseli, ububanzi bamaseli) usebenzisa inkinobho yegundane engakwesokunxele ( uma kuvunyelwe).

Sicela uqaphele ukuthi amanye ama-agumenti angase angaboniswa futhi kufanele uskrolele phansi endaweni ukuze ufinyelele kuwo (usebenzisa izilayidi eziqondile kwesokudla).

Enye indlela

Ukuba kuthebhu "Amafomula" ungacindezela inkinobho “Ezezimali” eqenjini "Ilabhulali Yomsebenzi". Uhlu lwezinketho ezitholakalayo luzovuleka, phakathi kwalo vele uchofoze kulo oludingayo.

Ngemva kwalokho, iwindi elinezimpikiswano zomsebenzi okufanele ligcwaliswe lizovuleka ngokushesha.

Imisebenzi yezezimali edumile

Manje njengoba sesitholile ukuthi umsebenzi ufakwa kanjani kuseli kusipredishithi se-Excel, ake sidlulele ohlwini lwabasebenzi bezezimali (olwethulwa ngokulandelana kwezinhlamvu).

BS

Lesi sisebenzisi sisetshenziselwa ukubala inani lesikhathi esizayo le-investimenti ngokusekelwe ezinkokhelweni ezilinganayo zezikhathi ezithile (njalo) kanye nenani lenzalo (njalo).

Izimpikiswano Ezidingekayo (amapharamitha) okumele agcwaliswe yilawa:

• Bet - izinga lenzalo yaleso sikhathi;
• I-Kper – inani lezikhathi zokukhokha;
• I-Plt - ukukhokhelwa njalo kwesikhathi ngasinye.

Izimpikiswano ozikhethela zona:

• Ps inani lamanje (lamanje). Uma ishiywe ingenalutho, inani elilingana ne "0";
• Uhlobo - uthi lapha:
  • 0 - inkokhelo ekupheleni kwesikhathi;
  • 1 – inkokhelo ekuqaleni kwesikhathi
  • uma inkambu ishiywa ingenalutho, izozenzakalela ibe nguziro.

Kuyenzeka futhi ukuthi ufake ngokwakho ifomula yomsebenzi ngokushesha kuseli ekhethiwe, udlule umsebenzi kanye namafasitela okufaka impikiswano.

I-syntax yomsebenzi:

=БС(ставка;кпер;плт;[пс];[тип])

Umphumela kuseli kanye nesisho kubha yefomula:

VOD

Umsebenzi ikuvumela ukubala isilinganiso sangaphakathi sembuyiselo yochungechunge lokugeleza kwemali okushiwo ngezinombolo.

Impikiswano edingekayo eyodwa kuphela - “Amanani”, lapho udinga ukucacisa uhlu noma izixhumanisi zobubanzi bamaseli anamanani ezinombolo (okungenani inombolo eyodwa enegethivu kanye neyodwa eyiphozithivu) lapho kubalwa kuzokwenziwa khona.

Ukuphikisana ongakukhetha - "Ukucabangela". Lapha, inani elilindelekile liyaboniswa, eliseduze nomphumela VOD. Uma le nkambu ishiywa ingenalutho, inani elizenzakalelayo lizoba ngu-10% (noma u-0,1).

I-syntax yomsebenzi:

=ВСД(значения;[предположение])

Umphumela kuseli kanye nesisho kubha yefomula:

INGENISO

Ngokusebenzisa lesi sisebenzisi, ungakwazi ukubala isivuno sezibambiso lapho inzalo yezikhathi ezithile ikhokhwa ngayo.

Izimpikiswano ezidingekayo:

• date_acc - usuku lwesivumelwano/sokukhokha izibambiso (ngemuva kwalokhu okubizwa ngokuthi izibambiso);
• Idethi_eqalayo - usuku lokuqala ukusebenza/ukukhululwa kwezibambiso;
• Bet - izinga lekhuphoni lonyaka lezibambiso;
• Inani - intengo yezibambiso ngama-ruble ayi-100 yenani lobuso;
• Ukubuyiselwa - amanani okubuyisela noma inani lokuhlengwa lezibambiso. ama-ruble ayi-100 ebusweni;
• imvamisa – inani lezinkokhelo ngonyaka.

Ukungqubuzana "Isisekelo" is Ukuzikhethela, icacisa ukuthi usuku lubalwa kanjani:

• 0 noma engenalutho - American (NASD) 30/360;
• 1 – okwangempela/okwangempela;
• 2 - okwangempela/360;
• 3 - okwangempela/365;
• 4 - European 30/360.

I-syntax yomsebenzi:

=ДОХОД(дата_согл;дата_вступл_в_силу;ставка;цена;погашение;частота;[базис])

Umphumela kuseli kanye nesisho kubha yefomula:

I-MVSD

Umsebenzisi usetshenziselwa ukubala inani langaphakathi lembuyiselo lenani lokugeleza kwemali ngezikhathi ezithile ngokusekelwe ezindlekweni zokukhulisa utshalomali, kanye namaphesenti emali ephinde yatshalwa.

Umsebenzi unawo kuphela izimpikiswano ezidingekayo, okubandakanya:

• Amanani – okunegethivu (izinkokhelo) kanye nezinombolo eziphozithivu (amarisidi) akhonjisiwe, ethulwa njengohlu noma njengereferensi yamaseli. Ngokufanelekile, okungenani inani lenombolo elilodwa eliphozithivu nenegethivu kufanele likhonjiswe lapha;
• Linganisa_ezezimali – izinga lenzalo elikhokhelwe izimali ezisetshenziswayo;
• Linganisa _phinda tshala – isilinganiso senzalo sokutshalwa kabusha kwezimpahla zamanje.

I-syntax yomsebenzi:

=МВСД(значения;ставка_финанс;ставка_реинвест)

Umphumela kuseli kanye nesisho kubha yefomula:

INORMA

Umsebenzisi ikuvumela ukubala izinga lenzalo yezibambiso ezitshalwe ngokugcwele.

Ama-agumenti omsebenzi:

• date_acc - usuku lokukhokha izibambiso;
• Idethi_eqalayo - idethi yokukhishwa kwezibambiso;
• Investment - inani elitshalwe ezibambiso;
• Ukubuyiselwa - inani elizotholwa lapho kukhishwa izibambiso;
• i-agumenti "Isisekelo" mayelana nomsebenzi INGENISO kungakhethwa.

I-syntax yomsebenzi:

=ИНОРМА(дата_согл;дата_вступл_в_силу;инвестиция;погашение;[базис])

Umphumela kuseli kanye nesisho kubha yefomula:

I-PLT

Lo msebenzi ubala inani lenkokhelo yezikhathi ezithile emalini ebolekiwe ngokusekelwe ekuqhubekeni kwezinkokhelo nezinga lenzalo.

Izimpikiswano ezidingekayo:

• Bet - izinga lenzalo ngesikhathi semalimboleko;
• I-Kper – inani lezikhathi zokukhokha;
• Ps inani lamanje (lamanje).

Izimpikiswano ozikhethela zona:

• Bs - inani lesikhathi esizayo (ibhalansi ngemuva kwenkokhelo yokugcina). Uma inkambu ishiywa ingenalutho, izozenzakalela ukuthi "0".
• Uhlobo - lapha ucacisa ukuthi inkokhelo izokwenziwa kanjani:
  • "0" noma kungashiwongo - ekupheleni kwesikhathi;
  • "1" - ekuqaleni kwesikhathi.

I-syntax yomsebenzi:

=ПЛТ(ставка;кпер;пс;[бс];[тип])

Umphumela kuseli kanye nesisho kubha yefomula:

KWAMUkelwe

Isetshenziselwa ukuthola inani elizotholwa ngokuvuthwa kwezibambiso ezitshaliwe.

Ama-agumenti omsebenzi:

• date_acc - usuku lokukhokha izibambiso;
• Idethi_eqalayo - idethi yokukhishwa kwezibambiso;
• Investment - inani elitshalwe ezibambiso;
• Discount - isilinganiso sesaphulelo sezibambiso;
• "Isisekelo" - ukuphikisana kokuzikhethela (bona umsebenzi INGENISO).

I-syntax yomsebenzi:

=ПОЛУЧЕНО(дата_согл;дата_вступл_в_силу;инвестиция;дисконт;[базис])

Umphumela kuseli kanye nesisho kubha yefomula:

PS

Umsebenzisi usetshenziselwa ukuthola inani lamanje (okungukuthi, kuze kube manje) le-investimenti, elihambisana nochungechunge lwezinkokhelo zesikhathi esizayo.

Izimpikiswano ezidingekayo:

• Bet - izinga lenzalo yaleso sikhathi;
• I-Kper – inani lezikhathi zokukhokha;
• I-Plt - ukukhokhelwa njalo kwesikhathi ngasinye.

Izimpikiswano Ongazikhetha - okufanayo nangohlelo "PLT":

• Bs - inani lesikhathi esizayo;
• Uhlobo.

I-syntax yomsebenzi:

=ПС(ставка;кпер;плт;[бс];[тип])

Umphumela kuseli kanye nesisho kubha yefomula:

ISITOLO

Umsebenzisi uzokusiza ukuthi uthole inani lenzalo yempesheni (irenti yezimali) isikhathi esingu-1.

Izimpikiswano ezidingekayo:

• I-Kper – inani lezikhathi zokukhokha;
• I-Plt - ukukhokha njalo esikhathini ngasinye;
• Ps inani lamanje.

Izimpikiswano Ongazikhetha:

• Bs - inani lesikhathi esizayo (bona umsebenzi I-PLT);
• Uhlobo (bona umsebenzi I-PLT);
• Ukuqagela – inani elilindelekile lokubheja. Uma kungashiwongo, inani elizenzakalelayo lika-10% (noma u-0,1) lizosetshenziswa.

I-syntax yomsebenzi:

=СТАВКА(кпер;;плт;пс;[бс];[тип];[предположение])

Umphumela kuseli kanye nesisho kubha yefomula:

PRICE

I-opharetha ikuvumela ukuthi uthole intengo yama-ruble ayi-100 yenani elijwayelekile lezibambiso, okukhokhwa inzalo yezikhathi ezithile.

Izimpikiswano ezidingekayo:

• date_acc - usuku lokukhokha izibambiso;
• Idethi_eqalayo - idethi yokukhishwa kwezibambiso;
• Bet - izinga lekhuphoni lonyaka lezibambiso;
• Income - imali engenayo yonyaka yezibambiso;
• Ukubuyiselwa - inani lokuhlengwa kwezibambiso. ama-ruble ayi-100 ebusweni;
• imvamisa – inani lezinkokhelo ngonyaka.

Ukungqubuzana "Isisekelo" mayelana nomsebenzisi INGENISO is Ukuzikhethela.

I-syntax yomsebenzi:

=ЦЕНА(дата_согл;дата_вступл_в_силу;ставка;доход;погашение;частота;[базис])

Umphumela kuseli kanye nesisho kubha yefomula:

I-ChPS

Usebenzisa lo msebenzi, ungakwazi ukunquma inani lamanje lengqikithi ye-investimenti ngokusekelwe esilinganisweni sesaphulelo, kanye nenani lamarisidi nezinkokhelo zesikhathi esizayo.

Ama-agumenti omsebenzi:

• Bet - isilinganiso sesaphulelo isikhathi esingu-1;
• Incazelo1 – izinkokhelo (amanani anegative) namarisidi (amanani avumayo) ekupheleni kwesikhathi ngasinye kukhonjisiwe lapha. Inkambu ingaqukatha amanani angafika kwangu-254.
• Uma umkhawulo we-agumenti “Inani 1” usukhathele, ungaqhubeka ugcwalise okulandelayo - "Value2", "Value3" njll

I-syntax yomsebenzi:

=ЧПС(ставка;значение1;[значение2];...)

Umphumela kuseli kanye nesisho kubha yefomula:

Isiphetho

Isigaba “Ezezimali” I-Excel inemisebenzi ehlukene engaphezu kuka-50, kodwa eminingi yayo icacile futhi igxile kancane, yingakho ingavamile ukusetshenziswa. Sicabangele i-11 ethandwa kakhulu, ngokombono wethu.