Kuchotsa mizu kuchokera ku nambala ndi ntchito yovomerezeka ya masamu. Amagwiritsidwa ntchito pa zowerengera zosiyanasiyana m'matawuni. Mu Microsoft Excel, pali njira zambiri zowerengera mtengowu. Tiyeni tifufuze njira zosiyanasiyana zomwe tingagwiritse ntchito pulogalamuyi.
Njira Zowonjezereka
Pali njira zazikulu ziwiri zowerengera chizindikiro ichi. Mmodzi wa iwo ali woyenera kokha kuwerengera mizu yachitsulo, ndipo yachiwiri angagwiritsidwe ntchito kuwerengera mtengo wa digiri iliyonse.
Njira 1: Gwiritsani ntchito ntchitoyi
Kuti muchotse mizu yachitsulo ntchitoyi, yomwe imatchedwa ROOT. Mawu ake omasulira ndi awa:
= ROOT (nambala)
Kuti mugwiritse ntchito njirayi, zatha kulemba mawuwa mu selo kapena ntchito ya pulogalamu, m'malo mwa mawu akuti "nambala" ndi nambala yapadera kapena adiresi ya selo yomwe ilipo.
Kuti muwerenge ndikuwonetsa zotsatira pazenera, pindani batani ENTER.
Komanso, mungagwiritse ntchito fomuyi pogwiritsa ntchito ntchitoyi.
- Dinani pa selo pa pepala komwe zotsatira za mawerengedwe zidzawonetsedwa. Pitani ku batani "Ikani ntchito"inayikidwa pafupi ndi mzere wa ntchito.
- M'ndandanda yomwe imatsegula, sankhani chinthucho "ROOT". Dinani pa batani "Chabwino".
- Fesholo yotsutsana ikutsegula. M'malo amodzi pazenera ili, muyenera kulowa muyeso wapadera yomwe mzerewu udzachoke, kapena makonzedwe a selo yomwe ilipo. Ingolani pa selo ili kuti adiresi alowe mmunda. Atalowa deta, dinani pakani "Chabwino".
Zotsatira zake, zotsatira za ziwerengero zidzawonetsedwa mu selo lotchulidwa.
Mukhozanso kutcha ntchitoyo kudzera pa tabu "Maonekedwe".
- Sankhani selo kusonyeza zotsatira za kuwerengera. Pitani ku tab "Ma formula".
- Mu chidutswa cha zipangizo "Library of functions" pa ndodo dinani pa batani "Masamu". M'ndandanda imene ikuwonekera, sankhani mtengo "ROOT".
- Fesholo yotsutsana ikutsegula. Zochita zonse zofanana ndi zofanana ndi zomwe zikuchitika kudzera mu batani "Ikani ntchito".
Njira 2: kuwonetseratu
Sungani mzere wa cube pogwiritsa ntchito chithunzichi sichithandiza. Pachifukwa ichi, mtengowo uyenera kukwezedwa ku digiti yachepa. Maonekedwe onse a chiwerengerochi ndi awa:
= (chiwerengero) ^ 1/3
Izi zikutanthauza kuti sizing'onozing'ono ayi, koma kukulitsa mtengo kwa 1/3 mphamvu. Koma digiri iyi ndi mizu ya cubic, motero ndizochitika mu Excel zomwe zimagwiritsidwa ntchito kuti zipeze. Mu chidule ichi, m'malo mwa nambala yeniyeni, mutha kulowa nawo makonzedwe a selo ndi deta yamtundu. Zolembazo zapangidwa kumalo alionse a pepala kapena mu bar.
Musaganize kuti njira iyi ingagwiritsidwe ntchito kuchotsa mizu ya cube kuchokera ku nambala. Momwemonso mungathe kuwerengera mizere ndi mizu ina iliyonse. Koma pokhapokha mufunikira izi kugwiritsa ntchito njira yotsatirayi:
= (chiwerengero) ^ 1 / n
n ndi mlingo wa erection.
Choncho, njirayi ndi yochuluka kwambiri kuposa kugwiritsa ntchito njira yoyamba.
Monga momwe mukuonera, ngakhale kuti mu Excel palibe ntchito yapadera yochotsera mizu ya cubic, izi zikhoza kuchitika pogwiritsa ntchito erection mu digiti, yomwe ndi 1/3. Kuti muchotse mizu yapafupi, mungagwiritse ntchito ntchito yapadera, koma palinso mwayi wochita izi mwa kukweza nambala ku mphamvu. Panthawi ino, idzafunika kukwezedwa ku mphamvu ya 1/2. Wogwiritsa ntchitoyo mwiniyo ayenera kudziwa njira yodziwerengera yomwe ili yabwino kwa iye.
