Masana abwino
Kwa nthawi yayitali sindinalembe chilichonse pa Mawu ndi Excel pamasamba a blog. Ndipo tsopano, posachedwa, ndalandira funso losangalatsa kuchokera kwa m'modzi wa owerenga: "momwe mungachotsere muzu wa degree degree kuchokera ku nambala ku Excel." Zowonadi, momwe ine ndikukumbukira, Excel ili ndi "ROOT" ntchito, koma imangoyendetsa muzu wapakati, ngati mukufuna muzu wa digiri ina iliyonse?
Ndipo ...
Mwa njira, zitsanzo pansipa zidzagwira ntchito ku Excel 2010-2013 (sindinayang'ane ntchito yawo m'mitundu ina, ndipo sindinganene ngati zidzagwira ntchito).
Monga zimadziwika kuyambira masamu, muzu wa mulingo uliwonse n wa manambala udzakhala wofanana pakukweza kumphamvu ya nambala imodzimodzi ndi 1 / n. Pofuna kumveketsa bwino lamuloli, ndikupereka chithunzi chaching'ono (onani pansipa).
Muzu wachitatu wa 27 ndi 3 (3 * 3 * 3 = 27).
Ku Excel, kukweza mphamvu ndikosavuta, chifukwa chithunzi chapadera chimagwiritsidwa ntchito ^ ("Chivundikiro", nthawi zambiri chithunzi chotere chimapezeka pa kiyi ya "6").
Ine.e. kuchotsa muzu wa gawo la nth kuchokera ku chiwerengero chilichonse (mwachitsanzo, kuchokera pa 27), fomulamu iyenera kulembedwa motere:
=27^(1/3)
komwe 27 ndi nambala yomwe timachotsa muzuwo;
3 - digiri.
Chitsanzo cha ntchito pansipa.
Muzu wa digiri ya 4 kuchokera 16 ndi 2 (2 * 2 * 2 * 2 = 16).
Mwa njira, digiriyo imatha kulembedwanso yomweyo ngati manambala owerengera. Mwachitsanzo, m'malo mwa 1/4, mutha kulemba 0.25, zotsatira zake zidzakhala zofanana, koma mawonekedwe akuwoneka bwino (amafunikira mawonekedwe amtali ndi kuwerengera kwakukulu).
Ndizo zonse, ntchito yabwino ku Excel ...
