Ndingayisebenzisa njani iifomula eziphambili kwi-Excel, ezifana ne-IF kunye ne-AND?

Iifomula eziphezulu kwi-Excel Bavumela abasebenzisi ukuba benze izibalo ezinzima kwaye benze izigqibo ezinengqiqo ngokusekelwe kwiimeko ezithile. Enye yeyona misebenzi inamandla kwaye isetyenziswa ngokubanzi kwi-Excel ngumsebenzi we-IF, okuvumela ukuba wenze uvavanyo olunengqiqo kwaye ubuyisele umphumo ngokusekelwe kwimeko. Omnye umsebenzi obalulekileyo ngu AND (AND), evumela uvandlakanyo olunengqiqo lweemeko ezininzi ngaxeshanye. Kweli nqaku, siza kuphonononga indlela yokusebenzisa ezi fomula eziphambili kwi-Excel kunye nendlela yokwenza uninzi lwazo ukwenza lula ukusetyenzwa kwedatha kunye nokuphucula ukusebenza kakuhle kulawulo lolwazi.

I-IF ⁢(IF) umsebenzi kwi-Excel sisixhobo esinamandla esikuvumela ukuba wenze uphononongo olunengqiqo kwaye wenze izigqibo ezisekelwe kwimeko. Lo ⁢umsebenzi uqhele ukusetyenziswa ukubuyisela iziphumo ezohlukeneyo ⁤ ngokuxhomekeke ekubeni imeko ethile ifezekisiwe okanye hayi.⁤ Ngomsebenzi we-IF, abasebenzisi bangenza imisebenzi kwaye benze lula ukusetyenzwa kwedatha ngokuchaza imeko kunye ⁢nokuchaza ukuba leliphi inyathelo ekufuneka lithathwe. yenza i-Excel ngokusekelwe kwisiphumo solo vandlakanyo.

Umsebenzi⁢ KUNYE (KUNYE) kwi-Excel sisixhobo esiluncedo sokwenza uvandlakanyo olunengqiqo lweemeko ezininzi. Ngeli nqaku, abasebenzisi banokujonga ukuba zonke iimeko ezichaziweyo zifezekisiwe okanye hayi. I AND umsebenzi ubuyisela ixabiso TRUE ukuba zonke iimeko ziyinyani, kunye nexabiso FALSE ukuba ubuncinane enye yeemeko bubuxoki. Lo msebenzi uvumela abasebenzisi ukuba benze izibalo ezixhomekeke ekwanelisekeni kweemeko ezininzi xa ngaxeshanye, ukonga ixesha kunye nomzamo wokulawula idatha entsonkothileyo.

Kweli nqaku, siza kufunda indlela yokusebenzisa ezi fomula ziphambili kwi⁤ Excel ye ngempumelelo. Siza kubona imizekelo ebonakalayo yendlela yokusebenzisa i-IF kunye ne-AND nemisebenzi kwiimeko ezahlukeneyo kunye nendlela yokudibanisa kunye nezinye iifomyula ze-Excel kunye nemisebenzi ukufumana iziphumo ezichaneke ngakumbi kunye nezomntu. Ukongeza, siza kuhlolisisa ezinye iingcebiso namaqhinga ukuphepha iimpazamo eziqhelekileyo xa usebenzisa ezi fomula kunye nendlela yokusombulula iingxaki eziqhelekileyo ezinokuvela ngexesha⁢ lokuphunyezwa kwazo. Ngokwazi ezi ⁤ iifomyula eziphambili, uya kukwazi lungisa iinkqubo zakho zokusebenza kwaye wenze uhlalutyo oluntsonkothileyo kwi-Excel.

-Intshayelelo kwiifomyula eziphambili kwi-Excel

Iifomula kwi-Excel zizixhobo ezisisiseko zokwenza izibalo kunye nohlalutyo lwedatha ngokufanelekileyo kwaye ichanekile. Nangona kunjalo, kukho iifomula eziphambili ezikuvumela ukuba wenze imisebenzi entsonkothileyo kwaye uzenzele imisebenzi kwi-Excel. Kule posi, ndiza kukwazisa kwihlabathi leefomyula eziphambili kwi-Excel, ndigxile ngakumbi kwi-IF kunye neefomyula.

