Ifomula ephakathi nendawo yokuphambuka e-Excel

Enye yamathuluzi amakhulu wokuhlaziywa kwezibalo ukubala ukuphambuka okuphakathi kwe-quadratic. Le nkomba yenza sikwazi ukudweba ukuphambuka okujwayelekile kwesampula noma ngenani elijwayelekile. Ake sifunde ukuthi singalisebenzisa kanjani ifomula yokunquma ukuphambuka okujwayelekile ku-Excel.

Ukuchazwa kokuphambuka okuphakathi kwe-quadratic

Masinyane thola ukuthi yikuphi ukuphambuka kwesikwele nokuthi yini ifomula ebukeka ngayo. Leli nani liyimpande yesikwele kusuka kunombolo ye-arithmetic ephakathi yezigcawu yomehluko phakathi kwawo wonke amanani emugqa kanye ne-arithmetic yawo emaphakathi. Kunegama elifanayo lale nkomba - ukuphambuka okujwayelekile. Womabili la magama alingana ngokuphelele.

Kepha, kungokwemvelo ukuthi ku-Valale umsebenzisi akufanele aphathe ngakho, njengoba kwenza uhlelo kuye. Ake sibheke ukuthi ungabala kanjani ukuphambuka okujwayelekile ku-Excel.

Ukubalwa kwe-Excel

Kungenzeka ukubala inani elicacisiwe ku-Pevule usebenzisa imisebenzi emibili ekhethekile ye-stomptotclonal. In (ngokuqokwa okukhethiwe) ne-stomplonal.g (ngokusho kwabantu jikelele). Umgomo wesenzo sawo ufana impela, kepha angabizwa ngezindlela ezintathu esizoxoxa ngazo ngezansi.

Indlela 1: I-Master of Imisebenzi

1. Khetha iseli ephepheni lapho umphumela ophelile uzokhonjiswa. Chofoza inkinobho ethi "Insert Function", etholakala ngakwesokunxele sentambo yokusebenza.



2. Kuluhlu oluvula, irekhodi le-stomplona.v noma i-stomatclone.g. Uhlu luphinde lube nesici se-statotClone, kepha lishiywe kusuka ezinguqulweni zangaphambilini ze-Excel ngezinhloso zokuhambisana. Ngemuva kokuqoshwa kukhethiwe, chofoza inkinobho ethi "Kulungile".



3. Ukuphikisana nomsebenzi kuyavuleka. Ensimini ngayinye, sifaka inani lokuhlanganiswa. Uma izinombolo zisemaseli eshidi, khona-ke ungacacisa izixhumanisi zalawa maseli noma vele uchofoze kuzo. Amakheli azothinta masinyane amasimu ahambisanayo. Ngemuva kwayo yonke inani le-aggregate libhalwe phansi, chofoza inkinobho ethi "Kulungile".



4. Umphumela wokubala uzosuswa esitokisini esaqokonyiswa ekuqaleni kwenqubo yokuthola ukuphambuka okuphakathi nendawo.

Indlela 2: Ifomula Tab

Futhi ukubala inani lokuphambuka okujwayelekile ngethebhu "formula".

1. Siqokomisa iseli ukukhombisa umphumela bese iya kuthebhu "yefomula".



2. Ku- "Work Library Library" Toolbar, cindezela inkinobho ethi "Eminye Imisebenzi". Ukusuka ohlwini oluvelayo, khetha u- "Statistical". Kumenyu elandelayo, senza ukukhetha phakathi kwamanani we-Clone.V noma i-stomatClone ejwayelekile. Kuya ngokuthi isethi yokukhetha noma ejwayelekile ibamba iqhaza ekubaleni.



3. Ngemuva kwalokho, iwindi lokuphikisana liqalile. Zonke izenzo ezengeziwe kufanele zikhiqizwe ngendlela efanayo nakuhlobo lokuqala.

Indlela 3: ifomula elenziwe ngezandla

Kukhona futhi indlela lapho kungeke kudingeke khona ukubiza iwindi lengxabano. Ukuze wenze lokhu, faka ifomula ngesandla.

1. Sikhetha iseli ukukhipha umphumela futhi sinqume kulo noma ku-Line Formula Reject ngokuya ngethempulethi elandelayo:

   = Stoptotclonal.g (Inombolo1 (ikheli_chain1); Inombolo2 (ikheli_Chair2); ...)

   noma

   = I-stamptotclona.v (Inombolo1 (ikheli_Chaki1); Inombolo2 (ikheli_chain2); ...).

   Ingqikithi ingabhalwa uma kunesidingo sezingxabano ezingama-255.



2. Ngemuva kokuqoshwa kwenziwa, cindezela inkinobho ethi Faka kukhibhodi.

Isifundo: Sebenza ngamafomula ku-Excel

Njengoba sibona, indlela yokubala ukuphambuka okujwayelekile ku-Excel ilula kakhulu. Umsebenzisi udinga ukwethula izinombolo kuphela kusuka kusethi noma ireferensi kumaseli aqukethe. Zonke izibalo zenza uhlelo uqobo. Kunzima kakhulu ukubona ukuthi yini inkomba ebaliwe nokuthi imiphumela yokubala ingafakwa kanjani ekusebenzeni. Kepha ukuqonda kwalokhu sekuvele kusebenza kakhulu emkhakheni wezibalo kunokufundisa umsebenzi wesoftware.