Ukukhipha impande kusuka kwinombolo kuyinto yokusebenza ngezibalo ezivamile. Isetshenziselwa ukubalwa okuhlukahlukene kumatafula. Ku-Microsoft Excel, kunezindlela eziningana zokubala leli xabiso. Ake sibheke ngokucophelela izinketho ezehlukene zokusebenzisa lezi zibalo kuloluhlelo.
Izindlela zokukhipha
Kunezindlela ezimbili eziyinhloko zokubala le nkhomba. Omunye wabo ufanelekela kuphela ukubala izimpande zesikwele, kanti okwesibili kungasetshenziswa ukubala ukubaluleka kwanoma iyiphi idijithali.
Indlela 1: sebenzisa umsebenzi
Ukuze kukhishwe umsebenzi wezimpande zesikwele, okubizwa ngokuthi i-ROOT. I-syntax yayo ilandelayo:
= INQUBO (inombolo)
Ukuze usebenzise le ndlela, kwanele ukubhala le nkulumo esitokisini noma kumsebenzi womsebenzi, esikhundleni senkulumo "inombolo" ngenombolo ethize noma ikheli leseli lapho litholakala khona.
Ukuze wenze isibalo futhi ubonise umphumela esibukweni, cindezela inkinobho ENTER.
Ngaphezu kwalokho, ungasebenzisa le fomula ngokusebenzisa imisebenzi enhle.
- Chofoza kuseli kushidi lapho imiphumela yokubala izoboniswa khona. Yiya kunkinobho "Faka umsebenzi"kufakwe eduze komsebenzi womsebenzi.
- Kulolu hlu oluvula, khetha into "INHLOSI". Chofoza inkinobho "Kulungile".
- Iwindi lempikiswano ivuleka. Emkhakheni owodwa wale window, udinga ukungena noma inani elithile lapho lesi sizinda sizokwenzeka khona, noma izixhumanisi zeseli lapho itholakala khona. Vele uchofoze kule seli ukuze ikheli layo lifakwe ensimini. Ngemva kokufaka idatha yokuchofoza inkinobho "Kulungile".
Ngenxa yalokho, umphumela wezibalo uzoboniswa kuseli elibonisiwe.
Ungase futhi ubize umsebenzi ngokusebenzisa ithebhu "Amafomula".
- Khetha iseli ukubonisa umphumela wokubala. Iya kuthebhu "Amafomula".
- Esikhathini samathuluzi "I-Library of imisebenzi" ku-Ribbon chofoza inkinobho "Isibalo". Kulolu hlu oluvela, khetha inani "INHLOSI".
- Iwindi lempikiswano ivuleka. Zonke izenzo ezengeziwe zifana ncamashi nesenzo ngokusebenzisa inkinobho "Faka umsebenzi".
Indlela yesi-2: i-exponentiation
Bala umcibisholo we-cube usebenzisa okukhethwa ngenhla akusizi. Kule nkinga, inani kufanele liphakanyiswe kumkhawulo wezinhlamvu. Ifomu elijwayelekile lefomula yesibalo kanje:
= (inombolo) ^ 1/3
Okungukuthi, ngokoqobo akuyona ngisho isizinda, kodwa ukuphakanyiswa kwexabiso kumandla we-1/3. Kodwa lelizinga liyizimpande ze-cubic, ngakho-ke isenzo esinjalo ku-Excel esetshenziselwa ukuyithola. Kule fomula, esikhundleni senombolo ethile, ungaphinda ufake izixhumanisi zeseli ngemininingwane yenombolo. Irekhodi lenziwa kunoma iyiphi indawo yeshidi noma kwibha yefomula.
Ungacabangi ukuthi le ndlela ingasetshenziswa kuphela ukukhipha impande ye-cube kusuka kwinombolo. Ngendlela efanayo ungakwazi ukubala isikwele nenye enye impande. Kodwa kule ndaba kuphela kubalulekile ukusebenzisa ifomula elandelayo:
= (inombolo) ^ 1 / n
n yiyona degree of erection.
Ngakho-ke, le nketho ingaphezu kwendawo yonke kunokusebenzisa indlela yokuqala.
Njengoba ungabona, naphezu kokuthi ku-Excel akukho msebenzi okhethekile wokukhipha impande ye-cubic, lokhu kubalwa kungenziwa ngokusebenzisa i-erection ngezinga elincane, okungukuthi, 1/3. Ukukhipha impande yesikwele, ungasebenzisa umsebenzi okhethekile, kodwa futhi kungenzeka ukuthi wenze lokhu ngokukhulisa inombolo emandleni. Ngalesi sikhathi, kuzodingeka kuphakanyiswe emandleni we-1/2. Umsebenzisi ngokwakhe kufanele anqume ukuthi iyiphi indlela yokubala elula kakhulu kuye.