Ifomula ye-IF⁢ kwi-Excel Yenye yeefomyula ezisetyenziswa kakhulu emhlabeni ishishini, kuba livumela uvandlakanyo olunengqiqo nolunemiqathango ukuba lwenziwe⁣ukuthatha izigqibo okanye ukwenza iintshukumo ezithile. Le fomyula isekelwe kwingxelo enemiqathango: ukuba imeko iyinyani, isenzo siyenziwa; ukuba imeko ibubuxoki, elinye inyathelo liyenziwa. Isivakalisi esisisiseko sefomula ye-IF imi ngolu hlobo lulandelayo:

=IF(imeko, isenzo ukuba yinyaniso, isenzo ukuba asiyonyani)

Ifomula kunye ne-Excel yenye ifomyula eluncedo kakhulu evumela iimeko ezininzi ukuba zivavanywe ngaxeshanye. Le fomula ibuyisela TRUE ukuba zonke iimeko ezikhankanyiweyo ziyinyani, kwaye FALSE ukuba ubuncinane omnye wemiqathango ayiyonyani. Iluncedo ngakumbi xa ufuna ukujonga iindlela ezininzi ngaphambi kokwenza isenzo okanye ukwenza isigqibo. I-syntax esisiseko ye-AND yefomyula yile ilandelayo:

=AND(imeko1, imeko2, ...)

Ngamafutshane, iifomula eziphucukileyo ⁢ezifana no-IF kunye KUNYE ne-Excel zikuvumela ukuba wenze uqikelelo oluntsonkothileyo⁤ kunye novavanyo olunemiqathango, imisebenzi ezenzekelayo kunye nokwenza izigqibo ezisekelwe kwiikhrayitheriya ezininzi. Ukuba nobuchule kwezi fomyula kuya kuvula ihlabathi lamathuba kulawulo lwe idatha kwi-excel, kukugcinela ixesha kwaye ikunike iziphumo ezichaneke ngakumbi. Ke ungathandabuzi ukuphonononga kunye nokulinga ngezi zixhobo zinamandla kwiprojekthi yakho elandelayo yohlalutyo lwedatha ye-Excel!

– Ukusebenzisa ifomula ye-IF ukwenza izigqibo kwi-Excel

Ifomula ye-IF sisixhobo esiluncedo kwi-Excel ekuvumela ukuba wenze izigqibo kwaye uthathe amanyathelo ngokusekelwe kwimeko ethile. Nge-IF, kunokwenzeka ukuvavanya imeko okanye umgaqo kwaye unqume ukuba yinyani okanye ayiyonyani, kwaye ngokusekelwe kuloo nto, yenza isenzo esithile. Umzekelo, ukuba ufuna ukubala ⁤ibhonasi yomqeshwa ngokusekwe kwindlela asebenza ngayo, ungasebenzisa u-IF ukubona ukuba bayahlangabezana neenqobo ezithile kwaye banike ixabiso ngokufanelekileyo.

Ukusebenzisa ifomula ye-IF kwi-Excel, kufuneka ulandele ulwakhiwo olulandelayo: =IF(imeko, ixabiso lokwenyani, ixabiso elingeyonyani). Umqathango unokuba luthelekiso lwamaxabiso, umsebenzi osengqiqweni ofana no- AND okanye OR, okanye nayiphi na intetho evavanya ukuba yinyani okanye bubuxoki. Ixabiso lokwenyani sisiphumo okanye isenzo esiya kwenziwa ukuba imeko iyinyani, ngelixa ixabiso lobuxoki lisiphumo okanye isenzo esiya kwenziwa ukuba imeko ibubuxoki. Kubalulekile ukukhumbula ukuba zombini ixabiso lokwenene kunye nexabiso lobuxoki linokuba nayiphi na idatha esebenzayo okanye ifomula kwi-Excel.

Ukongeza kwifomula ye-IF, unokuphinda uyidibanise neminye imisebenzi ephezulu ye-Excel efana ne- AND okanye OR ukudala iimeko ezinzima ngakumbi. Umzekelo,​ ukuba ufuna ukuvavanya iimeko ezimbini ⁢ngexesha elinye⁤ phambi kokuba wenze isigqibo, ⁤ungasebenzisa i-AND umsebenzi ngaphakathi kwefomula ye-IF. Oku kuya kukuvumela ukuba wenze intshukumo kuphela ukuba yomibini imiqathango ifezekisiwe Ngokufanayo, i OR umsebenzi ikuvumela ukuba wenze intshukumo ukuba ubuncinane omnye weemeko ezikhankanyiweyo yinyaniso. Ngokudibanisa ezi mpawu, unokwenza iifomyula ezinamandla ngakumbi neziguquguqukayo ezihambelana neemfuno zakho ezithile.

