Mune mapurogiramu epadheseti akadai seExcel neGoogle Spreadsheets, maitiro anogona kuva magwaro, mazuva, nhamba, kana kuti Boolean data . Sezvo zvakadaro, kukosha kunopesana zvichienderana nehuwandu hwemashoko ari kureva:
- Nekuverenga nhamba, kukosha kunoreva kuwanda kwehuwandu hwemashoko - zvakadai se10 kana 20 mumasero A2 neA3;
- Kana zviri zvinyorwa deta, kukosha kunoreva izwi kana tambo - yakadai seMagwaro muchitokisi A5 mune pepa rekushanda;
- Nezwi reBoolean kana rinonzwisisika, kukosha kunoreva nzvimbo ye data - zvichida ECHOKWADI kana FALSE seyero cell A6 mumufananidzo.
Purogiramu inogonawo kushandiswa mupfungwa yemamiriro kana parameter inofanirwa kusangana mune pepa rekuti zvimwe zviitiko zviitike.
Semuenzaniso, kana uchinyora deta, kukosha ndiyo mamiriro ezvinhu kuti data inofanira kusangana kuitira kuti urambe uri mutafura yezvinyorwa uye usasarudzwa.
Kuratidza Kukosha Vs. Zvechokwadi kukoshesa
Dhiyabhorosi iyo inoratidzirwa mune imwe sero rekushanda ingasave iyo yakakosha kukosha iyo inoshandiswa kana iyo sero inotsanangurwa mumutambo.
Kusiyana kwakadaro kunowanikwa kana kuisa mafashoni kunoshandiswa kumasero anokanganisa kuonekwa kwe data. Aya maitiro ekugadzirisa haachinje chaiwo data yakachengetedzwa neprogram.
Semuenzaniso, sero reA2 rave rakarongedzwa kuti risati ratidza nzvimbo dzepamusoro dze data. Somugumisiro, data inoratidzwa muchitokisi ndeye 20 , panzvimbo yehuwandu hunokosha hwe20.154 sezvinoratidzwa mubhairi yebha .
Nemhaka yeizvi, chigumisiro chemuumbi muchitokisi B2 (= A2 / A3) chikamu 2.0154 kwete pane 2 chete.
Kukanganisa Maitiro
Izwi rokuti kukosha rinosanganiswawo nematambudziko akakwana, - akadai se #NULL !, #REF !, kana # DIV / 0 !, izvo zvinoratidzwa apo Excel kana Google Spreadsheets inoona matambudziko nemafomu kana data yavanotaura.
Vanonzi vanokosha uye kwete mhosho dzisina kukanganisa sezvavanogona kuverengerwa semafungiro emamwe mapepa emabasa.
Muenzaniso unogona kuonekwa muchitokisi B3 mumufananidzo, nokuti chiyero mune iyo seki chiri kuedza kuparadzanisa nhamba muA2 nevharivha yeA3 isina chinhu.
Sero isina chinhu inorapwa seine kukosha kwe zero pane kuva isina chinhu, saka chigumisiro ndicho chinokanganisa kukosha # DIV / 0 !, sezvo chimiro chiri kuedza kugovana ne zero, chisingagoni kuitwa.
#VALUE! Zvikanganiso
Imwe kukanganisa kukosha kunonyanya kunzi "#VALUE"! uye inowanikwa apo chirevo chinosanganisira zvinotaurwa kumasekine ane marudzi akasiyana-siyana epa data - zvakadai semagwaro uye nhamba.
Kunyanya kunyanya, iko kukanganisa kunoratidzwa apo rondedzero yemafungiro imwechete kana mamwe masero ane zvinyorwa zvemashoko panzvimbo pehuwandu uye fomu iri kuedza kuita basa rekuita arithmetic - kuwedzera, kubvisa, kuwedzera, kana kugovana - kushandisa shanduro imwechete yevashandi: +, -, *, kana /.
Muenzaniso unoratidzwa mumutsara we 4 apo chimiro, = A3 / A4, chiri kuedza kugovana nhamba 10 muchitokisi A3 neshoko Test muA4. Nemhaka yokuti nhamba haigone kugoverwa nemashoko ekunyora, fomu inodzorera #VALUE!
Constant Values
V anonyanya kushandiswawo muExcel neGoogle Spreadsheets neConstant Values , izvo zvinokosha zvinoshanduka zvisinganzwisisiki - zvakadai semutero wekutere - kana kushandura zvachose - zvakadai sePi (3.14).
Nokupa tsika dzakadaro nguva dzose zita rinotsanangurwa - rakadai seRatRate - rinoita kuti zvive nyore kuzvirondedzera mumapapirishiti mafomu.
Kutsanangura mazita mumamiriro ezvinhu akadaro zvichida nyore nyore kuburikidza uchishandisa Bhokisi Razita muExcel kana kuti nekudhonza Dhese> Mazita Mazita ... mune menyu muGoogle Spreadsheets.
Kunyanya Kushandisa Kwekukosha
Mukare, izwi rinokosha rakashandiswa kurondedzera nhamba yenhamba inoshandiswa mumapurogiramu epadheseti.
Kushandiswa uku kwave kwakanyanya kushandiswa nezwi renhamba ye data, kunyange zvazvo zvose Excel neGoogle Spreadsheets dzose dzine VALUE basa. Iri basa rinoshandisa izwi iri mumutauro wayo wepakutanga sezvo chinangwa chebasa chiri kutendesa zvinyorwa zvinyorwa mumatare.