Sida loo xisaabiyo xidid ee "Eksele"?

Barnaamijka Microsoft Excel leedahay qani ku ah hawlaha. Waxaad u isticmaali kartaa si loo soo saaro tiro ka mid ah xisaabta kala duwan. Si kastaba ha ahaatee, haddii mabda'a leh falalka fudud ay fahmi karaan ugu, sida loo xisaabiyo xididka "Eksele" shaqeeya ma oga oo dhan.

"Root" function

Siyaabaha loo xisaabiyo xididka laba jibbaaran ee "Eksele" yar, iyo ugu haboon iyaga ka mid ah - isticmaali shaqada gaarka ah ee "xididka", hirgeliyo barnaamijka. Waayo, waxaa lagama maarmaan ah inuu u soo yeedho in gacanta laftiisa ama bar formula in ay diiwaan ay Saan, ama guji ah "Function Insert" badhanka.

Marka xulashada habka ugu horeysay, unugyada in la diiwaan geliyo "= SQRT (X)", halkaas oo halkii "X" waa in tiro ka mid ah ama gacanta ku haysta qiimaha tirsi, asalka u ah oo ay tahay in laga helo. In kiiska labaad, ka dib markii riixaya "Function Insert" button waa lagama maarmaan in ay qoraan duurka search "xidid" iyo dooran function la soo jeediyay. Tani furi doonaa daaqad in la bixiyaa sidoo kale in ay iska diiwaan tirada gacanta, ama dooro gacanta ay ku jiraan tirada loo baahan yahay.

trick xisaabeed

Si kastaba ha ahaatee, marka hawsha ay tahay si ay u xisaabiso xididka "Eksele" had iyo jeer ma macnaheedu waa square ah. Si loo xisaabiyo xididka darajo kasta waa in ay isticmaalaan hab kale - isticmaalka xidid macnaha xisaabta. Marka la qeexo, qiimaha xidid n-Hydrochloric xadka - tirada ay tahay in si n xoogga la sara kicin, si loo helo hadal ah oo ka yar yahay xididka.

Sidaas darteed, si aad u hesho qiimaha xididka ah degree n-Hydrochloric ku filan si ay u simanahay aniga tiro ka mid ah degree-bedelka - 1 / n. Si loo xisaabiyo xididka "Eksele" sidan, waxa kale oo aad isticmaali kartaa mid ka mid ah xalal suurto gal ah algorithms. The ugu horeysay oo ka mid ah waa in la isticmaalo shaqada, kii labaadna wuxuu ahaa - in tilmaamaha cad ficilka.

By gujinaya "Function Insert" button, waa in aad ku qor "degree" sanduuqa raadinta iyo dooro ikhtiyaarka ku haboon. Daaqadda in furay, waxaa jiri doona laba beeraha - First aad u baahan tahay si ay u sheeg tirada, iyo tan labaad - ilaa xadka ay tahay in loo sara kiciyey. Si aad u sheeg cad exponentiation waa in ay isticmaalaan "^" qof, waxaana ku xiga heerka. Waxaa xusid mudan in ay dhacdo awood jajab, waa in aad soo raacinaysaa in qaansada ku si aad u hesho natiijo sax ah. Sayidka, xisaabinta xididka laba jibbaaran in la diiwaan-dhismeedka foomka: x ^ (1/2).