-Uyisebenzisa njani i-AND umsebenzi ukwenza iitshekhi ezininzi kwi-Excel

Uyisebenzisa njani i-AND umsebenzi ukwenza iitshekhi ezininzi kwi-Excel

Inyathelo lesi-1: Ivuliwe IMicrosoft Excel kwaye ukhethe i-spreadsheet ofuna ukuqhuba iitshekhi kuso. Khumbula ukuba i-AND umsebenzi usivumela ukuba sivavanye iimeko ezininzi ngaxeshanye. Inokuba luncedo kwiimeko apho ufuna ukujonga ukuba iimeko ezininzi zihlangatyeziwe na phambi kokwenza isenzo esithile⁤. Umzekelo, masithi⁤ unedatha⁤ kubasebenzi benkampani kwaye ⁤ufuna ukufumana abo banomvuzo ongaphezulu kwe-$50,000 kunye neminyaka eyi-5 yamava. Umsebenzi AND⁢ uzakukuvumela ukuba wenze ⁢oku kuqinisekisa ukukhangela. indlela esebenzayo.

Inyathelo lesi-2: Kwiseli engenanto, chwetheza ifomula oza kuyisebenzisa ukwenza itshekhi. Kule meko, siya kusebenzisa i-Excel KUNYE nomsebenzi. Isivakalisi jikelele somsebenzi ngu =AND(condition1, condition2, …). Ungangenisa iimeko ezininzi kangangoko ufuna, uzahlule ngeekoma. Umzekelo, ukuqinisekisa ukuba umvuzo womqeshwa mkhulu kune-$50,000 kwaye amava abo makhulu kuneminyaka emi-5, ifomula iya kuba yinto enje: =AND(C2>50000, D2>5). Khumbula ukutshintsha iireferensi zeseli⁤ ngokufanelekileyo kwiseti yedatha yakho. Xa ucofa u-Enter, ifomula iya kuvavanya iimeko kwaye ibuyisele TRUE ukuba zonke zihlangatyeziwe kwaye FALSE ukuba kukho okanye zonke azihlangabezwanga.

Inyathelo lesi-3: Ngoku ekubeni unefomula emiselweyo, ungayitsalela ezantsi ukuze uyisebenzise kuyo yonke imigca eseti yedatha yakho. Oku kuya kukunika ikholamu eyongezelelweyo ebonisa ukuba ngaba umsebenzi ngamnye uhlangabezana nazo zombini iimeko. Ukuba ufuna ukubala ukuba bangaphi abasebenzi abahlangabezana neemeko zombini, ungasebenzisa umsebenzi we-Excel we-COUNTIF kwikholamu yeziphumo zefomula. Umzekelo, ukuba iziphumo zefomyula zikukholam E, ungasebenzisa ifomula ‌=COUNTIF(E:E, "TRUE") ukufumana ⁤inani labasebenzi abahlangabezana nazo zombini ezi meko.

-⁢ Imizekelo esebenzayo yendlela yokusebenzisa ifomula ye-IF kudityaniswe nemisebenzi ephezulu

I-Excel IF Formula Sisixhobo esinamandla esivumela ukuba senze uvandlakanyo olunengqiqo kwaye senze izigqibo ezisekelwe kwisiphumo. Nangona kunjalo, xa zidityanisiwe nezinye iimpawu eziphambili, ezinje ngo-AND, sinokufikelela nangakumbi. Umzekelo, ukuba sifuna ukujonga ukuba iimeko ezininzi zihlangatyeziwe ngaxeshanye, sinokusebenzisa u-IF umsebenzi ngokudityaniswa no- AND umsebenzi ukufumana iziphumo ezichane ngakumbi nezicacileyo.

Masithi sinespreadsheet esinedatha yokuthengisa. kwaye sifuna ukuhlela iimveliso ngokusekelwe ekusebenzeni kwazo. Ukwenza oku, sinokusebenzisa ifomula ye-IF ngokudibeneyo kunye nomsebenzi kunye nokuseka iindlela ezahlukeneyo zokuhlela. Ngokomzekelo, sinokwenza ifomula ebeka imveliso ⁤ "Phakamileyo" ukuba ubungakanani bayo bokuthengisa bukhulu kune-1000, ixabiso layo likhulu kune-$ 50, kwaye umda wayo wenzuzo mkhulu kune-20%. Singasebenzisa ⁢AND umsebenzi ukuvavanya le miqathango mithathu kunye nefomula ye-IF ukwabela iziphumo ezihambelanayo.

