Indlela yokubala i-coefffeefseff ye-Excel

Enye yezinkomba eziphambili zezibalo zokulandelana kwezinombolo yi-coeffleff ehlukahlukene. Ukuthola ukuthi kuyinkimbinkimbi kakhulu ukubala. Amathuluzi we-Microsoft Excel akuvumela ukuba uwanciphise kakhulu umsebenzisi.

Ukubalwa kokuhlanganiswa kokuhlukahluka

Le nkomba yisilinganiso sokuphambuka okujwayelekile ku-maphakathi arithmetic. Umphumela owatholakala uvezwa njengephesenti.

I-Excel ayikho ngokwehlukana imisebenzi yokubala le nkomba, kepha kukhona amafomula okubala ukuphambuka okujwayelekile kanye nochungechunge olujwayelekile lwezibalo zezinombolo, okungukuthi zisetshenziselwa ukuthola i-coefficient yokwehlukahluka.

Isinyathelo 1: Ukubalwa kokuphambuka okujwayelekile

Ukuphambuka okujwayelekile, noma, njengoba kubizwa ngokuhlukile, ukuphambuka okujwayelekile kuyimpande eyisikwele kusuka ekuhlakazeni. Ukubala ukuphambuka okujwayelekile, kusetshenziswa umsebenzi we-standwayo. Ukuqala nge-Excel 2010 Version, ihlukaniswe, kuya ngokuthi isethi ejwayelekile ibalwa noma ngesampula, izinketho ezimbili ezihlukile: i-moppsclone.g ne-stomplona.b.

I-syntax yale misebenzi ibukeka ngokufanele:

= I-stambuclone (inombolo1; inombolo2; ...)

= I-stoptonal.g (inombolo1; inombolo2; ...)

= I-stoptonclonal.v (inombolo1; inombolo2; ...)

1. Ukuze ubale ukuphambuka okujwayelekile, khetha noma iyiphi iseli yamahhala eshidini, elikulungele wena ukuze ubonise imiphumela yokubalwa. Chofoza inkinobho ethi "Namathisela Umsebenzi". Inokubukeka kwe-pictogram futhi itholakala ngakwesokunxele sentambo yefomula.



2. Ukusebenza kwe-wizard yemisebenzi kwenziwa, okuqalwa njengefasitela elihlukile ngohlu lwezimpikiswano. Iya esigabeni "sezibalo" noma "uhlu olugcwele lwezinhlamvu". Sikhetha igama elithi "StandotClonal.g" noma "i-momptotclona.v.", Kuya ngokuthi inhlanganisela ejwayelekile noma ngesampula kufanele libalwe. Chofoza inkinobho ethi "KULUNGILE".



3. Iwindi lezimpipho livulwa. Kungaba ukusuka kumasimu ayi-1 kuye kwangama-255, lapho kukhona izinombolo ezithile nezinkomba zamaseli noma amabanga. Sibeka ikhesa enkambini "yenombolo1". Igundane labela ububanzi bezindinganiso ezizocutshungulwa ephepheni. Uma kunezindawo eziningana ezinjalo futhi azisondelene komunye nomunye, izixhumanisi zalokhu okulandelayo zibonisa insimu "yenombolo2. Lapho yonke imininingwane edingekayo ifakiwe, chofoza inkinobho ethi "Kulungile"



4. Kwiseli elikhethwe ngaphambilini, ukubalwa okuphelele kohlobo olukhethiwe lokuphambuka okujwayelekile kuboniswa.

Isifundo: Ifomula ephakathi nendawo yokuphambuka e-Excel

Isinyathelo 2: Ukubalwa kwe-arith average

Isilinganiso se-arithmetic isilinganiso senani eliphelele lawo wonke amanani ochungechunge lwamanani kuya kubuningi babo. Ukubala le nkomba, kunomsebenzi ohlukile - i-CPNph. Bala inani layo ngesibonelo esithile.

1. Khetha iseli eshidini elizokhipha umphumela. Sichofoza inkinobho ethi "Incress function" asejwayele thina.



2. Esigabeni sezibalo seWizard yemisebenzi, sifuna igama elithi "srnvov". Ngemuva kokuthi ikhethiwe, cindezela inkinobho ethi "Kulungile".



