Iifom zeSahlulo, # DIV / O! I-Error Error, kunye ne-Calculating Percents
Ukwahlula amanani amabini oyifunayo ukudala ifomu kuba akukho msebenzi we-DIVIDE kwi-Excel.
Amaphupha abalulekileyo okumele akhumbule malunga namafomula e-Excel:
- Iifomula kwi-Excel zihlala ziqala ngophawu olulinganayo ( = );
- Uphawu olulinganayo luhlala luhlala kwiseli apho ufuna impendulo ihambe khona;
- Isimboli sokwahlukana kukugqithiselwa phambili ( / );
- Ifomula igqityiweyo ngokucinezela ukhiye wokungena kwikhibhodi.
Ukusebenzisa iiReferensi zeeSeli kwiifomula
Nangona kunokwenzeka ukufaka manani ngqo kwifomu, kungcono ukufaka idatha kwiiseli zomsebenzi kwaye sebenzisa iidilesi okanye izikhokelo zala maseli kwifomu njengoko kuboniswe kumfanekiso ongentla.
Ngokusebenzisa izikhokelo zeselula - ezifana ne-A1 okanye iC5 - kunokuba idatha yangempela kwifom, kamva, ukuba kuyimfuneko ukutshintsha idatha , yinto elula yokutshintsha idatha kwiiseli kunokubhala kwakhona ifom.
Ngokuqhelekileyo, iziphumo zefomu ziya kuhlaziya ngokuzenzekelayo xa idatha iguquka.
Uluhlu lweFormula Example
Njengoko kuboniswe kumgca 2 kumfanekiso ongentla, lo mzekelo udala ifom e-cell B2 ekwahlula idatha kwiseli A2 ngedatha kwi-A3.
Ifom egcwalisiweyo kwiseli yeB2 iya kuba:
= A2 / A3
Ukungena kwiDatha
- Thayipha inombolo engu- 20 kwiseli ye-A2 uze ucinezela ukhiye wokungena kwikhibhodi;
- Thayipha inombolo ye- 10 kwiseli A3 uze ucinezela ukhiye wokungena .
Ukufaka iFomula yokuPhatha
Nangona kunokwenzeka ukuba uthayiphe nje ifom
= A2 / A3
kwi-cell B2 kwaye unempendulo echanekileyo yokubonisa 2 kwiseli, kungcono ukusebenzisa ukukhomba ukufaka iinkcazo zeeseli kwiifomula ukwenzela ukunciphisa amathuba okuphambuka okudalwe ngokuthayipha kwi-cell reference reference.
Ukupakisha kubandakanya ukucofa kwiseli equle idatha kunye nekhompi ye mouse ukuze wongeze i-cell reference kwifom.
Ukufaka ifom:
- Thayipha uphawu olulinganayo kwiseli B2 ukuqala ifom.
- Cofa kwi- cell A2 kunye ne-mouse pointer ukuba ungeze ukuba isalathisi yesalathisi kwifom emva kokusayina okulinganayo.
- Thayipha uphawu lokwahlula - u-slash phambili-( / ) kwisitokisi se-D1 emva kokubhekisele kweseli.
- Cofa kwifowuni A3 kunye nesalathisi semouse ukongeza ukuba iselferensi yesalathisi kwifomula emva kwesayinwe sohlulo;
- Cinezela ukhiye wokungena kwikhibhodi ukugqiba ifom;
- Impendulo yesi-2 ifanele ibe khona kwi-cell D1 ukususela ngo-20 olwahlukileyo ngu-10 ulingana no-2;
- Nangona impendulo ibonakala kwiseli D1, ukucofa kweso sisele kuya kubonisa ifom = A2 / A3 kwifom yefomula ngaphezu kwephepha lokusebenzela.
Ukutshintsha idatha yefomula
Ukuvavanya ukubaluleka kokusebenzisa izitenferensi zefomula kwifomu, tshintsha inombolo kwinombolo ye-A3 ukusuka kwi-10 kuya kwe-5 kwaye ucinezela ukungena kwekhibhodi.
Impendulo kwiseli yeB2 kufuneka ihlaziywe ngokuzenzekelayo ukuya kwi-4 ukubonisa utshintsho kwidatha kwi-cell A3.
# DIV / O! I mpazamo
Impazamo eqhelekileyo ehambelana nemisebenzi yecandelo kwi-Excel yiyo # DIV / O! xabiso le mpazamo .
Le mpazamo iboniswa xa i-denominator kwifomula yecandelo ilingana ne-zero-engavunyelwe kwisiganeko esiqhelekileyo.
Isizathu esenza ukuba kwenzeke oku kuyenzeka ukuba isalathisi yesalathisi engalunganga ingeniswe kwifomu okanye, njengoko kuboniswe kumgca 3 kumfanekiso ongentla, le fom yakopishwa kwenye indawo usebenzise isibambo sokuzalisa kunye nokutshintshwa kweeferensi zesalathisi kwiphutha .
Bala amaPhesenti kunye neForm Form
Ipesenti yinto efana nje phakathi kwamanani amabini asebenzisa ukusetyenziswa kwecandelo.
Ngokukodwa, yincinci okanye i-decimal ebalawulwa ngokuhlula i-numerator nge-denominator kwaye iphindaphinda umphumo nge-100.
Ifom ye-equation iya kuba:
= (inomboro / i-denominator) * 100
Xa iziphumo zecandelo lolwahlulo - okanye i-quotient - lingekho enye, i-Excel imele, ngokuzenzakalelayo, njengowokugqibela, njengoko kuboniswe kumgca we-4, apho isibalo sichazwe kwi-10, i-denominator ukuya kuma-20, kwaye i-quotient ilingana 0.5.
Esi siphumo singatshintshwa sibe yipesenti ngokutshintsha ukufomatha kwiseli ukuya kufomathi yefomati ukusuka kwindlela engapheliyo Ifomathi jikelele - njengoko kuboniswe kwisiphumo se-50% esiboniswe kwiseli B5 kumfanekiso ongentla.
Le seli iqulethe ifom efana ne-cell B4. Ukwahlukana kuphela ukufomatha kwiseli.
Enyanisweni, xa ukufometha kweepesenti kusetyenziswa kwi-Excel, inkqubo iphindaphinda ixabiso elidlulileyo nge-100 kwaye yongeza uphawu lwepesenti.
Ukudala iifomula ezingakumbi
Ukwandisa iifomula emfanekisweni ukufaka imisebenzi eyongezelelweyo - njengokuphindaphinda okanye ukongezelela - qhubeka uqhubeka ukongeza umqhubi weemathematika olandelelweyo olandelwa yereferensi yeseli equle idatha entsha.
Ngaphambi kokudibanisa imisebenzi ehlukeneyo yemathematika kunye kunye nefomula, ke kubalulekile ukuqonda ukulandelwa kwemisebenzi eyenziwa ngu-Excel xa uhlola i-formula.
Ukuziqhelanisa, zama le nyathelo ngomzekelo wesisombululo sefomula eqinile .