Umsebenzi we-Excel YEARFRAC

Umsebenzi we-YEARFRAC, njengoba igama lawo uphakamisa, ungasetshenziswa ukuthola ukuthi yingxenye yonyaka imelelwe isikhathi sesikhathi phakathi kwezinsuku ezimbili.

Ezinye imisebenzi ye-Excel yokuthola inani lezinsuku phakathi kwezinsuku ezimbili zilinganiselwe ukubuyisa inani kunoma yimiphi iminyaka, izinyanga, izinsuku, noma inhlanganisela yezintathu.

Ukuze isetshenziswe ekubaleni okulandelayo., Leli xabiso lizodinga ukuguqulwa libe ifomu lesidlangalaleni. I-YEARFRAC, ngakolunye uhlangothi, ibuyisela umehluko phakathi kwezinsuku ezimbili kwifomu ye-decimal - ngokuzenzakalelayo - njenge-1.65 iminyaka - ngakho umphumela ungasetshenziswa ngokuqondile kwezinye izibalo.

Lezi zibalo zingabandakanya amanani afana nobude bomsebenzi wesisebenzi noma iphesenti okufanele ikhokhwe ngezinhlelo zonyaka eziqedwa ekuqaleni - njengezinzuzo zezempilo.

01 ka-06

I-Syntax ye-YEARFRAC yoMsebenzi nama-Arguments

I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana .

I-syntax yomsebenzi we-YEARFRAC yile:

= YEARFRAC (Qala_kuqala, Qeda_date, Isisekelo)

Qala_kudinga - (okudingekayo) ukuhluka kwedethi yokuqala. Le mpikiswano ingaba ireferensi yeseli endaweni yedatha kumaphepha okusebenzela noma idethi yokuqala yangempela kwifomethi ye-serial .

I-End_date - (edingekayo) ukushintsha kwedethi yesibili. Izidingo ezifanayo zokuphikisana ziyasebenza njengalezo ezichazwe kwi- Start_date

Isisekelo - (ngokuzikhethela) Inani elivela ku-zero kuya ku-4 elitshela i-Excel ukuthi iyiphi indlela yokubala yosuku okufanele ukuyisebenzise ngomsebenzi.

1. 0 noma okushiyiwe - izinsuku ezingu-30 ngenyanga / 360 ngosuku ngonyaka (US NASD)
   1 - Inani langempela lezinsuku ngenyanga / Inani langempela lezinsuku ngonyaka
   2 - Inani langempela lezinsuku ngenyanga / izinsuku ezingu-360 ngonyaka
   3 - Inani langempela lezinsuku ngenyanga / izinsuku ezingu-365 ngonyaka
   Izinsuku ezingu-4 - 30 ngenyanga / izinsuku ezingu-360 ngonyaka (iYurophu)

Amanothi:

• YEARFRAC ibuyisela i- #VALUE! iphutha lenani uma i-Start_date noma i-End_date ayilona izinsuku ezivumelekile
• YEARFRAC ibuyisela i- #NUM! inani lephutha uma i-argument yesisekelo ingaphansi kwezinga noma ngaphezulu kunezine
• Kokukhethwa kukho okutholakala ngxabano lesisekelo, inani le-1 linikeza inembile kunazo zonke zokubala izinsuku ngenyanga nezinsuku ngonyaka
• Ukwaziswa okwengeziwe kwi- Basis argument kunikezwa ekupheleni kokufundisa

02 ka 06

Isibonelo Ukusebenzisa umsebenzi we-YEARFRAC we-Excel

Njengoba singabonakala esithombeni esingenhla, lesi sibonelo sizosebenzisa umsebenzi we-YEARFRAC kuseli E3 ukuthola isikhathi phakathi kwezinsuku ezimbili - Mashi 9, 2012, noNovemba 1, 2013.

Isibonelo sisebenzisa ukusetshenziswa kwezingcingo endaweni yesikhathi sokuqala nokuphela ngoba ngokuvamile kuvame ukusebenzisana nokufaka izinombolo zedethi ye-serial.

Okulandelayo, isinyathelo sokuzikhethela sokunciphisa inombolo yezindawo zamadesimali ekuphenduleni kusuka kuyisishiyagalolunye kuya kweyodwa usebenzisa umsebenzi we- ROUND uyongezwa kuseli E4.

03 ka 06

Ukufaka idatha yokufundisa

Qaphela: Izimpikiswano zokuqala nezinsuku zokugcina zizofakwa ngokusebenzisa umsebenzi we-DATE ukuvimbela izinkinga ezikhona ezingenzeka uma izinsuku zihunyushwa njengedatha yombhalo.