3. Iwindi lokuphikisana liyasungulwa. Izimpikiswano zifana ngokuphelele neqiniso lokuthi abahlinzeki beqembu le-StandotClone. Okusho ukuthi, ngekhwalithi yabo kungasebenza njengezinombolo ezihlukile zezinombolo nezixhumanisi. Faka isikhombisi endle "Inombolo1". Futhi, njengasesimweni esedlule, sabela isethi yamaseli eshidini. Ngemuva kokuba izixhumanisi zabo zibhalwe efasiteleni lewindi lengxabano, chofoza inkinobho ethi "Kulungile".



4. Umphumela wokubala izibalo ezimaphakathi zithathwe esitokisini esaqokonyiswa ngaphambi kokuvula imisebenzi wizard.

Isifundo: Indlela yokubala inani elijwayelekile ku-Excel

Isinyathelo 3: Ukuthola i-coefficied yokwehlukahluka

Manje sinayo yonke imininingwane edingekayo ukuze libalo ngokuqondile i-coeffeeffeeffeeffeeffeeffess uqobo.

1. Khetha iseli lapho umphumela uzoboniswa khona. Okokuqala, kuyadingeka ukubheka ukuthi i-coeffred ehlukahlukene ingamaphesenti. Mayelana nalokhu, ifomethi yeseli kufanele iguqulwe ibe efanele. Lokhu kungenziwa ngemuva kokukhethwa kwayo, ngenkathi kuthebhu "Yasekhaya". Chofoza emkhakheni wefomethi ku-Ribbon kubha yamathuluzi "yenombolo". Kusuka kuhlu okuxoxiwe kokukhethwa kukho, khetha "amaphesenti". Ngemuva kwalezi zenzo, ifomethi endaweni leyo nto izobe kufaneleka.



2. Ubuyela esitokisini ukukhombisa umphumela. Kusebenze ngokuchofoza kabili kwenkinobho yegundane kwesobunxele. Sibeka uphawu kuyo "=". Khetha into lapho umphumela umphumela wokubalwa kokuphambuka okujwayelekile. Chofoza inkinobho ethi "Split" (/) kwikhibhodi. Okulandelayo, sabela iseli lapho uchungechunge lwezibalo lwe-arithmetic setha. Ukuze wenze ukubala nokukhipha, chofoza inkinobho ethi Enter kwikhibhodi.



3. Njengoba ubona, umphumela wokubala uyakhonjiswa.

Ngakho-ke, sibale i-coefficient of umelfeze, ebhekisa kumaseli lapho ukuphambuka okujwayelekile kanye nezilinganiso ze-arithmetic sezivele zibaliwe. Kepha ungaqhubeka futhi umehluko ngandlela thile, ngaphandle kokubala la magugu.

1. Khetha iseli elungiselelwe ngaphambili ngaphansi kwefomethi yamaphesenti lapho umphumela uzotholakala khona. Sibeka i-formula yohlobo kuyo:

   = I-standotclonal.v (Range_Name) / SR Will (Range_Name)

   Esikhundleni segama le- "Range Range" faka izixhumanisi zangempela zesifunda, lapho kufakwa khona uchungechunge lwezinombolo. Lokhu kungenziwa ngokwabiwa okulula kwaleli banga. Esikhundleni sopharetha wesimo se-stottotclonal. In, uma umsebenzisi ebheka kudingekile, umsebenzi ojwayelekile wesikhundla ungasetshenziswa.



2. Ngemuva kwalokho, ukubala inani futhi ubonise umphumela esikrinini sokuqapha, chofoza inkinobho ethi Enter.

Kukhona umehluko onemibandela. Kukholakala ukuthi uma inkomba ye-coeffled yokwehluka ingaphansi kwama-33%, khona-ke iqoqo lezinombolo alikhokhelwa. Esimweni esiphambene, kungokwesiko ukuveza njenge-heterogeneous.

Njengoba ubona, uhlelo lwe-Excel likuvumela ukuba wenze lula ukubalwa kokubalwa kwesibalo okuyinkimbinkimbi njengokusesha okuhlobene nokuhluka. Ngeshwa, iSithasiselo asikho khona umsebenzi ozobumba le nkomba esenzweni esisodwa, kepha ngosizo lwabaqhubi abasezingeni elijwayelekile, lo msebenzi wenziwa lula kakhulu. Ngakho-ke, ku-Excel, ngisho nomuntu ongenalo izinga eliphakeme lolwazi oluhlotshaniswa namaphethini wezibalo angenziwa.