Okuqukethwe
Ungakha ama-arrays ku-Microsoft Excel angagciniwe kububanzi bamaseli. Zivame ukubizwa ama-constants. Kulesi sifundo, uzofunda ukuthi yiziphi izinhlelo ezifanayo nokuthi ungasebenza kanjani ngazo ku-Excel.
Kafushane mayelana nezinhlaka zama-constants
Ukuze udale uxhaxha lwama-constants, faka izakhi zakhona futhi uzibophe ngezikaki ezigoqekile. Isibonelo, isibalo esingezansi sibonisa uhlu oluqukethe ama-constants angu-6:
={1;2;3;4;5;6}
Uhlu olunjalo lungasetshenziswa kumafomula e-Excel. Isibonelo, ifomula elandelayo ihlanganisa amanani alolu hlu:
=СУММ({1;2;3;4;5;6})
Amafomula angaphatha amalungu afanayo amaningi ngesikhathi esisodwa. Isibonelo, ifomula elandelayo izobuyisela inani eliphezulu eliwumphumela wokwengeza amalungu afanayo amabili wokuhlanganisa:
=МАКС({1;2;3;4;5;6}+{7,8,9,10,11,12})
Amalungu afanayo angashintshi angaqukatha izinombolo, umbhalo, ama-booleans, namanani amaphutha # N / A:
={12;"Текст";ИСТИНА;ЛОЖЬ;#Н/Д}
Ungase ube nombuzo onengqondo: Kungani sidinga uhlu olunjalo? Ngizoyiphendula ngesibonelo.
Isibonelo sokusebenzisa uxhaxha lwama-constants ku-Excel
Isibalo esingezansi sibonisa uhlu lwabafundi abathole amabanga athile:
Umsebenzi wethu ukuhumusha ukuhlola kusuka efomini lezinombolo kuya encazelweni yayo yomlomo futhi sibonise amanani ahambisanayo kububanzi C2:C7. Kulokhu, akunangqondo ukudala ithebula elihlukile lokugcina incazelo yombhalo yamabanga, ngakho-ke kunenzuzo enkulu ukwakha uhlu olulandelayo lwezimo ezihlala njalo:
={"";"Неудовл.";"Удовл.";"Хорошо";"Отлино"}
Kulokhu, ingxenye yokuqala yamalungu afanayo iqukethe iyunithi yezinhlamvu engenalutho, ngoba kucatshangwa ukuthi angeke kube khona ukuhlolwa kuka-1.
Khona-ke ifomula ebuyisela umphumela esiwudingayo izobukeka kanje:
Kulesi sibonelo, umsebenzi INDEX ibuyisela inani le-elementi ohlwini lwama-constants, indawo yawo enikezwa inombolo ye-ordinal (amaphuzu).
Le fomula ayilona ifomula yamalungu afanayo, nakuba iqukethe amalungu afanayo. Ngakho-ke, lapho uyifaka, kwanele ukucindezela ukhiye Faka.
Yebo, singakopisha le fomula kuwo wonke amaseli futhi sithole umphumela esiwudingayo:
Kodwa kungaba ubuhlakani ukusebenzisa ifomula yohlu lwamaseli amaningi. Kuzobukeka kanje:
Singaya phambili nakakhulu futhi sinikeze uhlu lwama-constants igama. Igama linikezwe ngendlela efanayo ncamashi nevamile, ngebhokisi lengxoxo Dala igama:
Ungakhohlwa ukufaka uphawu olulinganayo ebaleni Ibanga, ngaphandle kwalokho i-Excel izophatha amalungu afanayo njengeyunithi yezinhlamvu yombhalo.
Manje ifomula ibukeka ingethuki kangako:
Njengoba ubona, kwezinye izimo ama-arrays angashintshi awusizo kakhulu.
Ngakho-ke, kulesi sifundo, uye wajwayelana nezinhlaka zama-constants kanye nokusetshenziswa kwazo ku-Excel. Ukuze uthole ulwazi olwengeziwe mayelana nezinhlaka, funda izindatshana ezilandelayo:
- Isingeniso samafomula afanayo ku-Excel
- Amafomula we-Multicell array ku-Excel
- Amafomula ohlu lweseli eyodwa ku-Excel
- Ukuhlela amafomula afanayo ku-Excel
- Ukusebenzisa amafomula afanayo ku-Excel
- Izindlela zokuhlela amafomula afanayo ku-Excel