Ungayibeka kanjani i-PLUS ngaphandle kwefomula ekudingisweni

Indlela 1: Ukushintsha ifomethi yeseli "umbhalo"

Indlela elula yokuxazulula inkinga ngokufakwa kwesibonakaliso se- "+" esitokisini ngaphambi kwenombolo ukushintsha ifomethi yeseli ibe "umbhalo". Ngakho-ke i-syntax ye-Excel ezenzakalelayo ngeke ibhekwe njengedingekile ukuze isuse uphawu lokuhlanganisa, ngakho-ke lapho ukonga izinguquko esitokisini, kuzosala. Inketho yokuhlela ifomethi yokuqala ukubiza imenyu yokuqukethwe.

1. Chofoza endaweni edingekayo ngenkinobho yegundane efanele.



2. Kumenyu yokuqukethwe evelayo, khetha u- "Ifomethi Yeseli".



3. Chofoza inketho ethi "Umbhalo" bese ugcine izinguquko ngokucindezela inkinobho ethi "KULUNGILE".



4. Phuma kumenyu bese wengeza isibonakaliso kwinani leselula.



5. Chofoza u-ENTER ukuze usebenzise ushintsho futhi uqiniseke ukuthi manje "+" akenzi ndawo.

Kunenketho yesibili yokushintsha ifomethi yeseli, okukufanele futhi ukusho ukuthi, ngoba ezimweni ezithile kuzobonakala kube lula kakhudlwana.

1. Okokuqala, khetha ibhlokhi ukuze uguqule ngokuchofoza kuwo kanye nge-LKM, bese kuthebhu yasekhaya, wandise kumenyu eyehlayo engxenyeni ethi "Numbe".



2. Kuyo, khetha inketho ethi "Umbhalo".



3. Buyela esitokisini, engeza okuhlanganise bese uqhafaza ku-Enter.

Indlela 2: Uhlelo lweSyntax Syntax

Kufakwe ku-syntax ye-Excel lapho ukuhlela amaseli kukuvumela ukuthi usebenzise amaqhinga amancane uma udinga ukucacisa ifomethi yawo noma ama-nuances athile. Endabeni ehlakazekile, kuzodingeka ubeke uphawu olulodwa kuphela ukuze "+" "alinyamalali.

1. Khetha iseli futhi bese wenza kusebenze insimu yokufaka yefomula.



2. Ekuqaleni, faka uphawu olusha lwezingcaphuno olulodwa - "'" (Incwadi e ekwakhekeni kweRussia).



3. Manje njengoba isikhombisi senzelwe izingcaphuno, faka uphawu lokuhlanganisa.



4. Ngemuva kokuchofoza inkinobho ethi Enter, uzobona ukuthi ifomethi yeseli iguqulwe ngokuzenzakalelayo embhalweni kanti i-Plus ayizange inyamalale.

Cabanga ukuthi izenzo ezibhekwayo zishintsha futhi zishintsha ifomethi yeseli, ngakho-ke ngeke kwenzeke ukuyifaka kwifomula noma ngokushesha ukubala inani njengoba kuyisici sazo zonke izixazululo ezihambisana nokufakwa "+" ngaphandle ifomula.

Indlela 3: Ukufaka uphawu olukhethekile

I-Excel isekela ukufakwa kwezinhlamvu ezikhethekile, kanye nemenyu ehlukile yabelwa yona. Lapho udinga ukunaka izinhlamvu ezimbili "+", ezingatholakala ecaleni eliphezulu noma elingezansi. Ukube ubufuna ukufakwa kwalokhu kukhethwa, landela imiyalo elandelayo.

1. Inkinobho yegundane kwesobunxele, khetha iseli ukufaka uphawu bese uya kuthebhu ethi "Insert".



2. Nweba i-block "yezimpawu".



3. Kuyo, khetha inketho yesibili "uphawu".



4. Kumenyu eyehlayo ethi "Setha", shintsha ipharamitha "ephezulu nephansi ne-indices".



5. Thola isibonakaliso sokuhlanganisa esisezingeni eliphezulu noma phansi, bese uchofoza kabili kukho ukuze ungeze.



6. Buyela esitokisini futhi uqiniseke ukuthi kukhona uphawu olukhethekile olufakiwe, bese uqhubeka nokuhlela okuqukethwe.