Kuhle ntambama
Isikhathi eside asizange sibhale noma yikuphi okuthunyelwe kwi-Word ne-Excel kumakhasi ebhulogi. Futhi, cishe kungekudala, ngithole umbuzo othakazelisayo kusuka komunye wabafundi: "indlela yokukhipha impande ye-n-th phakathi kwe-Excel." Ngempela, njengoba ngikukhumbula, ku-Excel kunomsebenzi othi "IJAMBO", kodwa likhishwa kuphela impande yesikwele, uma udinga impande yanoma iyiphi enye idijithali?
Futhi kanjalo ...
Ngendlela, izibonelo ezingezansi zizosebenza ku-Excel 2010-2013 (kwezinye izinguqulo angizange ngibheke umsebenzi wazo, futhi angikwazi ukusho ukuthi uzosebenza yini).
Njengoba kuyaziwa ngezibalo, impande yanoma yiliphi idijithi n lenombolo lizolingana nokucaciswa kwenombolo efanayo ngo-1 / n. Ukuze wenze lesi siqondiso siqonde, ngizokwenza isithombe esincane (bheka ngezansi).
Umsuka wezinga lesithathu le-27 ngu-3 (3 * 3 * 3 = 27).
Ku-Excel, ukukhulisa amandla kulula; ngoba lokhu, isithonjana esikhethekile sisetshenziswa. ^ ("ikhava", ngokuvamile lesi sithonjana sisekhiye "6" ekhibhodi).
Yebo ukukhipha impande ye-nth kwanoma iyiphi inombolo (isibonelo, kusuka ku-27), ifomula kufanele ibhalwe njengo:
=27^(1/3)
lapho kukhona inombolo engu-27 esivela kuyo impande;
I-3 - degree.
Isibonelo somsebenzi ngezansi ku-skrini.
Umsuka wesi-4 we-16 u-2 (2 * 2 * 2 * 2 = 16).
Ngendlela, i-degree ingaqoshwa ngokushesha njengenombolo yedesimali. Isibonelo, esikhundleni se-1/4, ungabhala u-0.25, umphumela uzofana, futhi ukubonakala kuphakeme (kubalulekile amafomula amade kanye nezibalo ezinkulu).
Yilokho, umsebenzi ophumelelayo ku-Excel ...
