Amakhompyutha, Isofthiwe
Indlela yokwenza ukuphindwaphindwa e Excel
i-spreadsheet Onamandla "uHlelo Lokungena Emibikweni Ye" kalula ngizakwandisa yimiphi izinombolo zakho kanye nobubanzi. Lapho-ke kungaba usizo ngempela kule ndaba? Kukhona izixazululo eziningi:
- Isandla akuyona wokubala.
- Phindaphinda amabanga elikhulu izinombolo, futhi ufuna ukubona ukuthi yini behileleka uhlobo izinombolo, mhlawumbe ngisho esikhundleni ezinye zazo (esezingeni wokubala imisebenzi ngaphandle isidingo ukuqala umugqa futhi ugcine ukubala).
- Ukubuyabuyelela - ingxenye kuphela esiyinhlanganisela ifomula.
Njengoba ubona, ukuphindwaphindwa kuya Excel - into ngokuphelele hhayi engadingekile. Ngaphandle ukubuyabuyelela hhayi imisebenzi ongayenza cishe akekho ifomula.
Ukuhluka siphindaphindeka "Excel"
"Excel" ikuvumela ukuba ngandise nomunye:
- izinombolo Specific (omuhle, negative, ephelele, ayingxenye).
- Izinombolo kula maseli.
- Amabanga izinombolo.
- amanani Izimiso eziphusile
Indlela ukwenza ukubuyabuyelela? Ifomula zokuphindaphinda Excel iqala isibonakaliso "kulingana" (=). Njengoba kunjalo kubo bonke ngemuva kwalokhu ifomula wabonisa enye ngemva kwenye inombolo (noma ireferensi yeseli equkethe nabo) exhunywe uphawu "inkanyezi" (*). ifomula okunjalo kungaba kanje: "= 0.22 * 16 -5 *" (uma sanda isibalo esithile) noma «= G4 * i5» (njengoba agumenti lapho ecacisiwe cell izinkomba). Lena yi-version lokuqala ukubuyabuyelela.
ukubuyabuyelela Ifomula Excel zingaqoshwa usebenzisa esakhelwe "ukwenza" umsebenzi:
igama umsebenzi | agumenti | incazelo |
ukwenza | Inombolo / ububanzi 1; Inombolo / ububanzi 2; ... Inombolo / ububanzi 255; | Waba yini umphumela wesibindi umsebenzi - umkhiqizo agumenti. Ubude 255 ingasetshenziswa izinombolo ethize noma ububanzi (usayizi senhlobo akugcini). |
Okuhle ngokusebenzisa lo msebenzi-ke ukwenza ukubuyabuyelela kuya Excel - kungenzeka yanda ngezinkulungwane nomunye, hhayi izinombolo kuphela, kodwa futhi izibopho.
Manje cabanga ngezibonelo ezithile.
Ukubuyabuyelela "inkanyezi"
Zama lokusebenzela yencwadi "Excel" landela lezi zibonelo:
Inani 1 | Inani 2 | ifomula | yi | |
A | B | C | D | |
2 | 2 | 3 | = A2 * B2 | 6 |
3 | 0.7 | -6 | = A3 * B3 | -4,2 |
4 | IQINISO | IQINISO | = A4 * B4 | 1 |
5 | IQINISO | FALSE | = A5 * B5 | 0 |
6 | FALSE | FALSE | = A6 * B6 | 0 |
Nabo, uzobona ukuthi ukwenza ukubuyabuyelela Excel kulula. Qaphela ukuthi umphumela ukuphindwaphindwa logic amagugu babe 0 (amanga) noma 1 (iqiniso).
I ethile kuphela le ndlela zokuphindaphinda - ukuthi uhla lwezinombolo njengephuzu lokuphikisa, akakwazi ukwamukela. Mhlawumbe esiphezulu, okuyinto kwanele anoma yimuphi umsebenzisi kuchazwa endaweni ethile ekupheleni yesibili izinombolo eziyishumi noma esitokisini, hambisa, futhi esikukhompiyutha ukuze izinhlamvu "lwenkanyezi."
Okuwukuphela kwendlela ngalesi ethile iwukusebenzisa 'ukwenza "umsebenzi.
Ukubuyabuyelela usebenzisa "ukwenza" umsebenzi
Cabanga indlela yokukwenza ukubuyabuyelela Excel usebenzisa umsebenzi eyakhelwe ngaphakathi.
Ibhuku "Excel" ukudala ipuleti ezifanayo futhi uhlole izibonelo wakhe. Kokunye ikholomu wokwenza izimiso eziningi enye ikholomu futhi wenze nezincazelo eziningana. Zama ukusebenzisa umsebenzi "ukwenza" amaviyo akho, futhi enze ukubuyabuyelela ngesandla ngokusebenzisa uphawu "inkanyezi".
H | mina | J | K | |
Ibanga 1 | Ibanga 2 | yi | ifomula | |
12 | 2 | 6 | 9,378,270.72 | Ikhishwa = (H12: H16; I12: I16) |
13 | 7 | 14.2 | 9,378,270.72 | Ikhishwa = (H12: I16) |
14 | 5 | -2,7 | 9,378,270.72 | = H12 * H13 * H14 * H15 * H16 * I12 * I13 * I14 * I15 * I16 |
15 | 0,26 | 4 | ||
16 | -10 | 56 |
Ohlwini "Umthetho ofingqiwe" kwaleli thebula libonisa ngokucacile ukuthi uma amabanga ukubaluleka eniseduze, angasetshenziswa njengoba ububanzi. Futhi etafuleni ungabona ukuthi umsebenzi "ukwenza" ukwanda zonke lezi amabanga, futhi uthole imiphumela ngendlela efanayo njengoba sigibele ngesandla esisodwa esandisa ukubaluleka kulezi cells. Njengoba ubona, ukuphindwaphindwa kuya Excel - ilula.
Eqinisweni abathandwayo! Zama nenani elilodwa manje zisuswe kusukela kunoma yimaphi cell, ingxenye ububanzi, sezitokisi ezingenalutho ngeke sibe nalutho nhlobo. Uzobona ukuthi ngesikhathi esifanayo wenze umsebenzi ukwenza ukubala, umane ukukhulula eyeseli elingenalutho. Futhi lapha kuwumphumela "manual" ukubuyabuyelela waphenduka zero. Lokhu kungesinye inzuzo elikhethiwe inketho esakhelwe ukuphindaphindeka "lwenkanyezi" - ke alamukeli lamaseli angenalutho njengoba kuqanda, nje iyabakhulula kusukela ukubala.
Kunezikhathi lapho izibalo enzelwa sebuningini umsebenzi amashidi izincwadi, futhi ishidi okuholela lilondolozwe ifomula, ehlanganisa umkhiqizo abakuzuzile amanye amashidi. Uma noma yimuphi omunye wabo ngeke sibe nalutho, a ukubuyabuyelela okulula 'inkanyezi' ujike yonke imiphumela yakho ngo-zero.
Kule singaphetha ngokuthi ekuphathweni izibalo eziyinkimbinkimbi ku amashidi amaningi kungcono ukusebenzisa umsebenzi "ukwenza" njengento yokuqala.
ikhasi lezici
Bheka ekugcineni, udale ithebula ukubuyabuyelela Excel. Kulula.
A | B | C | D | E | |
1 | 2 | 4 | 6 | 8 | |
2 | 3 | = $ A2 * B $ 1 | 12 | 18 | 24 |
3 | 5 | 10 | 20 | 30 | 40 |
4 | 7 | 14 | 28 | 42 | 56 |
5 | 9 | 18 | 36 | 54 | = $ A5 * E $ 1 |
Ngo isiko etafuleni ukubuyabuyelela ejwayelekile kuhlanganisa ikholomu olulodwa neqoqo elilodwa izinombolo zilandelana - omunye. Ukuze ukwazi ukukopisha ifomula, kubalulekile ukusebenzisa izixhumanisi okuxubile - ukulungisa isibonakaliso "dollar" ($) inombolo kukholomu ezisukela mpo idatha imigqa ovundlile ukuba idatha '= A2 * $ B $ 1 ".
Similar articles
Trending Now