I-Google Spreadsheet IF Umsebenzi

Ukusebenzisa ifomu le-IF lemisebenzi enengqondo

Njengomsebenzi we-Excel ka-IF, umsebenzi we-Google Spreadsheet IF uvumela ukuthi usebenzise izinqumo kushidi lokusebenzela. Umsebenzi we-IF uvivinya ukuze ubone ukuthi isimo esithile esitokisini siyiqiniso noma singamanga.

• Uma isimo siyiqiniso, lo msebenzi uzokwenza umsebenzi owodwa;
• Uma isimo singamanga, umsebenzi uzokwenza ukusebenza okuhlukile.

Ukuhlolwa kokuqala kweqiniso noma kwamanga, kanye nemisebenzi yokulandelela, konke kusethwe ngezimpendulo zomsebenzi.

Ngaphezu kwalokho, imisebenzi eminingi ye-IF ingahle ibekwe ngaphakathi phakathi komunye nomunye ukuze ihlolwe izimo eziningi futhi isebenze imisebenzi eminingi kuye ngomphumela wezivivinyo.

Umsebenzi we-IF & # 39; s i-Syntax ne-Arguments

I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, ukwahlukanisa kwama-comma, nokuphikisana.

I-syntax yomsebenzi we-IF ngu:

= uma (ukuhlolwa, ke-kungokoqobo, ngaphandle kwalokho_kukhona)

Izimpendulo ezintathu zomsebenzi ziyi:

• ukuhlolwa - (okudingekayo) inani noma inkulumo ehlolwe ukuhlola ukuthi iqinisile noma ingamanga;
• ke -kuqinisekile - (okudingekayo) umsebenzi owenziwa uma ukuhlolwa kuyiqiniso;
• okungenjalo_value - (ngokuzikhethela) umsebenzi owenziwa uma ukuhlolwa kungamanga.

Qaphela: Uma ufaka umsebenzi we-IF, lezi zizathu ezintathu zihlukaniswa ngama-commas ( , ).

Isibonelo Ukusebenzisa i-Google Spreadsheet IF Umsebenzi:

Njengoba kuboniswe esithombeni ngenhla, umsebenzi we-IF usetshenziselwa ukubuyisela imiphumela ehlukahlukene njenge:

= uma (A2 = 200,1,2)

kuboniswe kumugqa wesi-3 wesibonelo.

Isibonelo salokhu:

• hlola ukubona ukuthi inani eliselifini le-A2 lilingana no- 200.
• Uma kuyenzeka, lo msebenzi ubonisa inani 1 kuseli B3.
• Uma i-A1 ingalingani no- 200, umsebenzi ubonisa inani 1 kuseli B3.

Ukufaka umsebenzi we-IF

I-Google Spreadsheets ayisebenzisi amabhokisi okuxoxa ukuze ufake izingqinamba zomsebenzi njengoba zingatholakala ku-Excel. Esikhundleni salokho, inebhokisi elikhombisa ukuzenzekelayo eliphambuka njengoba igama lomsebenzi lifakwe esitokisini.

Ukufaka i-IF Function & # 39; s Izimpendulo

1. Chofoza esitokisini B3 ukuze ukwenze iseli esebenzayo - yilapho imiphumela yomsebenzi we-IF izoboniswa.
2. Thayipha uphawu olulinganayo (=) olulandelwe igama lomsebenzi uma .
3. Njengoba uthayipha, ibhokisi eliphakamisa ngokuzenzakalelayo livela ngamagama wemisebenzi eqala ngencwadi ethi "Mina".
4. Uma igama IF livela ebhokisini, chofoza kukho ukufaka igama lomsebenzi nokuvula i-parenthesis noma ibhande elijikelezayo esitokisini B3.
5. Chofoza ku- cell A2 kusikripthi sokusebenza ukuze ufake leyo reference reference .
6. Ngemuva kokubhekisela kweseli, thayipha uphawu olulinganayo (=) olulandelwe inombolo 200 .
7. Faka i- comma ukuqedela ingxabano yokuhlola .
8. Thayipha u- 2 olulandelwe i- comma ukungena kule nombolo njenge-argument ye- then .
9. Thayipha 1 ukufaka le nombolo njengengxabano engenye indlela_ukungafaki ikhompiyutha.
10. Gcwalisa izingqinamba zomsebenzi.
11. Cindezela ukhiye wokungena kwikhibhodi ukufaka i-parenthesis yokuvala ) nokuqedela umsebenzi.
12. Inani 1 kufanele livele esitokisini A2, ngoba inani ku-A2 alilingani 200.
13. Uma uchofoza esitokisini B3 , umsebenzi ophelele = uma (A2 = 200,1,2) uvela kubha yefomula ngaphezulu kwephepha lokusebenzela .