Yintoni i-syntax kwaye ndiza kuyisebenzisa nini kwi-Excel okanye kwi-Google AmaSpredishithi
I-syntax ye-Excel okanye umsebenzi we-spreadsheet umsebenzi we-Google ibhekisela kwisakhiwo kunye nomyalelo womsebenzi kunye neengxabano zayo. Umsebenzi kwi-Excel kunye ne-Google AmaSpredishithi yifom eyakhelwe ngaphakathi. Yonke imisebenzi iqala ngophawu olulinganayo ( = ) olulandelwe igama lomsebenzi njenge-IF, i-SUM, COUNT, okanye i-ROUND. Kufuneka usebenzise i-syntax efanelekileyo nanini na xa ufaka umsebenzi kwi-Excel okanye kwi-Google AmaSpredishithi okanye unokufumana umyalezo wephutha.
Iingxoxo zomsebenzi zibhekisela kuzo zonke iinkcukacha okanye ulwazi olufunekayo ngumsebenzi. Ezi ngxabano mazingeniswe ngendlela echanekileyo.
IF IF IFwork Syntax
Njengomzekelo, i-syntax yomsebenzi we-IF kwi-Excel yile:
= IF (Logical_test, Value_if_true, Value_if_false)
Abazali kunye neeKomas
Ukongezelela kumyalelo weengxabano, igama elithi "syntax" libhekisela ekubekeni kwamakhonkqo ajikeleziweyo okanye ngabazali abazungeze iingxabano kunye nokusetyenziswa kwe-comma njengomhluli phakathi kweengxoxo.
Qaphela: Kuba i-syntax yomsebenzi we-IF idinga i-comma ukuba ihlule iimbambano ezintathu zomsebenzi, awukwazi ukusebenzisa i-comma njengomhlukanisi ngamanani angaphezu kwewaka. Ukuba uyenzayo, i-Excel ibonisa ibhokisi yencoko yokuqwalasela ekuxelela ukuba ifumene ingxaki kwifom okanye ukuba iziphakamiso ezininzi zichazwe kulo msebenzi.
Ukufunda IF IF Function & # 39; s Syntax
Ngokulandela imigaqo ekhankanywe ngasentla, unokwazi ukuba umsebenzi we-IF kwi-Excel nakwi- Google AmaSpredishithi ngokuqhelekileyo uneengxoxo ezintathu ezilungiselelwe kule ndlela elandelayo:
- Ingxabano yeLogical_test
- Ixabiso-
- Ixabiso_if_false ingxabano
Ukuba iziphakamiso zifakwe kwimiyalelo eyahlukileyo, umsebenzi ubuyisela umyalezo wephutha okanye ukunika impendulo ongayilindele.
Eziyimfuneko kunye neeArguments option
Esinye isiqulatho sokwaziswa esiyi-syntax asixeli ukuba ngaba ingxoxo iyadingeka okanye ikhethiweyo. Kwimeko yomsebenzi we-IF, iimbambano zokuqala neyesibini-i-Logical_test kunye ne-Value_if_i-arguments-arguments-iyadingeka, ngelixa ingxabano yesithathu, i-Value_if_false argument, ikhethiweyo.
Ukuba impikiswano yesithathu ingashiywe kumsebenzi kwaye imeko ivivinywe ngumsebenzi weLogical_test ingxoxo ihlola ukuxoka, ngoko umsebenzi ubonisa igama elithi FALSE kwiseli apho umsebenzi ukhona.