Excel kunye neGoogle Spreadsheet AbaSebenzi bokuThathaniswa abaThathu
Abaqhubi, ngokubanzi, ziimpawu ezisetyenziselwa amafomula ukuchaza uhlobo lokubala oluza kuqhutywa.
Umqhathanisi-mpahla, njengoko igama libonisa, lenza uthelekiso phakathi kweempawu ezimbini kwi-formula kunye nesiphumo saloo mzekeliso sinokuze kube yinyaniso okanye i-FALSE.
AbaThathanisi abathandathu
Njengoko kuboniswe kumfanekiso ongentla, kukho abaqhubi abathandathu abaqhathaniswayo kwii-spreadsheet iinkqubo ezifana ne-Excel kunye ne-Google Spreadsheets.
Aba basebenzisi basebenziselwa uvavanyo kwiimeko ezifana:
- ukulingana kwamanani, njenge-5 = 5,
- ukungalingani kwamanani,
- njenge 4 <> 5 (alingani)
- okanye 5> = 4 (mkhulu kunani okanye alinganayo).
Sebenzisa kwiifomula zeselula
I-Excel iguquguquka kakhulu ngendlela aba basebenzisi bokusetyenziswa. Umzekelo, ungayisebenzisa ukuthelekisa iiseli ezimbini , okanye uqhathanise iziphumo zenye okanye amafomula amaninzi . Umzekelo:
- = A1 = A2
- = A1 = (A2 * 5)
- = (A1 * 10) <= (A2 / 5)
Njengoko le mizekelo ibonisa, ungayibhala ngoku ngqo kwiiselingi kwi-Excel kwaye ube ne-Excel ukubala iifom zefomyula njengoko kuya kuyenza nayiphi na ifom.
Ngale mafomula, i-Excel iya kuhlala ibuyela kwi-TRUE okanye FALSE njengesiphumo kwiseli.
Abaqhubi bemiqathango bangasetyenziselwa kwifomula efanisa ixabiso kwiiseli ezimbini kwiphepha lokusebenzela .
Kwakhona, isiphumo salolu hlobo lwefomula luya kuba yi-TRUE okanye FALSE kuphela.
Umzekelo, ukuba iseli ye-A1 iqulethe inombolo ye-23 kunye ne-A2 yeselkhi iqulethe inombolo ye-32, ifomula = A2> A1 yayiza kubuyisa umphumo weQINISO.
I-formula = A1> A2, ngakolunye uhlangothi, iya kubuya umphumo weFALSE.
Sebenzisa kwiiNgxelo eziMiselo
Abasebenzisi bokuthelekisa basetyenziselwa kwiingxelo ezingqinelanayo, ezifana nomsebenzi we-IF onengqiqo yokuhlola okuchanekileyo ukucacisa ukulingana okanye umahluko phakathi kweempawu ezimbini okanye usebenze.
Uvavanyo olunengqiqo lunokuqhathaniswa phakathi kweenkcazelo ezimbini zeeseli ezifana:
A3> B3Okanye uvavanyo olunengqiqo lunokuthelekiswa phakathi kweseli yeselenki kunye nemali echanekileyo njenge:
C4 <= 100Kwimeko yomsebenzi we-IF, nangona i-argument test argument iqala ukuvavanya ukuthelekisa njengOKWENYANISO okanye OKUQHELEKILEYO, umsebenzi we-IF awuqhelekanga ukubonisa ezi ziphumo kwiiseli zomsebenzi.
Endaweni yoko, ukuba imeko evivinywa yiyinyaniso, umsebenzi uphatha isenzo esibhalwe kwi- Value_if_krue argument .
Ukuba, ngakolunye uhlangothi, imeko evivinywa yi-FALSE, isenzo esibhalwe kwi- Value_if_false argument senziwa endaweni yoko.
Umzekelo:
= IF (A1> 100, "Ngaphezu kwekhulu", "Ikhulu okanye ngaphantsi")Uvavanyo lwengqondo kulo msebenzi we-IF usetyenziselwa ukuchonga ukuba ixabiso eliqulethwe kwi-cell A1 likhulu kunama-100.
Ukuba le meko iyinyaniso (inombolo e-A1 ikhulu kunama-100), umyalezo wokuqala wesicatshulwa Ngaphezu kwekhulu kuboniswa kwiseli apho ifom ehlala khona.
Ukuba le meko i-FALSE (inombolo e-A1 ingaphantsi okanye ilingana no-100), umyalezo wesibini Ikhulu okanye ngaphantsi iboniswa kwiseli equle ifom.
Sebenzisa kwi-Macros
Abasebenzisi bokuthelekisa basetyenziselwa kwiingxelo ezingqinelanayo kwi-Excel macros , ngokukodwa kwizikhonkwane, apho umphumo wokuthelekisa uthatha isigqibo sokuba ngaba kufuneka kwenziwe.