Ntchito YEARFRAC, monga dzina lake ikusonyezera, ingagwiritsidwe ntchito kupeza gawo la chaka lomwe limaimiridwa ndi nthawi pakati pa masiku awiri.
Ntchito zina za Excel zopezera chiwerengero cha masiku pakati pa masiku awiri zimangokhala kubwezera phindu m'zaka, miyezi, masiku, kapena zitatu.
Kuti zigwiritsidwe ntchito muzowerengera zotsatirazi, mtengo uwu ndiye ukuyenera kutembenuzidwa kukhala mawonekedwe apamwamba. YAM'MBUYO YOTSATIRA TUMIZANI LINKI SINDIKIZANI ILI MU KOPERANI MAPODIKASITI MITU YA NKHANI YAM'MBUYO YOTSATIRA
Kuwerengera kumeneku kungaphatikizepo machitidwe monga kutalika kwa ntchito ya antchito kapena chiwerengero choyenera kulipidwa pa mapulogalamu a pachaka omwe amathetsedwa mofulumira - monga mapindu a umoyo.
01 ya 06
Msonkhano Wachigawo wa YEARFRAC ndi Arguments
Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa .
Chidule cha ntchito YEARFRAC ndi:
= YEARFRAC (Start_date, End_date, Basis)
Yambani_date - (yofunikira) tsiku loyamba losiyana. Mtsutso uwu ukhoza kusandulika selo kumalo a deta mu tsamba la ntchito kapena tsiku lenileni loyambira mu nambala yowerengera .
Mapeto_date - (zofunikira) tsiku lachiwiri likusiyana. Zofunikanso zomwezo zimagwiritsidwa ntchito monga zomwe zikutanthauzidwa pa Start_date
Zosankha - (zosankha) Phindu lochokera pa zero mpaka lachinayi limene limalongosola Excel njira yowonjezera tsiku yomwe ingagwiritsidwe ntchito.
- 0 kapena kutaya - masiku 30 pa mwezi / 360 tsiku pachaka (US NASD)
1 - Nambala yeniyeni ya masiku pamwezi / Nambala yeniyeni ya masiku pachaka
2 - Chiwerengero cha masiku pa mwezi / masiku 360 pa chaka
3 - Chiwerengero cha masiku pa mwezi / masiku 365 pachaka
4 - 30 masiku pa mwezi / masiku 360 pa chaka (European)
Mfundo:
- YEARFRAC imabweretsanso #VALUE! Choyipa cholakwika ngati Start_date kapena End_date sizinali zolondola
- YEARFRAC imabweretsanso #NUM! Kulakwira kwachinyengo ngati kukangana kwazing'ono kuli kochepa kuposa zero kapena kuposera anayi
- Pazifukwa zomwe zilipo pazitsutso, maziko a 1 amapereka zolondola kwambiri masiku owerengera mwezi ndi masiku ndi chaka
- Zambiri zowonjezera pazitsutso zazing'ono zimaperekedwa kumapeto kwa phunzirolo
02 a 06
Chitsanzo Pogwiritsa ntchito ntchito ya YEARFRAC ya Excel
Monga momwe tikuonera pa chithunzi pamwambapa, chitsanzo ichi chigwiritsa ntchito YEARFRAC ntchito mu selo E3 kuti mupeze nthawi yaitali pakati pa masiku awiri - March 9, 2012, ndi November 1, 2013.
Chitsanzocho chimagwiritsa ntchito mafotokozedwe a selo kumalo amasiku oyambirira ndi omalizira chifukwa nthawi zambiri zimakhala zosavuta kugwira ntchito ndi kungoyamba kulowa mndandanda wamasiku.
Kenaka, sitepe yodzichepetsa yochepetsera chiwerengero cha malo apamwamba mu yankho lochokera ku zisanu ndi zinayi kapena ziwiri pogwiritsa ntchito ROUND ntchito idzawonjezedwa ku selo E4.
03 a 06
Kulowa Datorial Data
Zindikirani: Nthawi yamasiku oyambirira ndi yomalizira zidzalowetsedwa pogwiritsa ntchito DATE ntchito kuti zitha kuthetsa mavuto omwe angakhoze kuchitika ngati masikuwo atanthauzidwa ngati deta.
Cell - Data D1 - Yambani: D2 - Malizitsani: D3 - Kutalika kwa nthawi: D4 - Kuyankha kwakukulu: E1 - = DATE (2012,3,9) E2 - = DATE (2013,11,1)- Lowetsani deta zotsatirazi mu maselo D1 mpaka E2. Maselo E3 ndi E4 ndi malo omwe akugwiritsidwa ntchito mu chitsanzo
04 ya 06
Kulowa ntchito YEARFRAC
Chigawo ichi cha phunzirolo chimalowa ntchito YEARFRAC mu selo E3 ndikuwerengetsera nthawi pakati pa masiku awiriwa mu mawonekedwe a decimal.
- Dinani pa selo E3 - izi ndi zomwe zotsatira za ntchitoyi zidzawonetsedwa
- Dinani pa Fomu tab ya menyu yowonjezera
- Sankhani Tsiku ndi Nthawi kuchokera ku riboni kuti mutsegule ntchitoyi
- Dinani ku YEARFRAC mundandanda kuti mubweretse bokosi lazokambirana
- Mu bokosi la bokosi, dinani pa Start_date line
- Dinani pa selo E1 mu tsamba lothandizira kuti mulowetse selolo mu bokosi la dialog
- Dinani kumapeto a_date mubox
- Dinani pa selo E2 mu tsamba lothandizira kuti mulowetse selolo mu bokosi la dialog
- Dinani pa Mzere womwe uli mu bokosi la dialog
- Lowani nambala 1 pamzerewu kuti mugwiritse ntchito nambala yeniyeni ya mwezi pamwezi ndi chiwerengero chenicheni cha masiku pa chiwerengero
- Dinani OK kuti mutsirize ntchitoyi ndi kutseka bokosi la bokosi
- Phindu la 1.647058824 liyenera kuoneka mu selo E3 yomwe ili kutalika kwa nthawi pakati pa masiku awiri.
05 ya 06
Kukhazikitsa ntchito ROUND ndi YEARFRAC
Kuti ntchitoyi ikhale yosavuta kugwira nawo ntchito, mtengo mu selo E3 ukhoza kuyendetsedwa kumalo awiri osungirako ntchito pogwiritsa ntchito ROUND mu selo la YEARFRAC ndiko kudula ntchito YEARFRAC mkati mwa ntchito ROUND mu selo E3.
Zotsatira zake zidzakhala:
= ROUND (YEARFRAC (E1, E2,1), 2)Yankho likanakhala - 1.65.
06 ya 06
Mfundo Zomveka Zotsutsana
Kuphatikiza kwa masiku pa mwezi ndi masiku ndi chaka chifukwa cha kutsutsana kwa ntchito ya YEARFRAC kulipo chifukwa malonda m'madera osiyanasiyana - monga kugulitsa nawo malonda, chuma, ndi ndalama - ali ndi zofunikira zosiyana siyana za kayendetsedwe ka ndalama zawo.
Mwa kuyeza chiwerengero cha masiku pa mwezi, makampani akhoza kupanga kufananitsa mwezi ndi mwezi zomwe sizikanatheka kupezeka kuti masiku angapo pa mwezi akhoza kukhala kuyambira 28 mpaka 31 pa chaka.
Kwa makampani, kuyerekezera kumeneku kungakhale phindu, ndalama, kapena chifukwa cha ndalama, kuchuluka kwa chiwongoladzanja chomwe chinaperekedwa pazogulitsa. Mofananamo, kuwerengetsera chiwerengero cha masiku pa chaka kumalola kufananitsa chaka ndi chaka. Zowonjezera zowonjezera
Njira (US (NASD - National Association of Concession Dealers) njira:
- Ngati Start_date ndi tsiku lotsiriza la mwezi, limakhala lofanana ndi tsiku la 30 la mwezi womwewo.
- Ngati Kutsiriza_date ndi tsiku lotsiriza la mwezi ndipo Qur'an_yoyamba ilipo kuposa tsiku la 30 la mwezi, End_date imakhala yofanana ndi tsiku loyamba la mwezi wotsatira; mwinamwake, mapeto_date amakhala ofanana ndi tsiku la 30 la mwezi womwewo
Njira ya ku Ulaya:
- Yambani_miyezi ndi Mapeto_matchulidwe omwe amachitika pa tsiku la 31 la mweziwo ndi ofanana ndi tsiku la 30 la mwezi womwewo.