Mtheradi ulalo kupambana - ikulongosola zitsanzo.

Mu zonse, ngakhale phukusi zofunika "Microsoft Office" amapereka mphamvu spreadsheet mkonzi kupambana ( "kupambana"). Mndandanda wa ntchito kupezeka ndi chidwi: kuchokera kuthekera kusanja ndi deta zosefera kutsiriza ndi kuthekera kumanga maziko awo ndi zotchuka mwachidule. Ndipo kovuta deta aliyense kusungidwa anaika mu mkonzi popanda yopangidwa ndi mitunduyi mizere ndi mizati.

Mitunduyi mu "kupambana"

chilinganizo iliyonse - gulu kupanga limasonyeza khalidwe kubala yosiyana selo. Ndipo pamene wosuta polimbana ndi kufunika kutengera "Tambasula" chilinganizo kwa mzere lonse kapena ndime, ndiye iye amazindikira kuti nthaŵi zina mbali ya chilinganizo kapena njira zikhale kwathunthu sichinasinthe. Choncho wosuta adzadziwa kuti pali mu kupambana limasonyeza mtheradi ndi wachibale. Taganizirani mfundo zimenezi mwatsatanetsatane.

ulalo wachibale

Kumbukirani kuti ulalo wachibale kupambana, mosavuta kuposa kale. Mtundu kugwirizana amusankha ndi kusakhulupirika nasintha kufunika kwake pamene kukoka (kukopera) wa chilinganizo kuti loyandikana maselo kaya kukopera pamodzi mizati kapena mizere.

Taganizirani chitsanzo yosavuta kumva. Pangani akonzedwa ka deta, wopangidwa mwa magawo awiri: "Ntchito" ndi "malipiro":

Mu magawo a "kupambana" funsani A1 kalembedwe maumboni - akulankhula ngati yabwino ndi mwachilengedwe owerenga ambiri. Apa, A, B, C - maina mzati ndi manambala mzere. Choncho, deta ndende yake "Zakirova E. M." adiresi - A4. kupatuka Izi ang'onoang'ono adzafunika pamene ife tikubwera kuthana ndi maumboni mu kachitidwe.

Tiyerekezenso kuti tikufuna kuwerengetsa pamaziko a malipiro aliyense deta wantchito kopeleka malipiro. Ife perekani kwa selo C2 opotoka ndi kuikapo chilinganizo zotsatirazi (malinga ndi zomwe kuti malipiro ndi 40% ya malipiro): = B2 * 100/40. Apa B2 - koyamba wantchito malipiro tebulo. Ndipo dinani Enter Sunthani mbewa nsonga m'munsi lamanja la C2 selo, kuyembekezera mpaka kusintha Cholozera ndi woonda wakuda mtanda. Gwirani pansi kumanzere mbewa batani, kokani njira kufikira mapeto pa tebulo, umene mpaka C7 maselo (mukhoza m'malo kanthu ndi iwiri kuwonekera mbewa m'mphepete m'munsi lamanja la selo). mzati ndi basi lidzaze ndi deta:

deta chilinganizo selo motere:

Monga mukuonera, pamene ife anatambasula njira pansi pa ofukula dzina ndime amakhalabe zikutsatiridwa (B), koma mzere nambala ali zonse zinasintha. Mofananamo, kutengera njira horizontally, ife zonse chingwe mtengo ndi ndime chipinda chobvalira. Choncho, kugwirizana amatchedwa "wachibale" - buku loyamba chilinganizo analowa chidzasintha kugwirizana wachibale pamalo ake osiyanasiyana maselo tsamba.

Pamene ife tikuwona, kuthana ndi mfundo zimenezi kugwirizana wachibale kupambana, n'kosavuta.

Tiyeni tione mitundu zotsatirazi links.

ulalo mtheradi

Mtheradi ulalo kupambana - yotsatira wamba mtundu wa links. Pankhaniyi, pamene kukopera chilinganizo atathana mzere ndi ndime, amene amatchulidwa mu zonena za.

Kumene, palokha ndi Buku mtheradi si ntchito pa ndekha, chifukwa buku si mfundo zambiri. Choncho, mtundu wa kufalikira mu mitunduyi osakaniza, pamene ena a iwo - kutchulidwa mtheradi, ena wachibale.

Ife timathandiza Mwachitsanzo, china deta - pamwezi ndalama zogulira malipiro, yemweyo kwa antchito onse:

Choncho, m'pofunika kusintha ndi selo C2 ndi mawerengedwe malipiro, tsopano adzakhala ali chilinganizo zotsatirazi:

Pamene ife dinani Enter, tikuona kuti malipiro recalculated molondola mchipindamo. Koma pamene ife adzapatsa njira antchito onse, iwo malipiro si otero, pogwiritsa ntchito ulalo wachibale anayesera kuti atenge mfundo za G4..G8, kumene chilichonse. Kupewa vuto limeneli, m'pofunika ntchito Buku mtheradi mu kupambana. Logwirana ndime kapena mzere, amene amasintha pamene inu kutengera chilinganizo sayenera kukhala zofunika kuika ankalemekeza pafupi ndi dzina la ndime kapena mzere chizindikiro chiwerengero dollar ($).

Ife kusintha chilinganizo wathu otsatirawa:

Ndipo pamene ife kukopera izo, ndi malipiro onse ogwira ntchito recalculated:

Pafupi maganizo "Buku mtheradi" mu kupambana nthawizonse mfundo zokhudza losanganikirana.

ulalo osokonezeka

Taonani mtundu wa kulankhula. Obwerawa kugwirizana - ulalo kuti chasintha liti inu kutengera nambala ya ndime pa nambala zonse mzere, kapena mosinthanitsa. Motero chizindikiro dollar waima patsogolo pa nambala mzere motero (A $ 1) kapena pamaso pa ndime chiwerengero ($ A1) - ndiko kuti, pamaso mfundo sizidzasintha.

Link osokonezeka ntchito kwambiri zambiri kuposa kutchulidwa woona mtheradi. Mwachitsanzo, ngakhale Mwachitsanzo yosavuta yapita, ife tikhoza bwino m'malo chilinganizo = (B2 + $ G $ 3) * 100/40 kuti = (B2 + G $ 3) * 100/40 ndi kupeza zotsatira chomwecho, chifukwa ife kukopera chilinganizo molunjikitsa ndi ndime chiwerengero Mulimonsemo akanakhalabe sichinasinthe. Ndipo ndicho osanenapo zochitika pamene amafuna logwirana chokha chiwerengero mzere kapena ndime, ndi kusiya zina zilipo kusintha.

chidwi Ndipotu

Zidzakhala zosangalatsa kudziwa zimene kutchulidwa mtheradi mu kupambana akhoza anapereka osati kumasonyeza osadalira pa chizindikiro dola kutsogolo kwa mzere ndi / kapena yachiwiri. "Kupambana" amalola ndi kukanikiza F4 kiyi pamene kutchula adiresi ya foni kusankha mtundu limasonyeza - koyamba akulumikiza kusintha wachibale Mtheradi, pamene lachiwiri - losakanizika manambala atathana-mzere wachitatu - pa wosanganiza ndi chiwerengero kuliika pa danga, chabwino, nthawi yotsatira kuwonekera amakhalanso wachibale. Kusintha maonekedwe a olumikizirana kupambana choncho yabwino kwambiri, chifukwa Sikuti amachita kusintha kamangidwe kiyibodi.