Nzira yekushandisa nayo Excel RIGHT Function
The Excel RIGHT function inokubvumira kuti ubvise tsvina dzisina kudiwa kubva kune dheji inotengeswa. Kana mashoko akakopizwa kana kutumirwa kuExcel, zvidhakwa zvisingabvumirwi marara dzimwe nguva zvinosanganiswa nemashoko akanaka.
Kana kuti, pane dzimwe nguva apo chikamu chemashoko akaiswa mune sechitoro chinodiwa, zvakadai sezita remunhu rokutanga asi kwete zita rekupedzisira.
Mumamiriro ezvinhu akadai, Excel ine mabasa akawanda anogona kushandiswa kubvisa data isina kudiwa kubva kune vamwe vose. Iko basa raunoshandisa kunobva pane iyo inoda data inowanikwa neyevanhu vasingadikanwi vari muchitokisi.
- Kana iyo data yaidikanwa iri kurutivi rworudyi rwemashoko, shandisa RIGHT work kuti ibvise iyo. Iyi dzidzo ichakuratidza kuti basa iri rinoshandiswa sei.
- Kana iyo data yaidikanwa iri kuruboshwe rwese data, shandisa basa re LEFT kuti ribvise.
- Kana iyo data yaidiwa ine zvinyorwa zvisingadiwi kumativi maviri acho, shandisa MID basa kuti ibvise.
01 of 03
ICHITENDE Basa Rinoshandiswa Sendikoni uye Arguments
MuchiExcel, chirevo chebasa chinoreva kurongeka kwebasa uye rinosanganisira zita remabasa, vanababa, uye nharo .
Izwi rechirevo cheRIGHT work ndeyokuti:
= CHINHU (Mhemberero, Num_chars)
Nheyo dzemabasa dzinoudza Excel kuti chii chinoshandiswa kushandiswa mubasa uye kureba kwetambo kunodzingwa.
Nyaya- (Inodikanwa) iyo inenge ine data inoda. Iyi nharo inogona kuva sero rinotarisa kune nzvimbo yedhesi mubasa rekushandura , kana inogona kuva iyo chaiyo yakaiswa mukati mamashoko ezvinyorwa.
Num_chars- (Zvichida) inotsanangura nhamba yevanhu vari kurudyi rwetambo nharo kuti ichengetwe; zvimwe zvese zvinyorwa zvinobviswa. Iyi nharo inofanira kuva yakakura kupinda kana yakaenzana ne zero. Kana nharo iyi isingabvumirwi, kukosha kwemaitiro 1 kunoshandiswa nebasa. Kana izvi zvakakura kudarika urefu hwemavara, basa rinodzorera zvose zvinyorwa.
02 of 03
Muenzaniso: Kubvisa Vanenge Vasingadikanwi neVANHU PAMUSORO YEMOVANHU
Muenzaniso uri mumufananidzo uri pamusoro unoshandisa RUDZO basa
- bvisa izwi rokuti Widget kubva pane zvinyorwa zvemashoko mazhinji * & ^% Widget iri muchitokisi B1 mubasa rekushanda
- kubvisa 789876 kubva pane nhamba refu 123456789876 iri muchitokisi B2 mubasa rekushanda
Pasi pane matanho ekutaurira kuti chibereko chekutanga chakawanikwa sei.
Zvisarudzo zvekupinda muRIGHT work uye nharo dzayo muchitokisi B1 dzinosanganisira:
- Kunyora basa rakakwana = RURI (B1,6) muchitokisi C1.
- Kusarudza basa uye nharo kushandisa sarudzo yebhokisi rebasa
Kushandisa bhokisi rekuda kupinda basa rinowanzoita kuti basa racho rive nyore, sezvo bhokisi rebhokisi rinotarisira sangano rebasa nekupinda muzita rebasa, maparasator emakasita, uye mabheketi munzvimbo dzakakodzera uye kuwanda.
Kutarisa paCheferensi dzeChechi
Hazvina mhosva kuti unosarudza kupi kuti upinde mubasa rekushanda kwepafashiti, zvichida zvakanakisa kushandisa ikokutaura kupinda chero yese uye zvese zvinyorwa zvinoshandiswa semafungiro.
Kutaura kunosanganisira kushandiswa kweiyo mutsara kuti uise pane imwe seferensi kuitira kuti uiise mubasa. Kuita izvi kunobatsira kubvisa zvikanganiso zvinokonzerwa nokunyora mune zvisina kururama sechitsekedzo.
Kushandisa RIGHT Bhokisi reSebenzi Dialog Box
Pinda muHURIRO basa uye nharo dzayo muchitokisi C1 uchishandisa basa rebhokisi rekuti:
- Dzvanya pachitokisi C1 kuti uite iyo inoshanda masero- ndiko ndiko kuti migumisiro yebasa icharatidzwa.
- Dzvanya maTramulas tab ye menu yebhoni .
- Sarudza Rugwaro kubva kubhoni kuti uzarure urongwa hwekuderera.
- Dzvanya PAMUSORO pane urongwa kuti uburise bhokisi rebasa rebasa.
- Mubhokisi rebhokisi, chengetedza Text line.
- Dzvanya pane sero B1 mubasa rekushanda.
- Dzvanya pane Num_chars line.
- Tora mu nhamba nhanhatu (6) pamutsara uyu sezvo isu tichida chete kuchengetedza vatanhatu vakarurama.
- Dzvanya OK kuti upedze basa uye dzokera kushizha rekushanda.
Mashoko akabudiswa "Widget" anofanira kuonekwa muchitokisi C1.
Paunenge uchinyora pachitsime C1, basa rakakwana = RERO (B1,6) rinowanikwa mubhairi yepamusoro pane pepa pepaji.
03 of 03
Kubvisa Nhamba Nechirengero Basa
Sezvinoratidzwa mumutsara wechipiri wemuenzaniso uri pamusoro, RUMO basa rinogona kushandiswa kubvisa subset yenhamba yenhamba kubva kune imwe nhamba uchishandisa matanho akanyorwa.
Chero dambudziko nderokuti iyo yakabudiswa inodhindurwa yakanyorwa uye haigone kushandiswa mukuverenga inosanganisira mamwe mabasa, akadai seSUM neAVERAGE mabasa.
Imwe nzira inopoteredza dambudziko iri nderokushandisa basa re VALUE kushandura zvinyorwa kuva nhamba.
Semuyenzaniso:
= VALUE (RIGHT (B2, 6))
Chinhu chechipiri ndechokushandisa pasa yakakosha yekushandura zvinyorwa kune nhamba .