Omnye umzekelo osebenzayo wendlela yokudibanisa ifomula ye-IF kunye nemisebenzi ephezulu kuxa kufuneka senze izibalo ezinemiqathango ezisekelwe ku-a uluhlu lwamaxabiso ethile. Umzekelo, masithi sinoluhlu lweemveliso kwaye kufuneka sibale isixa seentengiso kuphela kwiimveliso ezihlangabezana nemilinganiselo ethile. Singasebenzisa umsebenzi we-IF ngokudibeneyo nomsebenzi we-SUMIFS ukwenza olubalo ngokufanelekileyo. Ngale ndlela, sinokwenza izibalo zethu kwi-Excel kwaye sifumane iziphumo ezichanekileyo nezifanelekileyo kuhlalutyo lwethu lwedatha. Ngezi zixhobo zihambele phambili, okunokwenzeka akunasiphelo ukusebenzisa ngokupheleleyo izakhono ze-Excel kunye nokwenza uhlalutyo oluntsonkothileyo noluneenkcukacha.

-Iingcebiso zokwandisa ukusetyenziswa kweefomyula eziphambili kwi-Excel

Kwi-Excel, iifomula eziphambili Ziyisixhobo esinamandla sokwenza izibalo ezinzima kunye nemisebenzi ezenzekelayo. Ezimbini zezona fomyula zisetyenziswa kakhulu zezi IF y Kwaye, ezinokudityaniswa ukufumana iziphumo ezichane ngakumbi. Ifomula IF ⁤ ikuvumela ukuba uvavanye imeko kwaye uthathe amanyathelo asekelwe kwisiphumo, ngelixa ifomula Kwaye isetyenziselwa ukuvavanya iimeko ezininzi zombini.

Xa usebenzisa ifomula IF, khumbula ukuba kufuneka ihlale ilandelwa yimeko kunye yezabelo eya kwenza ukuba imeko iyinyani okanye ayiyonyani. Umzekelo, ungasebenzisa ifomula IF ukubonisa "Dlulisa" umyalezo ukuba ⁢ibanga⁤ likhulu kuno okanye lilingana no ⁣70, kwaye "Ayiphumelelanga" ngenye indlela. Ngapha koko, ifomula Kwaye Ikuvumela ukuba udibanise iimeko ezimbini okanye ngaphezulu ezinengqiqo ngokusebenzisa abaqhubi abanengqondo abafana no-"kunye" okanye "&". Umzekelo, ungasebenzisa Kwaye ukujonga ukuba iimeko ezimbini ziyinyani ngexesha elinye, njengokuba amanqaku makhulu okanye alingana no-70 y ukuba umfundi uye ubuncinane 80% iiklasi.

Ukwenza uninzi lwezi fomula, ndincoma ukulandela oku kulandelayo iingcebiso:

• Gcina iifomula IF kwaye Kwaye ilula kangangoko ukwenza lula ukuqonda nokuphepha iimpazamo.
• Sebenzisa umsebenzi Ifakwe IF ukwenza uphononongo oluninzi kwifomula enye⁢IF.
• Sebenzisa izibiyeli ukwenza iqela iimeko kunye nabasebenzisi abanengqondo ngaphakathi kwefomula, ngaloo ndlela uqinisekisa ulandelelwano oluchanekileyo lovandlakanyo.
• Sebenzisa iireferensi zeeseli endaweni yamaxabiso angatshintshiyo ngaphakathi kweefomyula, ukuze ukwazi ukuhlaziya idatha ngokulula ngaphandle kokuguqula ifomula.
• Soloko ujonga iziphumo zefomula yakho ngokuchasene nedatha yovavanyo eyaziwayo ukuqinisekisa ukuba zibonelela ngeziphumo ezilindelekileyo.

-Ungenza njani indlwane ye-IF kunye KUNYE neefomula zokwenza uvavanyo oluntsonkothileyo kwi-Excel

I-IF kunye ne-AND iifomyula zimbini yeyona misebenzi iluncedo kwaye inamandla kwi-Excel. Ngabo, unokwenza uvavanyo olunzima kwaye wenze izigqibo ezinemiqathango kwiispredishithi zakho. Ukwakha le misebenzi mibini kuya kukuvumela ukuba udibanise iimeko ezahlukeneyo kwaye ufumane iziphumo ezichanekileyo. ⁢ I-Nesting IF kunye KUNYE neefomula ziya kukuvumela ukuba wenze uphononongo oluninzi noluntsokothileyo kwi-Excel, ukongela ixesha kunye nomzamo.

