Kwiiprogram ze-spreadsheet ezifana ne-Excel kunye ne-Google Spreadsheet, ixabiso linokubhaliweyo, imihla, iinombolo, okanye i- Boolean idatha . Ngaloo ndlela, ixabiso lihluke ngokuxhomekeke kulolu hlobo lwedatha olubhekiselele kulo:
- Idatha yeenombolo, ixabiso libhekisela kwinani lamanani - njengama-10 okanye-20 kwiiseli ze-A2 kunye ne-A3;
- Ukufumana idatha yombhalo, ixabiso libhekisela kwigama okanye ngentambo - njengeTekisi kwiseli A5 kwiphepha lokusebenzela;
- Idatha ye-Boolean okanye inengqiqo, ixabiso libhekiselele kummandla wedatha - nokuba yi-TRUE okanye FALSE njengeseli ye-A6 kumfanekiso.
Ixabiso lingasetyenziselwa nangomqathango wemeko okanye ipharamitha ekufuneka idibene kwiphepha lokusebenzela ukuba iziphumo ezithile zenzeke.
Umzekelo, xa uhlunga idatha, ixabiso liyimeko yokuba idatha kufuneka idibene ukuze ihlale etafileni yedata kwaye ingahlanjululwa.
Ukubonakalisa ixabiso. Ixabiso langempela
Idata eboniswe kwiselfowuni yomsebenzi ayinakuba yixabiso langempela elisetyenzisiweyo ukuba loo nqwelwana iboniswe kwifom.
Ukwahluka okunjalo kwenzeka xa ukufomatha kusetyenziswa kwiiseli ezichaphazela ukubonakala kwedata. Ezi zinguqu zokufomathiza ayitshintshi idatha egcinwe yiprogram.
Ngokomzekelo, i-cell A2 ifomathiweyo ukuba iboniswe iindawo zokugqibela zeedatha. Ngenxa yoko, idatha eboniswe kwiseli ingama- 20 , kunokuba ixabiso langempela le- 20.154 njengoko kuboniswe kwibha yefomula .
Ngenxa yoko, umphumo wefomyula kwiseli yeB2 (= A2 / A3) yi-2.0154 kunokuba i-2 kuphela.
Iimpazamo zeMilinganiselo
Ixabiso lexesha linxulumene nexabiso leephene, - njenge-#NULL !, #REF !, okanye # DIV / 0 !, eziboniswayo xa i-Excel okanye i-Google Spreadsheets ibona iingxaki ngefomula okanye idatha abayibhekise kuyo.
Ziyabonwa njengexabiso kwaye azikho impazamo yempazamo njengoko ziyakubandakanywa njengeengxoxo malunga nemisebenzi ethile yomsebenzi.
Umzekelo ungabonwa kwiseli B3 emfanekisweni, ngenxa yokuba ifom yelo seli lizama ukwahlula inamba kwi-A2 nge-A3 ye-blank blank.
I-cell engenanto iphathwa njengexabiso lenani kunokuba ingabi nalutho, ngoko ke umphumo wexabiso lephutha # DIV / 0, ekubeni i-formula izama ukwahlula nge-zero, engenakwenziwa.
#VALUE! I mpazamo
Enye iphutha lexabiso libizwa ngokuba ngu-#VALUE! kwaye kwenzeka xa ifomula ibandakanya ukubhekiselwe kwiiseli ezinemixholo eyahlukeneyo yedatha - njengombhalo kunye namanani.
Ngokukodwa, eli xabiso lephutha liboniswa xa iifom ebonisa enye okanye iiseli eziqukethe idatha yombhalo esikhundleni seenombolo kwaye ifom yezame ukwenza umsebenzi we-arithmetic - engeza, ukususa, ukwanda, okanye ukwahlula - usebenzisa ubuncinane abaqhubi be-arithmetic: +, -, *, okanye /.
Umzekelo uboniswe kumgca we-4 apho ifom, = A3 / A4, izama ukwahlula inamba ye-10 kwiseli ye-A3 ngelizwi kuVavanyo kwi-A4. Ngenxa yokuba inombolo ayikwazi ukwahlula ngedata yombhalo, ifomula ibuyisela i-#VALUE!
Iimilinganiselo eziqhubekayo
I- alue iphinda isetyenziswe kwi-Excel kunye ne-Google Spreadsheets eneemilinganiselo eziqhubekayo , ezixabiso elitshintshanayo- njengentlawulo yerhafu - okanye ingatshintshi konke - njengexabiso leP (3.14).
Ngokunikezela ngexabiso eliqhubekayo igama elichazayo - njenge- TaxRate - yenza kube lula ukuwafaka kwiifomula zespredishithi .
Ukucacisa amagama kwiimeko ezinjalo mhlawumbi kunokwenzeka ngokugqithiseleyo usebenzisa iBhokisi legama kwi-Excel okanye ngokuchofoza iDatha> Amanqaku anegama ... kwimenyu kwi-Google Spreadsheets.
Ukusetyenziswa kwangaphambili kwexabiso
Kwixesha elidlulileyo, ixabiso lexesha lalisetyenziselwa ukuchaza idatha yeenombolo ezisetyenziswa kwiiprogram ze-spreadsheet.
Oku kusetshenziswe ngokukodwa kwimizuzu yenombolo yegama , nangona zombini i-Excel kunye ne-Google Spreadsheets zombili zine- VALUE function. Lo msebenzi usebenzisa igama kwiqondo langaphambili ukususela ekubeni injongo yomsebenzi iguqula ukufakwa kwamagama kumanani.