Ayyukan Excel 30 a cikin kwanaki 30: CELL

Ranar 4 na gudun marathon 30 Excel yana aiki a cikin kwanaki 30 mun sami cikakkun bayanai game da yanayin aiki ta amfani da aikin takardunku (INFORM), kamar sigar Excel da yanayin sake lissafin.

Ranar goma sha ɗaya na marathon za mu ƙaddamar da nazarin aikin Sanarwa (CELL), wanda zai ba da rahoton bayanai game da tsarin tantanin halitta, abubuwan da ke ciki da wurin. Yana aiki kama da aikin takardunku (SANARWA), watau yana da jerin ƙididdiga waɗanda za a iya shigar da su cikin aikin, amma ba ya ƙunshi ɗaya ba, amma dalilai guda biyu.

Don haka bari mu kalli bayanin da misalai ta hanyar aiki Sanarwa (CELL). Idan kuna da wani abu don ƙarawa zuwa misalan mu da bayaninmu, da fatan za a raba shi a cikin sharhi.

Aiki 11: CELL

aiki Sanarwa (CELL) yana nuna bayani game da tsarawa, abun ciki, da wurin tantanin halitta a hanyar haɗin da aka bayar.

Ta yaya za a iya amfani da aikin CELL?

aiki Sanarwa (CELL) na iya bayar da rahoton waɗannan bayanai game da tantanin halitta:

  • Tsarin tantanin halitta lambobi.
  • Sunan takardar.
  • Daidaita ko faɗin ginshiƙi.

CELL syntax

aiki Sanarwa (CELL) yana da ma'ana mai zuwa:

CELL(info_type,reference)

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

info_type (info_type) yana ɗaya daga cikin zaɓuɓɓukan hujja:

  • adireshin (adireshi) - nuni ga tantanin halitta na farko a cikin gardama reference (link) a tsarin rubutu.
  • tare da (shafi) - lambar shafi na tantanin halitta a cikin gardama reference (link).
  • launi (launi) - ya dawo 1 idan tsarin tantanin halitta ya ba da damar canza launi don kyawawan dabi'u; a duk sauran lokuta, 0 (sifili) an mayar da su.
  • farin ciki (abun ciki) - Ƙimar tantanin halitta na hagu a cikin mahaɗin.
  • filename (sunan fayil) - sunan fayil da cikakken hanya.
  • format (tsara) – tsarin lamba na tantanin halitta.
  • akomo (brackets) - mayar da 1 idan an tsara tantanin halitta don nuna tabbatacce ko duk lambobi a cikin baka; a duk sauran lokuta ya dawo 0 (sifili).
  • prefix (prefix) – ƙimar rubutu daidai da prefix tantanin halitta (yana nuna nau'in daidaitawa).
  • kare (kariya) - 0 = tantanin halitta ba a kulle ba, 1 = kulle.
  • jere (string) shine lambar layin tantanin halitta.
  • type (nau'in) - nau'in bayanai a cikin tantanin halitta (ba komai, rubutu, wani).
  • nisa (nisa) - nisa na ginshiƙin tantanin halitta.

Matsalolin aikin CELL

Akwai ƴan abubuwa da ya kamata a kula dasu yayin amfani da aikin Sanarwa (CELL):

  • Idan hujja reference (bayani) an tsallake, ana mayar da sakamakon don tantanin halitta da aka gyara na ƙarshe. Don tabbatar da cewa sakamakon shine ainihin abin da kuke buƙata, yana da kyau a koyaushe ku nuna hanyar haɗin gwiwa. Hakanan zaka iya komawa zuwa tantanin halitta wanda ke dauke da aikin kanta Sanarwa (CELL).
  • Lokacin aiki tare da aikin Sanarwa (CELL), wani lokacin ya zama dole a sake lissafin takardar don sabunta sakamakon da aikin ya dawo.
  • Idan a matsayin hujja info_type (detail_type) ƙimar da aka zaɓa filename (sunan fayil) da littafin aikin Excel ba a riga an adana shi ba, sakamakon haka kirtani mara komai.

Misali 1: Tsarin Lambar Wayoyin salula

Tare da ma'ana format (tsarin) Kuna iya amfani da aikin Sanarwa (CELL) don nuna tsarin lambar tantanin halitta. Misali, idan cell B7 yana da tsari Janar (General), to sakamakon dabara zai kasance G:

=CELL("format",C2)

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

Ayyukan Excel 30 a cikin kwanaki 30: CELL

Misali 2: Taken Sheet

Tare da ma'ana filename ( filename ) aiki Sanarwa (CELL) zai nuna hanyar fayil, sunan fayil da sunan takarda.

=CELL("filename",B2)

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

Ayyukan Excel 30 a cikin kwanaki 30: CELL

Kuna iya cire sunan takardar daga sakamakon da aka samu ta amfani da wasu ayyuka. A cikin dabarar da ke ƙasa, ta amfani da ayyuka tsakiyar (PSTR) da KA (NENE), nemo madaidaicin madaidaicin kuma mayar da haruffa 32 da ke biye dasu (tsawon sunan takardar yana iyakance ga haruffa 31).

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

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

Ayyukan Excel 30 a cikin kwanaki 30: CELL

Misali 3: Sauya hujjar info_type (info_type) daga jerin zaɓuka

Maimakon shigar da ƙimar hujja info_type (detail_type) cikin aiki Sanarwa (CELL) azaman sigar rubutu, zaku iya komawa zuwa tantanin halitta mai ɗauke da ingantattun ƙima. A cikin wannan misali, tantanin halitta B4 ya ƙunshi jerin zaɓuka, kuma maimakon gardama info_type (detail_type) nuni ne ga wannan tantanin halitta. Hujja reference (link) yana nufin cell B2.

Lokacin da aka zaɓi ƙima kare (kare): Sakamakon shine 1 idan an kulle tantanin halitta, ko 0 (sifili) idan ba haka bane.

=CELL(B4,B2)

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

Ayyukan Excel 30 a cikin kwanaki 30: CELL

Lokacin da aka zaɓi ƙima nisa (nisa), sakamakon yana nuna nisa na ginshiƙi a tsarin lamba. Ƙungiyar ma'auni a wannan yanayin shine faɗin harafi ɗaya a daidaitaccen girman font.

Ayyukan Excel 30 a cikin kwanaki 30: CELL

Leave a Reply