Xa ugcina ifomula ye-IF ngaphakathi kwe-KUNYE nomsebenzi, udala amanqanaba amaninzi ovavanyo olunemiqathango mayizaliseke imeko ⁤ichaziwe kumsebenzi we-IF. ⁤ Ngokugcina ezi fomyula, unokwenza uphononongo oluchanekileyo noluneenkcukacha kwi-Excel, uhlengahlengiso iifomyula zakho kwiimeko ezithile.

Ukwenza indlwane IF kunye AND iifomyula kwi-Excel, kuyimfuneko ukulandela isakhiwo esithile. Okokuqala, kufuneka usete i-AND umsebenzi kwaye unikeze zonke iimeko ofuna ukuzivavanya. Emva koko, ngaphakathi komsebenzi we-IF, ubeka imeko⁤ eya kuthi⁢ ifezekiswe ukuba zonke iimeko ezingaphakathi kwi-AND umsebenzi ziyinyani. Khumbula ukusebenzisa ⁢ababiki ngokuchanekileyo kwaye ujonge isintaksi ⁤yeefomula ⁢zakho ukufumana iziphumo ezichanekileyo. Ngobu buchule, uya kuba nakho ukwenza uvandlakanyo oluntsonkothileyo nolwenzelwe wena⁤ kwi-Excel, uthatha inzuzo epheleleyo kuyo yonke imisebenzi enikezelwa sesi sixhobo sinamandla sespredishithi.

-Izisombululo kwimicelimngeni eqhelekileyo xa usebenzisa iifomyula eziphezulu kwi-Excel

Izisombululo kwimingeni eqhelekileyo xa usebenzisa iifomyula eziphambili kwi-Excel

Xa kuziwa ekusebenziseni iifomyula eziphambili kwi-Excel, ezifana ne-IF kunye ne-AND, inani lemingeni inokuvela enokwenza kube nzima ukusebenzisa ngokuchanekileyo. Nangona kunjalo, kukho izisombululo ezinokukunceda ukuba woyise le miqobo kwaye ukwandise ukusebenza kwe-spreadsheets zakho. Apha ngezantsi kukho izisombululo ezisebenzayo kwimingeni eqhelekileyo xa usebenzisa iifomula eziphambili kwi-Excel:

1. Ucelomngeni: Ukufunxa ezininzi IF kunye KUNYE neengxelo kwifomula
Ngamanye amaxesha, kuyimfuneko ukwenza izibalo ezinemiqathango ezinzima ezifuna ukusetyenziswa kweengxelo ezininzi ze-IF kunye ne-AND. Ukusingatha le meko, kuyacetyiswa yahlula ifomula ibe ngamacandelo amancinci. Ungasebenzisa iikholamu ezongezelelweyo ukubala imeko nganye ngokwahlukileyo uze udibanise iziphumo usebenzisa ifomyula ephambili. Oku kwenza ukuba ifomula ifundeke ngakumbi kwaye kulula ukuyigcina.

2. Umngeni: Iziphumo ezingalunganga ngenxa yeempazamo zereferensi⁤
Ukusebenzisa iifomula ezikumgangatho ophezulu, ezifana no-IF kunye no-AND, kunokukhokelela kwiziphumo ezingalunganga ngenxa yeempazamo zereferensi. Esinye isisombululo kulo mngeni si jonga kwaye ulungise izingqinisiso kwifomula yakho Qinisekisa⁢ ukuba iimbekiselo zalatha kwiiseli ezichanekileyo kwaye akukho seli zingenanto okanye izinto zangaphandle ezichaphazela ubalo. Ukongeza, ungasebenzisa i-IFERROR⁣ umsebenzi ukubamba kunye nokusingatha iimpazamo ngokufanelekileyo.

