Ifomula of "division" ku Excel - imigaqo esisiseko kunye nemizekelo ukusetyenziswa

Abasebenzisi abaqhele ukusebenza kunye neefomula isicelo sekhasi lolwandiso i "Excel 'ukusuka' Microsoft", maxa wambi ezama ukufumana umsebenzi esele zenziwe ngenxa hlula inani omnye ngomnye. Kodwa ke akukho msebenzi, kwaye sebenzisa i colon njengoko ayinayo - oko kwi "Excel" kujongwe ukuba libhekisela kuluhlu. Ifomula ye-hlula ukuya ku Excel - yinto ngumqondiso nje of a umgca (/).

Indlela yokwahlula inombolo omnye ngomnye

Xa "Excel" ncwadi hlobo yekhasi kwizisele ezahlukeneyo naziphi na amanani amabini. Baya kunceda ukusingatha yokwenza ifomula iyantlukwano Excel. Emva koko ke iseli uhlobo free eziphawula isiqalo olungumgubo (ngokulinganayo =) kwaye khetha iseli wokuqala ngaku. Okulandelayo uhlobo uphawu lokwahlulahlula in ifomula Excel - umgca okekeleyo ngasemva - kwaye khetha iseli nge, umahluli.

Lula, xa uzama Iseli iyantlukwano, okubhalwe apho 0, "Excel" ubonisa Impazamo efanelekileyo # DIV / 0!.

Okubalulekileyo! Excel ikuvumela ukuba wabelane nabanye naliphi na inani ngalinye, kuquka umhla. Kodwa xa uzama ukwenza iCandelo iiseli ungaqulatha umbhalo, uza kufumana i impazamo "# IXABISO!", Kukho ixabiso engalunganga.

Ulwahlulwa-hlulo umhla

Loo nto inika umdla gqitha ukwabelana imihla. Zama ukwabelana "01/01/2017" kwi "01.01.2016". Wena ucinga ukuba akuyi kuphumelela? Oku akunjalo. Isibakala sokuba "Excel" ngokuzenzekelayo uya kuyiguqula yonke imihla kwinani, ubala inani leentsuku ukususela ngoJanuwari 1, 1900. Umhla "01.01.1900" - inombolo 1, "01/02/1900" - 2. Unga lula khangela oku ngokuguqula ifomati iseli kunye nemihla amiselweyo kunye format kwi format 'yesitshixo Yamanani "" Umhla ". Ngenxa yoko, January 1, 2017 - eli nani 42736, bandiselwa sele kudlule imihla emininzi kangaka ukususela kuloo mhla enye inyanga 1900. Ngoko ke, ngokwahlula omnye umhla komnye, sinako ukufumana a result ethile.

Ngoko kusengqiqweni ukuba ukwazi ukwabelana nje kuphela umhla nomhla, kodwa naliphi na inani ngomhla vice versa. Ekubeni formula "division" e-Excel unokuzazisa umhla yakho inombolo. Yaye kunokwenzeka ukuba ukusebenza nayiphi na indlela oyithandayo.

Uluhlu ngokucandeka "Excel"

Ukwakha itafile "Excel", indawo A2 iseli: A6 wabeka amanani eziya ukwabelana (3, 7, 9 no-12, 15), kunye neeseli B1: E1 - inani eliza kwenza ulwahlulo (1, 2, 3, 4).

Ukudala division of kwetafile, kubalulekile ukukhumbula malunga iimbekiselo ngokugqibeleleyo xa kuthelekiswa kwi "Excel". Ifomula yokwahlukana Excel ekulungiseleleni kwetafile enjalo ukusebenzisa iimbekiselo exutyiweyo. Ngoko ke ukuba iidilesi iseli xa bekhuphela akukho isukile, kuyimfuneko ukulungisa kwikholam tivi inombolo idilesi, kunye nomabi - inombolo line. Ngenxa yoko, faka iseli B2 ifomula «= $ A2 / B $ 1" kwaye yitsale ngokusebenzisa umtya? kwaye ngoko ke itafile yonke. Table ezele data. Ngoku yima nayiphi iseli, umzekelo, kwi D5. ifomula yaso kulandelayo: «= $ A5 / D $ 1". Senza yonke into elungileyo.

Ukwahlula-hlula ngentsalela

Xa usenza i candelo, kwiimeko ezininzi sifumana inani iqhezu. Ukuze lula entsa amanani ezinjalo kwi "Excel" iingongoma ezimbini ezibalulekileyo.

Yeseli, eyayibhalwe yoko, okungagqibekanga ifomati "General". Ukuba uya tab "Ekhaya" kwi "Number" candelo, kusenokwenzeka ukuba esuka kuluhlu dropdown khetha utshintsho ifomati "Ezinye iindlela number" wabukhangelisa ifomathi 'yesitshixo Yamanani ". Ngayo le fomati linokukwenziwa kwinani iseli kweendawo lokugqibela. Ngenxa yoko, lelungelo 7/3 sidla ukubona inombolo 2,333333333, yaye ngoncedo komda ngqo kwiindawo ezintathu wokugqibela, oku kuya kukhangela ngathi 2.333. Yintoni oza uyavuma, Kuyinto elula.

I "Excel" inemisebenzi ezimbini ukuze ufumane QUOTIENT kunye nentsalela kwicandelo. Zibizwa ngokuba "yabucala" kunye "Ibhalansi" kwaye zombini uthabathe iimpikiswano ezimbini mandatory - njengenani eliphezulu nenani eliphantsi. Siza baqonde ngakumbi nabo.

Faka "Excel" amanani amabini - 7 no-3 (D9, kunye D10 esiseleni kulo mzekelo), kunye nelungelo kubo - of ifomula:

Njengoko sibona, lo QUOTIENT ilingana ezimbini, intsalela - 1. nayiphi iseli ezingenanto, faka ifomula:

= E9 & "" & E10 & "/" & D10

Apha ampersand inceda uqhoboshele imixholo omnye imixholo iseli enye itekisi.

Isiphumo sale ifomyula kulandelayo: 2 1/3 - ezimbini ngenqaku elinye kwisithathu.

Njengoko ubona, ifomula yokwahlukana Excel ayikho into enkulu. Eyona nto ibalulekileyo ukuba ukukhumbula ukuba ezi ifomula ukubala "Excel" usebenzisa imithetho ngomgangatho wemathematika.