Yakha ifom ye-DIVIDE ukwahlula amanani kwi-Google Spreadsheets
Njengo-Excel, i-Google Spreadsheets ayinayo umsebenzi WONKE. Kunoko, kufuneka udale ifomu kwi-Google Spreadsheets ukwenza imisebenzi yecandelo. Le miyalelo ikuhamba ngokudala ifomula yecandelo, kubandakanywa iindlela ezahlukeneyo zokudala ifom, iimpazamo onokuzifumana kunye nendlela yokusebenzisa ifom ye-DIVIDE yeziphumo zepesenti.
Hlukanisa kwi-Google Spreadsheets usebenzisa iFormula
Ukwahlula amanani amabini oyifunayo ukudala ifomu , kuba akukho msebenzi we-DIVIDE kwi-Google Spreadsheets.
Amaphupha abalulekileyo okumele akhumbule ngeifomula zeGoogle Spreadsheet:
- Iifomula zisoloko ziqala ngophawu olulinganayo ( = ).
- Uphawu olulinganayo luhlala luhlala kwiseli apho ufuna impendulo ihambe khona.
- Umqhubi wecandelo lokwahlula phambili ( / ).
- Ifomula igqityiweyo ngokucinezela ukhiye wokungena kwikhibhodi.
Ukusebenzisa iiReferensi zeeSeli kwiifomula
Kuyakwazi ukungena manani ngqo kwifomula - njengoko kuboniswe kwimigangatho emibini neyesithathu kumzekelo ongentla.
Kungcono, nangona kunjalo, ukungena kwedatha kwiiseli zomsebenzi kwaye sebenzisa iidilesi okanye izikhokelo zala maseli kwifomu njengoko kuboniswe kwimigangatho emine ukuya kwisithandathu kumzekelo.
Ngokusebenzisa izikhokelo zeselula - ezifana ne-A2 okanye i-A5-kunokuba idatha ekhoyo kwifomula - kamva, ukuba kuyimfuneko ukutshintsha idatha , yinto elula yokutshintsha idatha kwiiseli kunokubhala kwakhona ifom.
Ngokuqhelekileyo, iziphumo zefomu ziya kuhlaziya ngokuzenzekelayo xa idatha iguquka.
Imizekelo yeFormula
Ifomula kwiseli yeB4 yomzekelo:
= A2 / A3
Ukwahlula nje idatha kwiiselula ze-A2 ngedatha kwi-A3 ukubuyisela impendulo yesibini.
Ukufaka i-Formula nge Point kwaye Cofa
Nangona kunokwenzeka ukuba uthayiphe nje ifom
= A2 / A3
Kwiseli ye-B4 kwaye ube nempendulo echanekileyo ye-2 kubonakaliso kwiseli, kungcono ukusebenzisa i- point-and-click or pointing to add the references to cell to form - ikakhulukazi ngamafomula amade.
Ukwenza njalo kuncitshiswe ukuba kukho iziphoso ezidalwe ngokuthayipha kwi-cell reference reference.
Iphoyinti kwaye nqakraza kuquka ukucofa kwiseli equle idatha kunye nekhompi ye mouse ukuze ungeze ifowuni yefomula.
Ukufaka ifom
- Uhlobo = (uphawu olulinganayo) kwiseli B4 ukuqala ifom.
- Cofa kwi-cell A2 kunye ne-mouse pointer ukuba ungeze ukuba isalathisi yesalathisi kwifom emva kokusayina okulinganayo.
- Uhlobo / (isayina sohlulo okanye ukutshatyalaliswa phambili) kwi-cell B4 emva kweselfowuni.
- Cofa kwifowuni A3 kunye nekhompi ye mouse ukuqinisekisa ukuba iselferensi yefomula kwifomula emva kwesayinwe.
- Cinezela ukungena kwikhibhodi ukugqiba ifom.
- Impendulo yesi-2 ifanele ibe khona kwiseli ye-B4 ukususela ngo-20 olwahlukileyo ngu-10 ulingana no-2.
- Nangona impendulo ibonakala kwiseli ye-B4, 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 kwezine ukuze ibonakalise utshintsho kwedatha kwiseli A3.
# DIV / O! I mpazamo
Impazamo eqhelekileyo ehambelana nemisebenzi yokwahlula i- # 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 lokwahlula - okanye i- quotient - lingaphantsi kweyodwa, i-Google Spreadsheets imele, ngokuzenzakalelayo, njengesiqingatha, njengoko kuboniswe kumqolo ohlanu, apho:
- Inani lokubala lihlelwe kwi-10.
- I-denominator ukuya kuma-20.
- I-quotient ilingana no-0.5.
Esi siphumo singatshintshwa sibe yipesenti ngokutshintsha ukufomatha kwiseli ukuya kufomathi yefomathi ukusuka kwimo engagqibekanga Ifomati yokuzenzekelayo - njengokuba kuboniswe kwisiphumo se-50% esiboniswe kwiseli B6 yomzekelo.
Le seli iqulethe ifom efana ne-cell B4. Ukwahlukana kuphela ukufomatha kwiseli.
Eyona nto, xa ifomathi ifomathi isetyenzisiwe, inkqubo iphindaphinda ixabiso elidlulileyo nge-100 kwaye yongeza uphawu lwepesenti.