3. Umngeni: Iifomula ezinde ekunzima ukuzilandela
Xa usebenza ngeefomula eziphambili, usenokudibana neefomula ezinde kwaye kunzima ukuzilandela. Enye indlela yokuhlangabezana nalo mngeni phawula kwaye ubhale iifomula zakho. Unokongeza amagqabantshintshi usebenzisa isimboli sesimeli-mbumbulu (') ekuqaleni komgca ngamnye wefomula ukuchaza injongo yayo kunye nezibalo ezenziwe kwinyathelo ngalinye. Ungasebenzisa kwakhona ikhefu lomgca kunye ne-whitespace ukwenza ifomula ifundeke ngakumbi.

Ngamafutshane, ukusebenzisa iifomyula eziphambili kwi-Excel kunokuba ngumngeni, kodwa kunye nezisombululo ezifanelekileyo, unokoyisa nawuphi na umqobo. Ukwahlula iifomula zibe ngamacandelo amancinci, ukulungisa iimpazamo zereferensi, kunye nokubhala iifomyula zakho zezinye izisombululo ezisebenzayo eziza kukunceda usebenzise iifomyula eziphambili ngokufanelekileyo. Khumbula ukuziqhelanisa kwaye ulinge ngeemeko ezahlukeneyo ukuze uziqhelanise nezinto ezinokwenzeka ukuba iifomyula ezikwi-Excel zibonelela.

-Uziphepha njani iimpazamo eziqhelekileyo xa usebenza nge-IF kunye neefomula kunye ne-Excel

Ungaziphepha njani iimpazamo eziqhelekileyo xa usebenza nge-IF kunye NAYE iifomyula kwi-Excel

Kwi-Excel, iifomyula eziphambili ezifana no-IF kunye no-AND zinokukunika amandla amakhulu okwenza izibalo ezintsonkothileyo, ezinengqiqo kwi-spreadsheets zakho. Nangona kunjalo, ngamanye amaxesha kunokuba nzima kwaye kwenzeke iimpazamo ukuba awuzithatheli ngqalelo iinkcukacha ezibalulekileyo. Okulandelayo, siza kukubonisa ukuba ungaziphepha njani iimpazamo eziqhelekileyo xa usebenza ngezi fomula.

1. Sebenzisa ⁢IF ifomula yesivakalisi ngokuchanekileyo: Ifomula ye-IF, eyaziwa ngokuba yi-SI ngeSpanish, isetyenziswa ngokubanzi ukwenza uthelekiso kunye neemeko kwi-Excel. Ukunqanda iimpazamo, qiniseka ukuba ulandela isivakalisi esichanekileyo: ⁣=IF(condition, value_if_true, value_if_false). Impazamo eqhelekileyo⁢‌ kukulibala ukuvala izibiyeli ngokuchanekileyo okanye ukungafaki izicaphulo xa kuyimfuneko. Khumbula ukuba imeko ⁤kufuneka ibeyintetho enengqiqo ebuyisela TRUE⁤ okanye FALSE.

2. Sebenzisa i-AND ngokuchanekileyo: Umsebenzisi AND, owaziwa ngokuba KUNYE ngeSpanish, isetyenziselwa ukudibanisa iimeko ezininzi kwifomula enye. Ukunqanda iimpazamo, kubalulekile ukukhumbula ukuba kufuneka⁢ wahlule imeko nganye ngesiphumlisi. Umzekelo, =IF(AND(condition1, condition2),⁤ value_if_true, value_if_false). Ukongeza, kufuneka uqinisekise ukuba imeko nganye yintetho enengqiqo ebuyisela TRUE okanye FALSE.

3. Sebenzisa iimbekiselo ezipheleleyo xa usebenza ngoluhlu: Xa usebenzisa i-IF kunye ne-AND iifomyula kuluhlu lweeseli, kubalulekile ukusebenzisa iireferensi ezipheleleyo ukuphepha iimpazamo zokulinganisa xa ukhuphela okanye uhambisa ifomula. Ukwenza oku, yongeza ngokulula uphawu lwedola ($) phambi koonobumba bekholamu kunye namanani omqolo kwiireferensi zeeseli. Umzekelo, =$A$1:$B$10. Oku kuya kuqinisekisa ukuba ifomula isoloko ibhekisa kuluhlu olufanayo, kungakhathaliseki ukuba ikotshwa okanye isiwe phi.

Isishwankathelo, xa usebenza nge-IF kunye neefomyula kwi-Excel, kubalulekile ukuqinisekisa ukuba usebenzisa i-syntax yefomula ngokuchanekileyo, sebenzisa i-AND operator ngokufanelekileyo, kwaye usebenzise iimbekiselo ezipheleleyo xa usebenza ngoluhlu lweeseli ezilandelayo la macebiso, uya kukwazi ukuphepha iimpazamo eziqhelekileyo kwaye usebenzise ngokupheleleyo amandla ezi fomula eziphambili kwi-spreadsheets zakho. ...