I-Google Spreadsheet IF Umsebenzi

Ukusebenzisa ifom ye-IF yemisebenzi enengqiqo

Njengomsebenzi we-Excel we-IF, i-Google Spreadsheet IF umsebenzi uvumela ukuba usebenzise izigqibo kwiphepha lokusebenzela. Umsebenzi we-IF ukuvavanya ukuba ngaba imeko ethile inesitheleni yinyani okanye yinyani.

• Ukuba imeko yinyani, umsebenzi uya kuqhuba omnye msebenzi;
• Ukuba loo mqathango ungamanga, umsebenzi uya kwenza umsebenzi ohlukile.

Uvavanyo lokuqala lokwenyaniso okanye lobuxoki, kunye nemisebenzi yokulandelelana, zonke zihleli kunye neziphakamiso zomsebenzi .

Ukongezelela, imisebenzi emininzi ye-IF ingaba yindlunkulu ngaphakathi komnye ukuvavanya iimeko ezininzi kunye nokuqhuba imisebenzi eninzi kuxhomekeke kwisiphumo semvavanyo.

I-IF UMsebenzi kunye ne-Syntax kunye neArguments

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye ibandakanya igama lomsebenzi, iibakaki, abahluli be-comma kunye neengxabano.

I-syntax yomsebenzi we-IF ngu:

= ukuba (ukuvavanya, ngoko-kunene, ngenye indlela_nye)

Iingxoxo ezintathu zintsebenzo zezi:

• vavanyo - (efunekayo) ixabiso okanye ibinzana elivavanywayo ukuze libone ukuba liyinyaniso okanye yinyani;
• ke_yinyaniso - (efunekayo) umsebenzi owenziwa ukuba uvavanyo luyinyaniso;
• ngenye indlela_iyo - (okukhethwa kukho) umsebenzi owenziwa ukuba uvavanyo luyinyani.

Qaphela: Xa ufaka umsebenzi we-IF, iingxoxo ezintathu zihlukaniswe ngama-commas ( , ).

Umzekelo Ukusebenzisa i-Google Spreadsheet IF Usebenza:

Njengoko kuboniswe kumfanekiso ongentla, umsebenzi we-IF usetyenziselwa ukubuyisela iziphumo ezahlukeneyo ezifana:

= ukuba (A2 = 200,1,2)

iboniswe kumqolo 3 womzekelo.

Yintoni lo mzekelo:

• vavanyo ukubona ukuba ixabiso kwi-cell A2 lilingana no- 200.
• Ukuba yenzayo, umsebenzi ubonisa inani 1 kwiseli B3.
• Ukuba i-A1 ingalingani no- 200, umsebenzi ubonisa inani 1 kwiseli B3.

Ukufaka i-IF Function

I-Google Spreadsheets ayisebenzisi ibhokisi yencoko yababini yokufaka iingxoxo zomsebenzi njengoko zifumaneka kwi-Excel. Endaweni yoko, inebhokisi ephakanyiswa yi- auto ephakamisa njengoko igama lomsebenzi lifakwe kwiseli.

Ukufaka i-IF Function & # 39; s Izizathu

1. Cofa kwifowuni B3 ukwenza i- cell esebenzayo- yilapho iziphumo zomsebenzi we-IF ziza kuboniswa.
2. Thayipha uphawu olulinganayo (=) olulandelwe igama lomsebenzi ukuba .
3. Njengoko uthayipha, ibhokisi ephakamisa ngokuzenzekelayo ibonakala ngamagama emisebenzi eqala ngeleta "I".
4. Xa igama IF livela kwibhokisi, nqakraza kuyo ukufaka igama lomsebenzi kunye nokuvula i-parenthesis okanye ibhondi ejikelezayo kwisisele B3.
5. Cofa kwifowuni A2 kwiphepha lokusebenzela ukuze ufake eso saziso seeseli .
6. Emva kwereferensi yeseli, thayipha uphawu olulinganayo (=) olulandelwe inombolo 200 .
7. Faka i- comma ukugqiba impikiswano yokuvavanya .
8. Uhlobo lwesi- 2 olulandelwa yi- comma ukungena kule nombolo njengengxoxo- yeyo .
9. Uhlobo 1 ukungena kule nombolo njengengxabano enye-ye -value - ungangenisi i-comma.
10. Gcwalisa iingxoxo zomsebenzi.
11. Cinezela ukhiye wokungena kwibhodibhodi ukufaka i-parenthesis yokuvala ) nokugqiba umsebenzi.
12. Ixabiso 1 lifanele livele kwiseli A2, kuba ixabiso le-A2 alilingani 200.
13. Ukuba ucofa kwi- cell B3 , umsebenzi opheleleyo = ukuba (A2 = 200,1,2) ibonakale kwibha yefomula ngaphezu kwephepha lokusebenzela .