Indlela yokususa ku-Google Spreadsheets

Sebenzisa amafomu ama-Google Spreadsheet ukususa izinombolo ezimbili noma ngaphezulu

01 ngo-02

Ukusebenzisa ifomula ukukhipha izinombolo ku-Google Spreadsheets

Ukuze ususe izinombolo ezimbili noma ngaphezulu kuma-Google Amaspredishithi, udinga ukwakha ifomula .

Amaphuzu abalulekile okumele akhumbule mayelana namafomula we-Google Spreadsheet:

• Amafomu kuma-Google Spreadsheets aqala njalo ngesibonakaliso esifanayo ( = ).
• Uphawu olulinganayo lufakwe njalo esitokisini lapho ufuna impendulo ivele khona.
• Uphawu lokukhipha ku-Google Spreadsheets yidash (-).
• Ifomula igcwaliswe ngokucindezela ukhiye wokungena kwikhibhodi noma ngokuhambisa ukugqamisa kweseli kwelinye iseli ngezimpawu zegundane noma umcibisholo ekhibhodi.

Ukubona Impendulo, Akuyona Imfomu

Uma usungenwe esitokisini seshidi, impendulo noma imiphumela yefomula iboniswa esitokisini kunokuba ifomula ngokwayo.

Ukubona ifomula, hhayi impendulo

Kunezindlela ezimbili ezilula zokubuka ifomula ngemuva kokungena:

1. Chofoza kanye nge-pointer yegundane kuseli eliqukethe impendulo - ifomula iboniswa kubha yamasombulu ngaphezu kwephepha lokusebenzela.
2. Chofoza kabili kuseli eliqukethe ifomula - lokhu kufaka uhlelo kumodi yokuhlela futhi ikuvumela ukuthi ubone futhi ushintshe ifomula esitokisini ngokwaso.

02 ka 02

Ukuthuthukisa i-Formula eyisisekelo

Ngisho noma ukufaka izinamba ngqo kwifomula, njenge- = 20 - 10 isebenza, akuyona indlela engcono kakhulu yokudala amafomula.

Indlela engcono kakhulu uku:

1. Faka izinombolo ukuze zisuswe kumaseli wephepha lokusebenzela elihlukile;
2. Faka izinkomba zeseli kulawo maseli aqukethe idatha kumfomula wokukhipha.

Ukusebenzisa Ukubhekisela Kwezingqimba Ngamafomula

I-Google Spreadsheets inezinkulungwane zamaseli kuphepha lokusebenzela elilodwa. Ukugcina ithrekhi yawo wonke umuntu unekheli noma ireferensi esetshenziselwa ukukhomba indawo yeseli kuphepha lokusebenzela.

Lezi zikhombisi zeseli ziyingxenye yombhalo okhomayo oqondile nenombolo yomugqa oqondile nencwadi yekholomu njalo ebhaliwe kuqala - njenge-A1, D65, noma i-Z987.

Lezi zikhombisi zeseli zingasetshenziswa futhi ukukhomba indawo yedatha esetshenziswe kwifomula. Uhlelo lufunda izingcaphuno zeseli bese luxhuma idatha kulawo maseli endaweni efanele kule formula.

Ngaphezu kwalokho, ukuvuselela idatha esitokisini ekhonjisiwe kumphumela wefomula kwimpendulo yefomula ngokuzenzakalelayo ibuyekezwa kanye.

Ukukhomba kuDatha

Ngaphezu kokuthayipha, usebenzisa iphuzu bese uqhafaza (ngokuchofoza inkinobho yegundane) kumaseli aqukethe idatha ingasetshenziswa ukufaka izingqikithi zeseli ezisetshenziswe kumafomula.

Iphuzu futhi uchofoze kunenzuzo yokunciphisa amaphutha abangelwa amaphutha wokuthayipha lapho ufaka izingqikithi zeseli.

Isibonelo: Susa Amanani Abili Usebenzisa Ifomula

Izinyathelo ezingezansi zihlanganisa indlela yokudala ifomula yokukhipha ekhona esitokisini C3 esithombeni ngenhla.

Ukufaka iFomula

Ukukhipha 10 kusuka ku-20 bese uphendula impendulo ku-cell C3:

1. Chofoza kuseli C3 nge-pointer yegundane ukuze wenze iseli elisebenzayo ;
2. Thayipha uphawu olulinganayo ( = ) esitokisini C3;
3. Chofoza ku- cell A3 nge-pointer yegundane ukwengeza ukuthi ireferensi yeseli kwifomu ngemuva kwesibonakaliso esifanayo;
4. Thayipha uphawu lokususa ( - ) olulandelayo inkomba ye-cell A1;
5. Chofoza kuseli B3 ngesininathisi segundane ukwengeza ukuthi ireferensi yeseli kwifomula ngemuva kwesignali encane;
6. Cindezela ukhiye wokungena kwikhibhodi
7. Impendulo 10 kufanele ibe khona esitokisini C3
8. Ukuze ubone ifomula, chofoza ku- cell C3 futhi, ifomula iboniswa kubha yefomula ngaphezulu kwephepha lokusebenzela

Ukushintsha Imiphumela ye-Formula

1. Ukuze uhlole ukubaluleka kokusebenzisa izingqikithi zeseli kwifomula, shintsha inombolo ku-cell B3 kusuka ku-10 ukuya ku-5 bese ucindezela ukhiye we- Enter kwikhibhodi.
2. Impendulo ku-cell C3 kufanele ibuyekeze ngokuzenzakalelayo ku-15 ukukhombisa ushintsho kwedatha.

Ukwandisa ifomula

Ukwandisa ifomula ukufaka imisebenzi eyengeziwe - njengokungeza, ukubuyabuyelela, noma ukwahlukana okuningi okukhonjisiwe emigqeni ezine nokuyisihlanu esibonelweni - qhubeka nje wengeze umsebenzisi ohambelana nezibalo olandelwa yereferensi yeseli equkethe idatha.

I-Google Spreadsheets Order of Operations

Ngaphambi kokuxuba imisebenzi ehlukene yezibalo, qiniseka ukuthi uyaqonda ukulandelana kwemisebenzi i-Google Spreadsheets elandela lapho ihlola ifomula.