Kanjani ukwakha eziningi ngezinga negative - izibonelo echaza Excel

Kusukela esikoleni sonke sazi umthetho mayelana Exponentiation: iyiphi inombolo ne exponent N kuwumphumela siphindaphindeka le nombolo ngokwalo inombolo N-uNowa izikhathi. Ngamanye amazwi, amandla 3 7 - 7 iyanda yi kathathu, okungukuthi 343. Omunye umthetho - ukwakhiwa kuyazisiza yini amandla iyunithi unika 0, kanye nokwakhiwa value negative kuwumphumela Exponentiation Ezivamile ukuthi kuyasiza yini ngisho, futhi umphumela ofanayo nge uphawu "lokususa", uma lingalingani.

Imithetho futhi sinikeze impendulo njengoba ukwakha inani amandla omubi. Ukuze wenze lokhu, udinga ukwakha ezivamile ngendlela oyifunayo Inani index module, bese ehlukanisa yi iyunithi.

Kusukela le mithetho kuba sobala ukuthi ukusebenza imisebenzi yangempela nasekubambeni inqwaba kuzodinga ukutholakala izindlela lobuchwepheshe. Manual ngizakwandisa azimisele ububanzi esiphezulu izinombolo kuze kufinyelele amabili noma amathathu, futhi izikhathi ayibi ngaphezu kuka ezintathu noma ezine. Lena ingasaphathwa iqiniso lokuthi omunye bese kuba ngolunye, ukwehlukana yi. Ngakho-ke, labo abanayo ngakwesokunene wokubala ekhethekile yesayensi, sizokubonisa indlela yokwakha eziningi ngezinga negative Excel.

Isixazululo ezinkingeni Excel

Ngezinkinga ngokuhamba imvume yokwakha Excel degree ikuvumela ukuthi usebenzise omunye ezimbili ongakhetha.

Eyokuqala - ukusebenzisa ifomula ngezimbobo uphawu "cap." Faka ulwazi olulandelayo lokusebenzela:

Ngendlela efanayo eyodwa ungazakhela value oyifunayo kunoma degree - negative, ayingxenye. Thina landela izinyathelo ngezansi bese uphendula umbuzo ukuthi ukukhulisa isibalo emandleni omubi. Ngokwesibonelo:

Ungaxoxa ku lesifanele ifomula = B2 ^ -C2.

Eyesibili inketho - ukusetshenziswa imisebenzi ngomumo eyenziwe "degree", ethola agumenti ezimbili saziso - inombolo nokukala. Ukuze uqale ukuyisebenzisa, kwanele kunoma iyiphi iseli khulula ukubeka uphawu "alinganayo" (=), okubonisa ekuqaleni ifomula, bese ufaka amagama angenhla. It uhlala ukukhetha amaseli ezimbili, kuhileleke nezinye izinkinga okuyinto ekusebenzeni (noma ucacise inombolo ethize ngesandla), bese ucindezela Faka. Ake sibheke ezinye izibonelo elula.

Njengoba ubona, akukho eziyinkimbinkimbi mayelana nendlela yokwakha inani amandla omubi, futhi ngokuvamile besebenzisa Excel. Phela, kusukela kulolu hlelo lokusebenza ingasetshenziswa njengenjwayelo phezu uphawu "cap" futhi elula ukugcina uhlelo esakhelwe ngaphakathi. Lena plus ocacile!

Udlulela izibonelo eziyinkimbinkimbi. Khumbula umthetho sendlela ukwakha izinombolo amandla omubi ngokwemvelo ayingxenye, ubone ukuthi le nkinga Kulula kakhulu ukuxazulula Excel.

exponents wamaqhuzu

Ngamafuphi nje, i-algorithm ukubala inani Inkomba wamaqhuzu esilandelayo.

1. Guqula ingxenye fraction ingxenyenamba njalo noma okungafanele.
2. Ukwakha izinombolo zethu in the numerator we ingxenyenamba etholwe zishintshe.
3. Kusukela umkhiqizo esisesigabeni esandulelayo izinombolo ukubala impande, nge ngalo mbandela wokuba leyo Inkomba Impande zihilela we ingxenyenamba etholwe isinyathelo sokuqala.

Uzovuma ukuthi ngisho nalapho eqhuba ngamaqembu amancane bese kukhishwa nezingxenyana efanele kungenzeka izibalo ezinjengalezi kungathatha isikhathi eside. Awu, lokho-Excel-spreadsheet akunandaba ukuthi bangaki futhi ngokwezinga elingakanani uqonde. Zama ukunquma ku-lokusebenzela Excel, isibonelo esilandelayo:

Ukusebenzisa imithetho ngenhla, ungabheka futhi uqiniseke ukuthi ukubala kwenziwa ngendlela efanele.

Ekupheleni kwalesi sihloko sethula ngesimo amatafula amafomula, futhi imiphumela ngezibonelo eziningana zezinguquko indlela yokwakha inani amandla negative, kanye izibonelo ezimbalwa zendlela yokuphatha ngezinombolo wamaqhuzu kanye degrees.

izibonelo Ithebula

Hlola i-Excel lokusebenzela Okulandelayo izibonelo lokusebenzela. Ukuze wenze izinto isebenze kahle, udinga ukusebenzisa isixhumanisi okuxubile uma ukopisha ifomula. Namathisela inombolo kukholomu equkethe inombolo esakhiwe kanye nenombolo line equkethe ingxenye. Ifomula yakho kumele ibukeke ifomu elilandelayo :. «= $ B4 ^ C $ 3"

Qaphela ukuthi izinombolo omuhle (ngisho non-inamba) kungabikho izinkinga nhlobo ibalwa izinkomba. Azikho izinkinga ne ukwakhiwa noma iziphi izinombolo lonke ukusebenza. Kodwa ukwakhiwa inombolo engenhle emandleni fraction esitolo ngawe iphutha, ngoba akunakwenzeka ukuba athobele imithetho ebalulwe ekuthomeni yethu mayelana nokwakhiwa izinombolo engemihle, ngoba silinganiso - sici kuphela yinombolo.