I-Cell - Idatha D1 - Qala: D2 - Qedela: D3 - Ubude besikhathi: D4 - Impendulo ejulile: E1 - = UMHLABA (2012,3,9) E2 - = UMHLABA (2013,11,1)

1. Faka idatha elandelayo kumaseli D1 kuya ku-E2. Amaseli e-E3 no-E4 yizindawo zokufomula ezisetshenziswe kusibonelo

04 ka 06

Ukufaka umsebenzi we-YEARFRAC

Lesi sigaba sokufundisa sifaka umsebenzi we-YEARFRAC esitokisini se-E3 futhi sinquma isikhathi esiphakathi kwezinsuku ezimbili kwifomu lesimingcele.

1. Chofoza kumakhalekhukhwini E3 - yilapho imiphumela yomsebenzi izoboniswa khona
2. Chofoza kuthebhu yefomula yemenyu ye- ribbon
3. Khetha Usuku Nesikhathi kusuka kubhebhoni ukuvula uhlu lwehla lokusebenza
4. Chofoza ku- YEARFRAC ohlwini ukuze ulethe ibhokisi lengxoxo lomsebenzi
5. Ebhokisini lebhokisi, chofoza ku- Start_date line
6. Chofoza ku-cell E1 kushidi lokusebenzela ukuze ufake ireferensi yeseli ebhokisini lengxoxo
7. Chofoza kumugqa we- End_date ebhokisini lengxoxo
8. Chofoza ku-cell E2 ekhasini lokusebenzela ukuze ufake ireferensi yeseli ebhokisini lengxoxo
9. Chofoza kulayini lomugqa ebhokisini lengxoxo
10. Faka inombolo 1 kulo mzila ukusebenzisa inombolo yangempela yezinyanga ngenyanga nenani langempela lezinsuku ngonyaka ekubalweni
11. Chofoza OK ukuqedela umsebenzi bese uvala ibhokisi lengxoxo
12. Inani elingu- 1.647058824 kufanele livele esitokisini se-E3 esilingana nesikhathi seminyaka phakathi kwezinsuku ezimbili.

05 ka 06

Iyakwenza imisebenzi ye-ROUND ne-YEARFRAC

Ukwenza umphumela womsebenzi usebenze kalula, inani le-cell E3 lingasungulwa ezindaweni ezimbili zamadesimali esebenzisa umsebenzi we-ROUND kuseli le-YEARFRAC ukukhipha umsebenzi we-YEARFRAC ngaphakathi komsebenzi we-ROUND kuseli le-E3.

Ifomula ephumela kuzoba:

= ROUND (YEARFRAC (E1, E2,1), 2)

Impendulo yayiyoba - 1.65.

06 ka-06

Ulwazi oluyisisekelo sokuvuvukala

Ukuhlanganiswa kwezinsuku ezahlukene ngenyanga kanye nezinsuku ngonyaka ngenxa ye-argument esisekelo yomsebenzi we-YEARFRAC iyatholakala ngoba amabhizinisi azinkambu ezihlukahlukene - njengokuhwebelana ngokuhlanganyela, ezokwezimali, kanye nezemali - anezidingo ezihlukene zezinhlelo zabo zokubalwa kwezimali.

Ngokumisa inani lezinsuku ngenyanga, izinkampani zingenza ukufaniswa kwenyanga nezinyanga okungenakwenzeka ukuthi kunikezwe ukuthi inani lezinsuku ngenyanga lingabuka ku-28 kuya ku-31 ngonyaka.

Kuzinkampani, lezi ziqhathaniso zingase zizuze izinzuzo, izindleko, noma esimweni sezimali zezimali, inani lezithakazelo ezitholakale ekutshalweni kwezimali. Ngokufanayo, ukulinganisa inani lezinsuku ngonyaka kuvumela ukuqhathaniswa konyaka kwedatha. Imininingwane eyengeziwe ye-

I-US (NASD - I-National Association of Dealer Securities):

• Uma i- Start_date yosuku lokugcina lwenyanga, lilingana nosuku lwama-30 lwenyanga efanayo.
• Uma i- End_date yosuku lokugcina lwenyanga futhi i- Start_date ingaphambi kwelanga lama-30 lwenyanga, i- End_date ilingana nosuku lokuqala lwenyanga ezayo; kungenjalo, i- End_date ilingana nosuku lwama-30 lwenyanga efanayo

Indlela yaseYurophu:

• Ama-Start_dates kanye nama- End_datha ezenzeka ngosuku lwama-31 lwenyanga zilingana nosuku lwama-30 lwenyanga efanayo.