KULI mu Excel. Fomula ndikugwiritsa ntchito RIGHT ntchito mu Excel

Purosesa ya mawu a Excel ili ndi ogwiritsa ntchito ambiri omwe amakulolani kuti musinthe zambiri zamalemba. Ntchito ya RIGHT imachotsa nambala inayake kuchokera mu selo lopatsidwa. M'nkhaniyi, tiphunzira mwatsatanetsatane mbali za woyendetsa uyu, komanso, pogwiritsa ntchito zitsanzo zina, tidzapeza mbali zonse za ntchitoyi.

Zolinga ndi zolinga za wogwiritsa ntchito RIGHT

Cholinga chachikulu cha RIGHT ndikuchotsa zilembo zingapo kuchokera mu selo lomwe laperekedwa. Kutulutsa kumayambira kumapeto (kumanja). Zotsatira za kusinthako zikuwonetsedwa mu selo losankhidwa koyambirira, momwe chilinganizo ndi ntchito yokhayo imawonjezeredwa. Ntchitoyi imagwiritsidwa ntchito kuwongolera zambiri zamawu. KULADZO kuli mugulu la Mawu.

Kufotokozera kwa woyendetsa WARIGHT mu Excel spreadsheet

Maonedwe onse a wogwiritsa ntchito: =KUYERA(mawu, chiwerengero_cha_zilembo). Tiyeni tiwone mkangano uliwonse:

• Mtsutso woyamba - "Zolemba". Ichi ndi chizindikiro choyamba chomwe zilembo zidzachotsedwa. Mtengo ukhoza kukhala malemba enieni (ndiye kuchotsa kuchokera m'malembawo kudzachitidwa poganizira chiwerengero cha zilembo) kapena adiresi ya selo yomwe kuchotsako kudzachitidwa.
• Mtsutso wachiwiri - "Nambala_ya_anthu". Izi zikuwonetseratu kuchuluka kwa zilembo zomwe zidzachotsedwe pamtengo wosankhidwa. Mtsutso umatchulidwa ngati manambala.

Tcherani khutu! Ngati mkanganowu sunadzazidwe, ndiye kuti selo lomwe zotsatira zake zawonetsedwa zidzawonetsa chilembo chokha chomaliza kumanja kwa mkangano wamawu womwe waperekedwa. Mwa kuyankhula kwina, ngati kuti talowa gawo mu gawo ili.

Kugwiritsa Ntchito WOYERA WOYERA ku Chitsanzo Chake

Pachitsanzo chodziwika bwino, tiyeni tilingalire kagwiridwe ka ntchito ka WARIGHT operator kuti tidziwe bwino mbali zake. Mwachitsanzo, tili ndi mbale yomwe imawonetsa malonda a sneakers. Mugawo loyamba, mayina amaperekedwa ndi kusonyeza kukula kwake. Ntchito ndikuchotsa miyeso iyi kukhala gawo lina.

Kuyenda:

1. Poyamba, tifunika kupanga ndime yomwe chidziwitso chidzatulutsidwa. Tiyeni titchule dzina - "Kukula".

2. Sunthani cholozera ku selo yoyamba ya mzati, kubwera pambuyo pa dzina, ndikusankha mwa kukanikiza LMB. Dinani pa "Insert Function" chinthu.

3. Zenera la Insert Function likuwonekera pazenera. Timapeza mawu akuti "Category:" ndikutsegula mndandanda womwe uli pafupi ndi izi. Pamndandanda womwe ukutsegulidwa, pezani chinthucho "Text" ndikudina LMB.

4. Pazenera la "Sankhani ntchito" onse omwe angagwiritse ntchito malemba adawonetsedwa. Timapeza ntchito "KUDALIRA" ndikusankha mothandizidwa ndi LMB. Pambuyo pochita zosintha zonse, dinani batani "Chabwino".

5. Zenera la "Function Arguments" linawonekera pachiwonetsero ndi mizere iwiri yopanda kanthu. Mu mzere wa "Text" muyenera kuyika ma coordinates a cell 1 ya gawo "Dzina". Mu chitsanzo chathu chenicheni, iyi ndi selo A2. Mutha kuchita izi nokha polowetsa pamanja kapena kutchula adilesi ya foni. Dinani pamzere kuti mupeze mndandanda wazinthu, ndiyeno dinani LMB pa selo yomwe mukufuna. Mu mzere "Number of_characters" timayika chiwerengero cha zilembo mu "Kukula". Mu chitsanzo ichi, iyi ndi nambala 9, popeza miyeso ili kumapeto kwa munda ndipo imakhala ndi zilembo zisanu ndi zinayi. Ndikoyenera kudziwa kuti "danga" ndi chizindikiro. pambuyo kuphedwa onse Action timasindikiza «CHABWINO".

6. Pambuyo pochita zosintha zonse, muyenera kukanikiza batani la "Enter".

Zofunika! Mutha kulemba fomula yoyendetsera nokha posuntha cholozera ku cell yomwe mukufuna ndikutchula mtengo wake: =KUTI(A2).

7. Chifukwa cha zowonongeka zomwe zachitidwa, kukula kwa sneakers kudzawonetsedwa mu selo yosankhidwa, momwe tinawonjezera woyendetsa.

8. Chotsatira, muyenera kuonetsetsa kuti woyendetsayo akugwiritsidwa ntchito pa selo iliyonse ya "Size" column. Sunthani cholozera cha mbewa pakona yakumanja ya m'munda ndi mtengo wa fomula yomwe mwalowa. Cholozeracho chiyenera kukhala ngati chizindikiro chaching'ono chakuda chophatikiza. Gwirani LMB ndikusunthira cholozera pansi. Tikasankha mtundu wonse wofunikira, masulani batani.

9. Pamapeto pake, mizere yonse ya ndime ya "Kukula" idzadzazidwa ndi chidziwitso kuchokera pagawo la "Dzina" (zilembo zisanu ndi zinayi zoyambirira zasonyezedwa).

10. Komanso, ngati muchotsa zikhalidwe ndi kukula kwa gawo la "Dzina", ndiye kuti zidzachotsedwanso pagawo la "Size". Izi zili choncho chifukwa mizati iwiriyi tsopano ikugwirizana. Tiyenera kuchotsa ulalowu kuti zikhale zosavuta kuti tigwire ntchito ndi chidziwitso cha tabular. Timasankha ma cell onse a "Size", ndiyeno dinani kumanzere pa chithunzi cha "Copy" chomwe chili mu "Clipboard" gawo la "Home". Njira ina yosinthira kukopera ndi njira yachidule ya kiyibodi "Ctrl + C". Njira yachitatu ndikugwiritsa ntchito menyu yankhaniyo, yomwe imatchedwa ndikudina kumanja pa cell yomwe yasankhidwa.

11. Pa gawo lotsatira, dinani kumanja pa cell 1 yamalo omwe adalembedwa kale, ndiyeno mumenyu yankhaniyo timapeza chipika cha "Paste Options". Apa timasankha chinthu "Values".

12. Zotsatira zake, zonse zomwe zidayikidwa mugawo la "Kukula" zidakhala zodziyimira pawokha komanso zosagwirizana ndi gawo la "Dzina". Tsopano mutha kusintha ndikuchotsa m'maselo osiyanasiyana popanda chiopsezo chakusintha kwa data muzambiri zina.

Mapeto ndi zomaliza pa ZOCHITIKA ntchito

Spreadsheet Excel ili ndi ntchito zambiri zomwe zimakupatsani mwayi wosintha zinthu zosiyanasiyana ndi zolemba, manambala ndi zithunzi. Wogwiritsa WARIGHT amathandiza ogwiritsa ntchito kuchepetsa nthawi yochotsa zilembo kuchokera pagawo lina kupita ku lina. Ntchitoyi ndi yabwino kwambiri pogwira ntchito ndi zidziwitso zambiri, chifukwa zimakulolani kuthetsa kulingalira kwa zolakwika zambiri.