Iyini i-syntax futhi ngizoyisebenzisa nini ku-Excel noma ku-Google AmaSpredishithi
I-syntax ye-Excel noma i-Spreadsheet function ye-Google AmaSpredishithi ibhekisela ekuhlelweni nasekuhleleni komsebenzi nezimpikiswano zayo. Umsebenzi ku-Excel ne-Google AmaSpredishithi ifomula eyakhelwe ngaphakathi. Yonke imisebenzi iqala ngesibalo esilinganayo ( = ) ilandelwa igama lomsebenzi njenge-IF, SUM, COUNT, noma ROUND. Udinga ukusebenzisa i-syntax efanele uma ufaka umsebenzi ku-Excel noma kuma-Google AmaSpredishithi noma cishe uzothola umyalezo wephutha.
Iziphakamiso zomsebenzi zibhekisela kuwo wonke idatha noma ulwazi oludingwa umsebenzi. Lezi zimpikiswano kufanele zifakwe ngokulandelana okulungile.
I-IF Function Syntax
Isibonelo, i-syntax ye-IF umsebenzi ku-Excel yile:
= IF (Logical_test, Value_if_true, Value_if_false)
Ama-parent and Commas
Ngaphezu kokuhlelwa kwezingxabano, igama elithi "syntax" libhekisela ekubekeni kwamakaki amabili noma abazali abakuzungezile izingxabano kanye nokusetshenziswa komhlahlandlela njengendlela yokwehlukanisa phakathi kwezingxabano ngabanye.
Qaphela: Kusukela i-syntax yomsebenzi we-IF idinga ukuba i-comma ihlukanise izimpikiswano ezintathu zomsebenzi, awukwazi ukusebenzisa i-comma njengomhlukanisi ngezinombolo ezinkulu kunezinkulungwane. Uma wenza, i-Excel ibonisa ibhokisi lengxoxo yokuxwayisa ekutshela ukuthi lithole inkinga ngefomula noma ukuthi izimpikiswano eziningi kakhulu zichazwe kulo msebenzi.
Ukufunda umsebenzi we-IF & # 39; s i-Syntax
Ngokulandela imithetho okukhulunywe ngenhla, ungathola ukuthi umsebenzi we-IF ku-Excel naku- Google AmaSpredishithi uvame ukufaka imibono emithathu ehlelwe ngale ndlela:
- I-argical Logical_test
- I-value_if_yiqiniso eliphikisayo
- I-value_if_false ingxabano
Uma iziphakamiso zifakwa ngendlela ehlukile, umsebenzi ubuyisela umlayezo wephutha noma ikunikeza impendulo ongayilindele.
Okudingekayo nokuphikisana okukhethwa kukho
Ingxenye eyodwa yolwazi i-syntax engayishoyo ukuthi ngabe ingxabano iyadingeka noma iyakhethwa yini. Endabeni yomsebenzi we-IF, izingxabano zokuqala nezesibili-izingxoxo ze-Logical_test kanye ne-Value_if_true-ziyadingeka, ngenkathi ingxabano yesithathu, i-Value_if_false argument, ikhetheka.
Uma ingxabano yesithathu ishiywe emsebenzini futhi isimo esivivinywe yi-Logical_test ingxabano yomsebenzi sihlola kumanga, khona-ke umsebenzi ubonisa igama elithi FALSE esitokisini lapho umsebenzi ukhona khona.