Sawubona ntambama
Isikhathi eside angizange ngibhale noma yikuphi okuthunyelwe kwi-Word ne-Excel kumakhasi ebhulogi. Futhi manje, muva nje, ngithole umbuzo othokozisayo kusuka komunye wabafundi: "ukukhipha kanjani impande ye-nth degree kunombolo e-Excel." Impela, engikukhumbulayo, i-Excel inomsebenzi we- "ROOT", kepha ikhipha kuphela impande yesikwele, uma udinga impande yanoma iliphi elinye degree?
Futhi ...
Ngale ndlela, izibonelo ezingezansi zizosebenza ku-Excel 2010-2013 (angizange ngihlole umsebenzi wabo kwezinye izinguqulo, futhi angikwazi ukusho ukuthi kuzosebenza).
Njengoba kwaziwa kusuka ku-mathematics, impande yanoma iyiphi i-degree n yenombolo izolingana nokukhuphukela kumandla enombolo efanayo ngo-1 / n. Ukuze ngicace kahle lo mthetho, ngizokunikeza isithombe esincane (bheka ngezansi).
Impande yesithathu ka-27 ngu-3 (3 * 3 * 3 = 27).
Ku-Excel, ukukhulisa amandla kulula kakhulu, ngoba kusetshenziswa isithonjana esikhethekile ^ ("Ikhava", imvamisa isithombe esinjalo sitholakala kukhiye we "6").
Mina. ukukhipha izimpande ze-nth degree kunoma iyiphi inombolo (ngokwesibonelo, kusuka ku-27), ifomula kufanele ibhalwe kanjena:
=27^(1/3)
lapho i-27 iyinombolo esikhipha kuyo impande;
3 - degree.
Isibonelo somsebenzi ngezansi eskrinini.
![](http://img.eifeg.com/img/pcpr-2019/9706/excel-2010-2013-2.jpg)
Impande ye-4th degree out of 16 is 2 (2 * 2 * 2 * 2 = 16).
Ngendlela, idigri nayo ingabhalwa ngokushesha ngendlela yenombolo yedesimali. Isibonelo, esikhundleni se-1/4, ungabhala u-0.25, umphumela uzofana, kepha ukubonakala kuphakeme (kufanele amafomula amade nokubalwa okukhulu).
Yilokho, umsebenzi omuhle e-Excel ...