Madzulo abwino
Nthawi yaitali sinalembedwe mndandanda pa Mawu ndi Excel pamasamba a blog. Ndipo, posakhalitsa kale, ndinalandira funso lochititsa chidwi kwambiri kuchokera kwa mmodzi wa owerenga: "momwe angatulutsire mizu ya n-th pakati pa Excel." Inde, monga momwe ndimakumbukira, mu Excel pali ntchito "ROOT", koma imatulutsa mizere yokha, ngati mukufuna mizu ya digiri ina iliyonse?
Ndipo kotero ...
Mwa njirayi, zitsanzo zotsatirazi zigwira ntchito mu Excel 2010-2013 (mwazinthu zina zomwe sindinayang'ane ntchito yawo, ndipo sindingathe kunena ngati zigwira ntchito).
Monga momwe akudziwira kuchokera ku masamu, muzu wa digirii iliyonse n ya nambala idzakhala yofanana ndi kufotokoza kwa chiwerengero chomwecho ndi 1 / n. Kuti ndiwone bwino lamuloli, ndipereka chithunzi chaching'ono (onani m'munsimu).
Muzu wa digiri yachitatu ya 27 ndi 3 (3 * 3 * 3 = 27).
Mu Excel, kukulitsa mphamvu ndi kophweka; chifukwa ichi, chithunzi chapadera chimagwiritsidwa ntchito. ^ ("chivundikiro", kawirikawiri chithunzichi chili pa "6" fungulo pa kibokosi).
I kuti achotse nthiti ya nambala iliyonse (mwachitsanzo, kuchokera pa 27), chiwerengerocho chiyenera kulembedwa monga:
=27^(1/3)
kumene 27 ndi chiwerengero chimene timachotsa muzu;
3 - digiri.
Chitsanzo cha ntchito yomwe ili pansipa mu skrini.
Mzu wa 4 wa 16 ndi 2 (2 * 2 * 2 * 2 = 16).
Mwa njira, digiri ikhoza kulembedwa nthawi yomweyo ngati nambala ya chiwerengero. Mwachitsanzo, mmalo mwa 1/4, mukhoza kulemba 0.25, zotsatira zake zidzakhala chimodzimodzi, ndipo kuwonekeratu ndikokwera (zofunikira ma formula ambiri ndi ziwerengero zazikulu).
Ndizo zonse, ntchito yopambana mu Excel ...
