Kuzinhlelo zespredishithi njenge-Excel nama-Google Spreadsheets, amanani angabhala umbhalo, izinsuku, izinombolo, noma idatha ye-Boolean . Njengalokhu, inani lihlukahluka kuye ngokuthi uhlobo lwedatha olubhekisela kulo:
- Ngedatha yenombolo, inani libhekisela kwinamba yedatha - njengama-10 noma angu-20 kumaseli A2 no-A3;
- Ukuze uthole idatha yombhalo, inani libhekisela egameni noma string - njenge- Umbhalo ku-cell A5 ekhasini lokusebenzela;
- Idatha ye-Boolean noma enengqondo, inani libhekisela kumbuso wedatha - kungaba yi-TRUE noma i-FALSE njengeseli cell A6 esithombeni.
Inani lingabuye lisetshenziswe ngomqondo wesimo noma ipharamitha okumelwe ihlangabezane kushidi lokusebenza ukuze imiphumela ethile itholakale.
Isibonelo, uma uhlunga idatha, inani liyisimo sokuthi idatha kufanele ihlangane ukuze ihlale etafuleni yedatha futhi ingasetshenziswa.
Inani elibonisiwe Vs. Inani langempela
Idatha ekhonjiswa esitokisini sephepha lokusebenza kungenzeka ukuthi ingabi yigugu langempela elisetshenzisiwe uma leyo cell ishiwo efomini.
Ukungezwani okunjalo kwenzeka uma ukufometha kusetshenziselwa amangqamuzana athinta ukubukeka kwedatha. Lezi zinguquko zokufometha aziguquli idatha yangempela egcinwe wuhlelo.
Isibonelo, iseli A2 lifomathiwe ukukhombisa izindawo ezingadluli yedatha. Ngenxa yalokho, idatha ekhonjiswe esitokisini ingama- 20 , kunokubaluleka kwangempela kwe- 20.154 njengoba kuboniswe kubha yamatomu .
Ngenxa yalokhu, umphumela wefomula esitokisini B2 (= A2 / A3) ngu-2.0154 kunokuba nje 2.
Iphutha lama-Values
Inani legama liphinde lihlotshaniswe namanani wephutha , - njenge-#NULL !, #REF !, noma # DIV / 0 !, okuboniswa uma i-Excel noma i-Google Spreadsheets ithola izinkinga ngamafomula noma idatha abayibhekisela kuyo.
Zibhekwa njengamagugu hhayi imilayezo yephutha njengoba zingabalwa njengezingxabano zeminye imisebenzi ye-worksheets.
Isibonelo singabonakala esitokisini B3 esithombeni, ngoba ifomula kuleso seli lizama ukwehlukanisa inombolo ku-A2 nge-A3 engenalutho.
I-cell engenalutho iphathwe njengenani le-zero kunokuba lingenalutho, ngakho-ke umphumela uyinani lephutha # DIV / 0 !, njengoba ifomula lizama ukuhlukanisa nge-zero, elingenakwenziwa.
#VALUE! Amaphutha
Enye iphutha inani libizwa ngokuthi "#VALUE"! futhi kwenzeka uma ifomula ihlanganisa ukubhekisela kwamaseli anemifula ehlukene yedatha - umbhalo kanye nezinombolo ezinjalo.
Ngokuqondile, le namba yephutha iboniswa uma ifomula ibhekisela kumunye amaseli noma amanye amangqamuzana aqukethe idatha yombhalo esikhundleni sezinombolo futhi ifomula lizama ukwenza umsebenzi we-arithmetic - engeza, ukukhipha, ukuphindaphinda, noma ukwahlukanisa - usebenzisa okungenani abaqhubi be-arithmetic eyodwa: +, -, *, noma /.
Isibonelo siboniswa kulayini 4 lapho ifomu, = A3 / A4, lizama ukuhlukanisa inombolo engu-10 kwiseli A3 ngegama elithi Test in A4. Ngoba inombolo ayikwazi ukuhlukaniswa ngedatha yombhalo, ifomula ibuyisela i- #VALUE!
Izimiso Zonke
I- Alue nayo isetshenziselwa ku-Excel ne-Google Spreadsheets enezimiso ezingaguquki , eziyigugu ezishintsha njalo - njengezinga lentela - noma ungashintshi nhlobo - njengePi value (3.14).
Ngokunikeza amanani anjalo ajwayelekile igama elichazayo - njenge- TaxRate - kwenza kube lula ukubhekisela kumafomulashethi wespredishithi.
Ukuchaza amagama ezimweni ezinjalo cishe kufezwa kalula usebenzisa Ibhokisi Legama ku-Excel noma ngokuchofoza idatha> Idatha Ebizwa ngokuthi ... kumamenyu ku-Google Spreadsheets.
Ukusetshenziswa kwangaphambilini kwe-Value
Esikhathini esidlule, inani lentengo lisetshenziselwa ukuchaza idatha yezinombolo ezisetshenziselwa izinhlelo zespredishithi.
Lokhu kusetshenziselwa kakhulu idatha yendiza yesikhathi , nakuba kokubili i-Excel ne-Google Spreadsheets zombili zine- VALUE umsebenzi. Lo msebenzi usebenzisa leli gama ngomqondo walo wokuqala kusukela ngenhloso yomsebenzi kuguqula ukufakwa kwamathekisthi kube izinombolo.