Mu mapulogalamu a spreadsheet monga Excel ndi Google Spreadsheets, malemba angakhale malemba, masiku, manambala, kapena ma Boolean . Potero, mtengo umasiyana malinga ndi mtundu wa deta womwe ukutanthawuza:
- Kwa chiwerengero cha chiwerengero , mtengo umatanthawuza kuchuluka kwa deta - monga 10 kapena 20 m'maselo A2 ndi A3;
- Kwa deta yamakalata, mtengo umatanthawuza mawu kapena chingwe - monga Text mu selo A5 mu worksheet;
- Kwa deta ya Boolean kapena yovomerezeka, mtengo umatanthawuza chikhalidwe cha deta - kaya CHOONA kapena CHOKHALA monga selo A6 mu fano.
Mtengo ukhoza kugwiritsidwanso ntchito pamlingo wa chikhalidwe kapena parameter yomwe iyenera kukumana mu tsamba kuti zotsatira zina zichitike.
Mwachitsanzo, pamene mukusanthula deta, mtengo ndi chikhalidwe chimene deta iyenera kukomana kuti mukhalebe mu tebulo la deta komanso osasankhidwa.
Kuwonetsa Kufunika Vs. Zofunika Zenizeni
Deta yomwe ikuwonetsedwa mu selo lamasewero sangakhale mtengo weniweni womwe amagwiritsidwa ntchito ngati selolo likutchulidwa mu fomu.
Kusiyanasiyana koteroku kumachitika ngati kujambula kumagwiritsidwa ntchito ku maselo omwe amakhudza maonekedwe a deta. Zosintha zojambulazi sizimasintha zenizeni zomwe zasungidwa ndi pulogalamuyi.
Mwachitsanzo, selo la A2 lapangidwira kuti lisasonyeze malo apamwamba pa deta. Zotsatira zake, deta yomwe ili mu selo ndi 20 , osati mtengo weniweni wa 20.154 monga momwe akuwonetsera mu bar .
Chifukwa cha ichi, zotsatira za njirayi mu selo B2 (= A2 / A3) ndi 2.0154 osati 2.
Zolakwitsa Zamalamulo
Mtengo wamtengowu umagwirizananso ndi zolakwika , monga #NULL !, #REF !, kapena # DIV / 0 !, zomwe zikuwonetsedwa pamene Excel kapena Google Spreadsheets amapezera mavuto ndi malemba kapena deta omwe amawatchula.
Iwo amaonedwa kuti ndi amtengo wapatali osati mauthenga olakwika monga momwe angapangidwire monga zifukwa za ntchito zina zapakompyuta.
Chitsanzo chikhoza kuwonedwa mu selo B3 mu fano, chifukwa mawonekedwe mu seloyo akuyesera kugawa chiwerengero cha A2 ndi chopanda kanthu cha A3.
Selo lopanda kanthu likutengedwa ngati lokhala ndi mtengo wa zero m'malo mopanda kanthu, kotero zotsatira zake ndizopanda phindu # DIV / 0 !, popeza momwe chiwerengerochi chikuyesera kugawa ndi zero, zomwe sizingatheke.
#VALUE! Zolakwika
Cholakwika china choyipa kwenikweni chimatchedwa #VALUE! ndipo zimachitika pamene malemba akuphatikizapo maumboni a maselo okhala ndi mitundu yosiyana siyana - malemba ndi manambala.
Zowonjezera, vutoli likuwonetsedwera pamene mafotokozedwe apangidwe amodzi ndi maselo amodzi omwe ali ndi deta m'malo mwa nambala ndipo mayesero akuyesera kuchita masamu a masamu - kuwonjezera, kuchotsa, kuchulukana, kapena kugawa - pogwiritsira ntchito osamalitsa mmodzi: +, -, *, kapena /.
Chitsanzo chikuwonetsedwa mu mzere 4 pamene chiwerengero, = A3 / A4, akuyesera kugawa chiwerengero cha 10 mu selo A3 mwa mawu akuti Test mu A4. Chifukwa chiwerengero sichigawanika ndi deta, ndondomeko imabwerera #VALUE!
Mfundo Zosintha
V choyimira chimagwiritsidwanso ntchito mu Excel ndi Google Spreadsheets ndi Zosintha Zachikhalidwe, zomwe ndizomasintha zomwe zimasintha - monga msonkho - kapena osasintha konse - monga mtengo Pi (3.14).
Pogwiritsa ntchito mayendedwe oterewa, dzina lofotokozera - monga TaxRate - limapangitsa kuti likhale losavuta kuti lizitanthauzire m'mafelemuti.
Kutanthauzira mayina muzochitika zoterozo mosavuta kumagwiritsidwa ntchito pogwiritsa ntchito Dzina la Bokosi ku Excel kapena pakusaka Deta> Zina Zina Zina ... m'ma menus mu Google Spreadsheets.
Kugwiritsa Ntchito Kofunika Kwambiri
M'mbuyomu, mawu ogwiritsira ntchito mawuwa amagwiritsidwa ntchito kutanthauzira deta yamakono yomwe imagwiritsidwa ntchito m'mapulogalamu a spreadsheet.
Ntchitoyi yakhala ikugwiritsidwa ntchito ndi deta ya nambala, ngakhale kuti Excel ndi Google Spreadsheets onse ali ndi VALUE ntchito. Ntchitoyi imagwiritsira ntchito mawuwo m'lingaliro lake loyambirira kuyambira cholinga cha ntchitoyo ndikutembenuza zolembedwera pamasamba.