Ana cire tushen daga lamba yana aiki ne na ilmin lissafi. An yi amfani da shi don ƙididdiga daban a cikin tebur. A cikin Microsoft Excel, akwai hanyoyi da dama don lissafta wannan darajar. Bari mu dubi wasu zaɓuɓɓuka daban-daban don aiwatar da wannan lissafi a cikin wannan shirin.
Hanyar haɓaka
Akwai hanyoyi guda biyu don lissafta wannan alamar. Ɗaya daga cikin su ya dace kawai don ƙididdige tushen tushen, kuma na biyu za'a iya amfani dashi don ƙididdige darajar kowane digiri.
Hanyar 1: amfani da aikin
Don cire fitar da aikin tushen wuri na tushen, wanda ake kira ROOT. Sakamakonsa kamar haka:
= Ginin (lambar)
Domin yin amfani da wannan zaɓi, ya isa ya rubuta wannan magana a cikin tantanin halitta ko a cikin wani aikin aiki na shirin, ya maye gurbin kalmar "lambar" tare da takamaiman lambar ko adireshin cell inda aka samo shi.
Don yin lissafi kuma nuna sakamakon akan allon, danna maballin Shigar.
Bugu da ƙari, za ka iya amfani da wannan mahimman ta hanyar ayyuka masu mahimmanci.
- Danna kan tantanin halitta akan takardar da za a nuna sakamakon sakamakon. Je zuwa maɓallin "Saka aiki"sanya kusa da aiki line.
- A cikin jerin da ya buɗe, zaɓi abu "Akidar". Danna maballin "Ok".
- Maganin gardama ya buɗe. A cikin filin guda ɗaya na wannan taga, kana buƙatar shigar ko dai wani ƙimar da za a iya cire shi, ko kuma haɓakaccen tantanin halitta inda aka samo shi. Kawai danna kan wannan tantanin halitta don an shigar da adireshin a cikin filin. Bayan shigar da bayanai danna maballin "Ok".
A sakamakon haka, sakamakon lissafi za'a nuna a cikin tantanin da aka nuna.
Hakanan zaka iya kiran aikin ta hanyar shafin "Formulas".
- Zaɓi tantanin halitta don nuna sakamakon sakamakon lissafi. Jeka shafin "Formulas".
- A cikin asalin kayan aiki "Makarantar ayyuka" a kan rubutun kalmomi a kan maballin "Ilmin lissafi". A cikin jerin da aka bayyana, zaɓi darajar "Akidar".
- Maganin gardama ya buɗe. Dukkan ayyukan da aka yi daidai daidai ne da aikin ta hanyar maɓallin "Saka aiki".
Hanyar 2: bayyanawa
Ƙididdige tushen jakar cube ta amfani da abin da ke sama ba ya taimaka. A wannan yanayin, dole ne a ɗaukaka darajar zuwa digiri na kashi. Babban nau'i na ma'anar lissafi kamar haka:
= (lambar) ^ 1/3
Wato, a bisa mahimmanci ba ma wani hakar ba, amma ƙaddamar da darajar ga ikon 1/3. Amma wannan digiri ne tushen tushe, don haka daidai ne irin wannan aiki a cikin Excel wanda ake amfani dasu don samun shi. A cikin wannan tsari, maimakon wani takamaiman lambar, zaka iya shigar da haɗin tantanin halitta tare da bayanan lambobi. Ana yin rikodin a kowane yanki na takardar ko a cikin tsari.
Kada ka yi tunanin cewa wannan hanya za a iya amfani dashi kawai don cire tushen jigilar daga lamba. Haka kuma za ku iya lissafin square da kowane tushen. Amma kawai a wannan yanayin ya zama wajibi ne don amfani da wannan tsari:
= (lambar) ^ 1 / n
n shine mataki na erection.
Saboda haka, wannan zaɓin ya fi duniya fiye da yin amfani da hanyar farko.
Kamar yadda kake gani, duk da gaskiyar cewa a Excel babu wani aikin musamman don cire tushen tushe, wannan lissafi za a iya aiwatar da shi ta yin amfani da kafa a cikin digiri na kashi, wato, 1/3. Don cire tushen tushe, zaka iya amfani da aiki na musamman, amma akwai yiwuwar yin wannan ta hanyar tayar da lambar zuwa ikon. A wannan lokaci, za a buƙatar ɗaukar ƙarfin 1/2. Mai amfani da kanta dole ne ya ƙayyade wane hanyar lissafi ya fi dacewa da shi.
