30 Excel imagwira ntchito m'masiku 30: CELL

Tsiku 4 la marathon 30 Excel imagwira ntchito m'masiku 30 tili ndi chidziwitso chatsatanetsatane cha malo ogwirira ntchito pogwiritsa ntchito ntchitoyi Info (INFORM), monga mtundu wa Excel ndi njira yowerengeranso.

Tsiku la khumi ndi limodzi la marathon tidzapereka phunziro la ntchitoyi Cell (CELL), yomwe idzafotokoze zambiri za masanjidwe a selo, zomwe zili mkati mwake ndi malo. Zimagwira ntchito mofananamo Info (INFORM), mwachitsanzo, ili ndi mndandanda wazinthu zomwe zitha kulowetsedwa mu ntchitoyi, koma mulibe imodzi, koma mikangano iwiri.

Choncho tiyeni tione zambiri ndi zitsanzo ndi ntchito Cell (SELU). Ngati muli ndi china choti muwonjezere ku zitsanzo ndi chidziwitso chathu, chonde gawanani mu ndemanga.

Ntchito 11: CELL

ntchito Cell (CELL) ikuwonetsa zambiri za masanjidwe, zomwe zili, ndi malo a selo pa ulalo womwe waperekedwa.

Kodi CELL ingagwiritsidwe ntchito bwanji?

ntchito Cell (CELL) ikhoza kufotokoza izi zokhudza selo:

  • Nambala yama cell.
  • Dzina lapepala.
  • Mayendedwe kapena m'lifupi mwake.

CELL Syntax

ntchito Cell (CELL) ili ndi mawu awa:

CELL(info_type,reference)

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

info_mtundu (info_type) ndi imodzi mwazosankha zotsutsana:

  • adiresi (adiresi) - kutchulidwa kwa selo loyamba mu mkangano Buku (ulalo) mumtundu wamawu.
  • ndi (gawo) - nambala ya gawo la selo mumkangano Buku (link).
  • mtundu (mtundu) - imabweretsanso 1 ngati mawonekedwe a cell amathandizira kusintha mtundu wazinthu zoyipa; muzochitika zina zonse, 0 (zero) amabwezedwa.
  • wokondwa (zamkati) - Mtengo wa cell yakumanzere yakumanzere mu ulalo.
  • filename (filename) - filename ndi njira yonse.
  • mtundu (mtundu) - mtundu wa nambala wa cell.
  • zolembera (mabulaketi) - imabweretsanso 1 ngati seloyo yapangidwa kuti iwonetse zabwino kapena manambala onse m'makolo; muzochitika zina zonse amabwerera 0 (ziro).
  • manambala oyamba (chiyambi) - mtengo wa malemba womwe umagwirizana ndi chiyambi cha selo label (chimasonyeza mtundu wa kuyanjanitsa).
  • kuteteza (chitetezo) - 0 = selo silinatseke, 1 = lotsekedwa.
  • mzere (chingwe) ndi nambala ya mzere wa selo.
  • mtundu (mtundu) - mtundu wa data mu cell (yopanda kanthu, zolemba, zina).
  • m'lifupi (m'lifupi) - m'lifupi mwa gawo la selo.

Zoyipa za ntchito ya CELL

Pali zinthu zingapo zomwe muyenera kuziganizira mukamagwiritsa ntchito Cell (CELL):

  • Ngati mkangano Buku (reference) zasiyidwa, zotsatira zimabwezeredwa ku selo losinthidwa lomaliza. Kuti muwonetsetse kuti zotsatira zake ndi zomwe mukufuna, ndikofunikira kuti nthawi zonse muziwonetsa ulalo. Mutha kutchulanso selo lomwe lili ndi ntchito yokhayo Cell (SELU).
  • Pamene ntchito ndi ntchito Cell (CELL), nthawi zina pamafunika kuwerengeranso pepala kuti musinthe zotsatira zomwe ntchitoyo ibwerera.
  • Ngati mkangano info_mtundu (detail_type) mtengo wasankhidwa filename (filename) ndi buku la Excel silinasungidwebe, zotsatira zake ndi chingwe chopanda kanthu.

Chitsanzo 1: Maonekedwe a Nambala Yam'manja

Ndi tanthauzo mtundu (mtundu) Mutha kugwiritsa ntchito ntchitoyi Cell (CELL) kusonyeza mtundu wa nambala ya selo. Mwachitsanzo, ngati selo B7 ili ndi mawonekedwe General (General), ndiye zotsatira za chilinganizo adzakhala G:

=CELL("format",C2)

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

30 Excel imagwira ntchito m'masiku 30: CELL

Chitsanzo 2: Mutu wa Mapepala

Ndi tanthauzo filename (filename) ntchito Cell (CELL) iwonetsa njira ya fayilo, dzina la fayilo ndi dzina latsamba.

=CELL("filename",B2)

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

30 Excel imagwira ntchito m'masiku 30: CELL

Mutha kuchotsa dzina la pepala kuchokera pazotsatira zomwe mwapeza pogwiritsa ntchito zina. Mu chilinganizo pansipa, ntchito ntchito MID (PSTR) ndi DZIWANI (PEZANI), pezani masikweya mabwalo ndikubweza zilembo 32 zomwe zimawatsatira (kutalika kwa tsambalo kumangokhala zilembo 31).

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

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

30 Excel imagwira ntchito m'masiku 30: CELL

Chitsanzo 3: Kulowetsa mkangano wa info_type (info_type) kuchokera pamndandanda wotsitsa

M'malo molowetsa mtengo wotsutsana info_mtundu (detail_type) mu ntchito Cell (CELL) ngati chingwe cha mawu, mutha kulozera ku selo lomwe lili ndi zolondola. Mu chitsanzo ichi, selo B4 ili ndi mndandanda wotsikira pansi, ndipo m'malo mwa mkangano info_mtundu (detail_type) ndizomwe zimatengera selo ili. Kukangana Buku (ulalo) amatanthauza cell B2.

Pamene mtengo wasankhidwa kuteteza (chitetezo): Zotsatira zake ndi 1 ngati selo yatsekedwa, kapena 0 (ziro) ngati sichoncho.

=CELL(B4,B2)

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

30 Excel imagwira ntchito m'masiku 30: CELL

Pamene mtengo wasankhidwa m'lifupi (m'lifupi), zotsatira zake zikuwonetsa m'lifupi mwagawo mumndandanda wonse. Muyeso wa muyeso munkhaniyi ndi m'lifupi mwa chilembo chimodzi pakukula kwake kwa font.

30 Excel imagwira ntchito m'masiku 30: CELL

Siyani Mumakonda