Yadda za a lissafta tushen a cikin exale

Anonim

Ana cire tushen a Microsoft Excel

Ana cire tushen daga cikin abin da ya dace da aikin lissafi. Ya dace da lissafin daban-daban a cikin tebur. Microsoft Excel yana da hanyoyi da yawa don lissafta wannan darajar. Bari muyi la'akari daki daki daban daban na irin wannan lissafin a cikin wannan shirin.

Hanyar hakar

Akwai hanyoyi guda biyu na asali don yin lissafin wannan mai nuna alama. Ofayansu ya dace da keɓance don yin lissafin tushen murabba'i, kuma ana iya amfani da na biyu don ƙididdige darajar kowane irin.

Hanyar 1: aikin aikace-aikacen

Domin cire tushen murabba'i, ana amfani da aikin, wanda ake kira tushen. Syntax ta yi kama da wannan:

= Tushen (lamba)

Don amfani da wannan zabin, ya isa ya rubuta wa tantanin halitta ko a cikin shirin zane na shirin wannan magana, maye gurbin kalmar "lambar" zuwa takamaiman lamba ko adireshin tantanin halitta inda yake.

Tushen aiki a Microsoft Excel

Don aiwatar da lissafi da fitarwa na sakamakon akan allon, danna maɓallin Shigar.

Sakamakon lissafin da tushe a cikin Microsoft Excel

Bugu da kari, zaku iya amfani da wannan tsari ta hanyar Jagora na Master.

  1. Danna kan tantanin halitta a kan takardar a inda sakamakon lissafin za a bayyana. Ku shiga maɓallin "Manna aiki", sanya shi kusa da jere na ayyuka.
  2. Matsa zuwa ga Jagora na Ayyuka a Microsoft Excel

  3. A cikin jerin da ke buɗe, zaɓi tushen abun. Latsa maɓallin "Ok".
  4. Je zuwa yanayin tushe a Microsoft Excel

  5. Tagan taga yana buɗe. A cikin filin wannan taga, kuna buƙatar shigar da takamaiman darajar ta hanyar da za a fitar da shi ko kuma daidaitawar tantanin halitta inda yake. Ya isa ya danna kan wannan tantanin don adireshinsa ya shiga cikin filin. Bayan shigar da bayanai, danna maɓallin "Ok".

Ofifent muhawara na OCO na ayyuka a Microsoft Excel

A sakamakon haka, sakamakon lissafin za a nuna a cikin tantanin halitta da aka ƙayyade.

Sakamakon lissafin tushen a Microsoft Excel

Hakanan, ana iya kiran aikin ta hanyar "dabara" shafin.

  1. Zaɓi tantanin halitta don nuna sakamakon lissafin. Je zuwa shafin "tsari".
  2. Canji zuwa shafin Forful a Microsoft Excel

  3. A cikin "ɗakin karatu" kayan aiki "kayan aiki akan tef ɗin danna maɓallin" lissafi ". A cikin jerin da suka bayyana, zaɓi darajar "tushen".
  4. Kira tushen tsari a Microsoft Excel

  5. Tagan taga yana buɗe. Dukkanin ayyukan da suke da daidai daidai yake da a ƙarƙashin aiki ta hanyar "Maste Aikace".

Ayyukan gargajiya a Microsoft Excel

Hanyar 2: Kafa

Lissafta tushen cubic ta amfani da zaɓi na sama ba zai taimaka ba. A wannan yanayin, ana buƙatar gina girman girman digiri na digiri. Babban nau'in tsari na tsari don lissafi shine:

= (lamba) ^ 1/3

Ana cire tushen cubic a Microsoft Excel

Wato, ba shi da cirewa, amma gina ƙimar 1/3. Amma wannan matakin kuma tushen Cubic, sabili da haka, wannan matakin a Fim da aka fi amfani dashi don karba shi. Maimakon takamaiman lamba, yana kuma yiwuwa a shigar da daidaitawar sel tare da lambobin lambobi. An yi rikodin a kowane yanki na takardar ko a cikin tsarin dabara.

Ya kamata a yi tunanin cewa ana iya amfani da wannan hanyar kawai don cire tushen cubic daga cikin. Haka kuma, square da wani tushe za'a iya lissafta. Amma a wannan yanayin zai yi amfani da wannan tsari:

= (lamba) ^ 1 / n

n shine digiri na erection.

Square Tsibirin a Microsoft Excel

Don haka, wannan zaɓi yana da inganci sosai fiye da amfani da hanyar farko.

Kamar yadda muke gani, duk da cewa babu wani aiki na musamman da ya fi dacewa a cire tushen Cubic, ana iya aiwatar da lissafin wannan lissafin da ake amfani da shi ta amfani da ginin digiri na biyu, wato 1/3. Don cire tushen murabba'i, zaka iya amfani da aiki na musamman, amma akwai kuma dama ka yi wannan ta hanyar kafa lamba. A wannan lokacin kuna buƙatar fitar da shi zuwa 1/2. Mai amfani da kansa dole ne ya ƙayyade wanne hanyar ƙididdige ta fi dacewa da shi.

Kara karantawa