Chinyorwa Directory
Ukaisa nhamba musero (arithmetic sequence), inobuda seSayenzi, asi inoda kuti iratidzwe senhamba.Wobva wapatsanura nhamba muzvikamu A uye B, wozvibatanidza mukoramu C, uko "=A1&B1
".
Ini ndinoda kuchengeta koramu C uye kudzima koramu A uye B, asi kana ndikadzima koramu A kana B nekupokana, iyo data yekoramu C inonyangarika, chii chandinofanira kuita?
Nzira yekubatanidza sei makoramu maviri mutafura imwe muExcel?
Kutanga, ngatitarisei kuti EXCEL inosanganisa sei data,Iwe unogona kuwana kusanganisa nekubatanidza mabasa & ▼
Kopa uye unamate se "zvinokosha"▼
- Wobva wadzima maseru usati wabatanidza.
Computer EXCEL tafura data nekukurumidza kudzima maseru akasanganiswa
Mushure mekubatanidza muEXCEL, bvisa maseru usati wabatanidza, asi unochengeta data rakasanganiswa.
Matanho chaiwo ekushanda kweiyi nzira ndeaya anotevera:
1. Vhura tafura yeEXCEL kuti ishandiswe pakombiyuta uye shandisa basa rekubatanidza musero risina chinhu=B4&C4
, wobva wadzvanya Enter kuti upedze basa rekugadzirisa uye kuisa ▼
- Nyora musero risina chinhu
=
- Mushure mekudzvanya sero yekutanga yaunoda kubatanidza, pinda
&
- Mushure mekudzvanya cell yechipiri yaunoda kubatanidza, dzvanya
Enter
kupinda - Zadza masero ezasi akabatanidzwa nekudonha pasi
- (mu
B4
uyeC4
Kuti maseru abatanidzwe, anogona kuchinjwa zvichienderana nemamiriro chaiwo)
2. Wobva wadzvanya Ctrl+C kukopa sero rakabatanidzwa remhedzisiro▼
3. Tinya-kurudyi pachisero chisina chinhu uye sarudza "Namira seKukosha" mu "Namira Yakakosha" ▼
- Bvisa masero usati wabatanidza, uye ona kuti masero asati abatanidza anobviswa mushure mokunge tafura yeEXCEL yabatanidzwa, uye kushanda kwekuchengetedza data yakabatanidzwa kwapera.
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) yakagovaniswa "Sei kusanganisa uye kudzima makoramu mukombuta EXCEL?Tafura Data Kurumidza Kudzima Masero Akasanganiswa", ichakubatsira iwe.
Welcome to share link yechinyorwa chino:https://www.chenweiliang.com/cwl-29147.html
Tikugashirei kuTeregiramu chiteshi cheChen Weiliang's blog kuti uwane zvichangobva kuitika!
📚 Iri gwara rine kukosha kukuru, 🌟Uyu mukana usingawanzo, usapotsa! ⏰⌛💨
Govera uye like kana uchida!
Kugovera kwako uye kuda ndiko kukurudzira kwedu kunoramba kuripo!