Imisebenzi engama-30 ye-Excel ezinsukwini ezingama-30: CELL

Usuku lwesi-4 lwemarathon 30 Excel isebenza ngezinsuku ezingama-30 sithole ulwazi oluningiliziwe mayelana nendawo yokusebenza sisebenzisa umsebenzi INFO (UKWAZISA), njengenguqulo ye-Excel kanye nemodi yokubala kabusha.

Usuku lweshumi nanye lwemarathon sizolunikela esifundweni somsebenzi ISELULEKILE (CELL), ezobika ulwazi mayelana nokufometha kweseli, elikuqukethe nendawo. Isebenza ngokufana nomsebenzi INFO (INFORM), okungukuthi inohlu lwamanani olungafakwa kumsebenzi, kodwa aluqukethe eyodwa, kodwa ama-agumenti amabili.

Ngakho ake sibheke ulwazi nezibonelo ngomsebenzi ISELULEKILE (ISELI). Uma unokuthile ongakwengeza ezibonelweni zethu nolwazi, sicela wabelane ngakho kumazwana.

Umsebenzi 11: ISELI

Umsebenzi ISELULEKILE (CELL) ibonisa ulwazi mayelana nokufometha, okuqukethwe, kanye nendawo yeseli kusixhumanisi esinikeziwe.

Umsebenzi we-CELL ungasetshenziswa kanjani?

Umsebenzi ISELULEKILE (CELL) ingabika ulwazi olulandelayo mayelana neseli:

  • Ifomethi yeseli yezinombolo.
  • Igama leshidi.
  • Ukuqondanisa noma ububanzi bekholomu.

I-CELL Syntax

Umsebenzi ISELULEKILE (CELL) ine-syntax elandelayo:

CELL(info_type,reference)

ЯЧЕЙКА(тип_сведений;ссылка)

uhlobo_lolwazi (info_type) ingenye yezinketho zokungqubuzana:

  • ikheli (ikheli) – ireferensi yeseli yokuqala kumpikiswano Inkomba (isixhumanisi) ngefomethi yombhalo.
  • nge (ikholomu) – inombolo yekholomu yeseli kumpikiswano Inkomba (isixhumanisi).
  • umbala (umbala) – ibuyisela u-1 uma ukufometha kweseli kunikeza ukushintsha umbala wamanani angemuhle; kuzo zonke ezinye izimo, 0 (zero) uyabuyiselwa.
  • okuqukethwe (okuqukethwe) – Inani leseli eliphezulu kwesokunxele kusixhumanisi.
  • igama lefayela (igama lefayela) - igama lefayela kanye nendlela egcwele.
  • Ifomethi (ifomethi) – inombolo yefomethi yeseli.
  • abakaki (abakaki) – ibuyisela u-1 uma iseli ifomethwe ukuze ibonise izinombolo eziphozithivu noma zonke kubakaki; kuzo zonke ezinye izimo ibuyisela u-0 (zero).
  • isimaphambili (isiqalo) – inani lombhalo elihambisana nesiqalo selebula yeseli (libonisa uhlobo lokuqondanisa).
  • ukuvikela (ukuvikela) – 0 = iseli alikhiyiwe, 1 = likhiyiwe.
  • umugqa (uchungechunge) inombolo yomugqa weseli.
  • uhlobo (uhlobo) – uhlobo lwedatha kuseli (okungenalutho, umbhalo, okunye).
  • ububanzi (ububanzi) – ububanzi bekholomu yeseli.

Izingibe zomsebenzi we-CELL

Kunezinto ezimbalwa okufanele uziqaphele lapho usebenzisa umsebenzi ISELULEKILE (ISELI):

  • Uma ingxabano Inkomba (inkomba) ayifakiwe, umphumela ubuyiselwa kuseli lokugcina elilungisiwe. Ukuze uqiniseke ukuthi umphumela uyilokho kanye okudingayo, kuhle ukuthi uhlale ubonisa isixhumanisi. Ungakwazi ngisho nokubhekisela kuseli eliqukethe umsebenzi ngokwawo ISELULEKILE (ISELI).
  • Lapho usebenza nomsebenzi ISELULEKILE (CELL), kwesinye isikhathi kuyadingeka ukubala kabusha ishidi ukuze ubuyekeze umphumela obuyayo umsebenzi.
  • Uma njengengxabano uhlobo_lolwazi (detail_type) inani elikhethiwe igama lefayela (igama lefayela) kanye nencwadi yokusebenzela ye-Excel ayikagcinwa, umphumela uwuchungechunge olungenalutho.

Isibonelo 1: Ifomethi Yenombolo Yeseli

Ngencazelo Ifomethi (ifomethi) Ungasebenzisa umsebenzi ISELULEKILE (CELL) ukuze ubonise ifomethi yenombolo yeseli. Isibonelo, uma iseli B7 inefomethi General (Okujwayelekile), khona-ke umphumela wefomula uzoba G:

=CELL("format",C2)

=ЯЧЕЙКА("формат";C2)

Imisebenzi engama-30 ye-Excel ezinsukwini ezingama-30: CELL

Isibonelo sesi-2: Isihloko Seshidi

Ngencazelo igama lefayela (igama lefayela) umsebenzi ISELULEKILE (CELL) izobonisa indlela yefayela, igama lefayela negama leshidi.

=CELL("filename",B2)

=ЯЧЕЙКА("имяфайла";B2)

Imisebenzi engama-30 ye-Excel ezinsukwini ezingama-30: CELL

Ungakwazi ukukhipha igama leshidi kumphumela otholiwe usebenzisa eminye imisebenzi. Kufomula engezansi, kusetshenziswa imisebenzi MID (PSTR) kanye THOLA (THOLA), thola abakaki abayisikwele bese ubuyisela izinhlamvu ezingu-32 ezizilandelayo (ubude begama leshidi bukhawulelwe ezinhlamvu ezingu-31).

=MID(CELL("filename",C3),FIND("]",CELL("filename",C3))+1,32)

=ПСТР(ЯЧЕЙКА("имяфайла";C3);НАЙТИ("]";ЯЧЕЙКА("имяфайла";C3))+1;32)

Imisebenzi engama-30 ye-Excel ezinsukwini ezingama-30: CELL

Isibonelo sesi-3: Ukufaka esikhundleni sokungqubuzana kwe-info_type (info_type) ohlwini olwehliswayo

Esikhundleni sokufaka inani lempikiswano uhlobo_lolwazi (detail_type) ibe umsebenzi ISELULEKILE (CELL) njengochungechunge lombhalo, ungabhekisela kuseli eliqukethe amanani avumelekile. Kulesi sibonelo, iseli B4 liqukethe uhlu lokudonsela phansi, futhi esikhundleni sokungqubuzana uhlobo_lolwazi (detail_type) iyireferensi yaleli seli. Ukuphikisana Inkomba (isixhumanisi) sibhekisela kuseli B2.

Lapho inani likhethiwe ukuvikela (vikela): Umphumela uba ngu-1 uma iseli likhiyiwe, noma u-0 (ziro) uma lingakhiyiwe.

=CELL(B4,B2)

=ЯЧЕЙКА(B4;B2)

Imisebenzi engama-30 ye-Excel ezinsukwini ezingama-30: CELL

Lapho inani likhethiwe ububanzi (ububanzi), umphumela ubonisa ububanzi bekholomu ngefomethi ephelele. Iyunithi yokulinganisa kulesi simo ububanzi bohlamvu olulodwa kusayizi wefonti ojwayelekile.

Imisebenzi engama-30 ye-Excel ezinsukwini ezingama-30: CELL

shiya impendulo