Indlela Yokuwandisa Izinombolo kuma-Spreadsheets we-Google

Indlela elula yokwandisa izinombolo ezimbili kuma-Google Amaspredishithi ukwakha ifomula kuseli lokusebenzela.

Amaphuzu abalulekile okumele akhumbule mayelana namafomula we-Google Spreadsheet:

• Amafomu aqala ngaso sonke isibonakaliso esilinganayo ( = );
• uphawu olulinganayo luya njalo esitokisini lapho ufuna khona impendulo;
• umqhubi wokuphindaphinda i-asterisk ( * );
• Ifomula igcwaliswe ngokucindezela ukhiye wokungena kwikhibhodi.

01 ka-06

Ukusebenzisa Ukubhekisela Kwezingqimba Ngamafomula

Ngisho noma kungena izinombolo ngqo kwifomula, njenge:

= 20 * 10

isebenza - njengoba kuboniswe emgqeni amabili kusibonelo - akuyona indlela engcono yokudala amafomula.

Indlela engcono kakhulu - njengoba kuboniswe emigqeni emihlanu nesithupha - yilezi:

1. Faka izinombolo ukuthi zande zibe ngamaseli ephepha lokusebenzela elihlukile;
2. Faka izingqikithi zeseli kulawo maseli aqukethe idatha kumfomula wokuphindaphinda.

Izinkomba zeselula ziyinhlanganisela yombhalo wekholomu oqondile nenombolo yomugqa oqondile nencwadi yekholomu njalo ebhaliwe kuqala - njenge-A1, D65, noma i-Z987.

02 ka 06

Izinzuzo ze-Cell Reference

Izikhombisi zeselula zisetshenziselwa ukukhomba indawo yedatha esetshenziswe kwifomula. Uhlelo lufunda izingcaphuno zeseli bese luxhuma idatha kulawo maseli endaweni efanele kule formula.

Ngokusebenzisa izingqikithi zeseli kunokuba idatha yangempela kwifomula - kamuva, uma kubalulekile ukushintsha idatha , kuyindaba elula yokufaka idatha kumaseli esikhundleni sokuphinda ubhale kabusha ifomula.

Ngokujwayelekile, imiphumela yefomula izobuyekeza ngokuzenzekelayo uma idatha ishintsha.

03 ka 06

I-Formula Yokuphindaphinda Isibonelo

Njengoba kuboniswe esithombeni esingenhla, lesi sibonelo sidala ifomula ku-cell C4 ezokwandisa idatha ku-cell A4 ngemininingwane ku-A5.

Ifomu eliqediwe kuseli C4 lizoba:

= A4 * A5

04 ka 06

Ukufaka iFomula

1. Chofoza kumakhalekhukhwini C4 ukuze wenze iselula esebenzayo - yilapho imiphumela yefomula izoboniswa khona;
2. Thayipha uphawu olulinganayo ( = ) esitokisini C4;
3. Chofoza kuseli le-A4 nge-pointer yegundane ukufaka lelo referensi yeseli kufomula;
4. Thayipha uphawu lwe- asterisk ( * ) emva kwe-A4;
5. Chofoza kuseli ye-A5 nge-pointer yegundane ukuze ufake leyo reference reference;
6. Cindezela ukhiye wokungena kwikhibhodi ukuqedela ifomula;
7. Impendulo 200 kufanele ibe khona esitokisini C4;
8. Ngisho noma impendulo iboniswa esitokisini C4, ukuchofoza kulelo seli kuzobonisa ifomu langempela = A4 * A5 ebhawulweni yefomula ngaphezulu kwephepha lokusebenzela.

05 ka 06

Ukushintsha idatha yefomula

Ukuhlola ukubaluleka kokusebenzisa izingqikithi zeseli kwifomula:

• Shintsha inombolo yakhe esitokisini A4 kusuka ku-20 t o-5 bese ucindezela ukhiye wokungena kwikhibhodi.

Impendulo kuseli C4 kufanele ivuselelwe ngokuzenzakalelayo ibe ngu-50 ukukhombisa ushintsho kwedatha kuseli A4.

06 ka-06

Ukushintsha ifomu

Uma kudingekile ukulungisa noma ukushintsha ifomula, izinketho ezimbili ezinhle kakhulu ziyi:

• Chofoza kabili ifomula ekhasini lokusebenzela ukuze ubeke i-Google Spreadsheets ku- Hlela imodi bese wenza izinguquko kwifomula - isebenza kangcono izinguquko ezincane.
• Chofoza kanye esitokisini esinefomula bese ubhala kabusha yonke ifomula - engcono kakhulu ushintsho olukhulu.