I-arctangent ingena ochungechungeni lwezinkulumo ezingezansi ze-trigonometric. Iphikisana no-tangent. Njengawo wonke amanani afanayo, kubalwa kuma-radians. Ku-Excel kunomsebenzi okhethekile ovumela ukubalwa kwe-arctangent ngenombolo enikeziwe. Ake sibone ukuthi singasebenzisa kanjani lo opharetha.
Ibala inani le-arctangent
I-arctangent iyinkulumo ye-trigonometric. Kubalwa njenge-angle kuma-radians, okungafani okulinganayo nenani lempikiswano yama-arctangent.
Ukubala leli xabiso ku-Excel isetshenziswa opharetha ATANokufaka phakathi kweqembu lemisebenzi yezibalo. Ukuphikisana kwayo kuphela inombolo noma ukubhekisela kuseli eliqukethe inkulumo yenombolo. I-syntax ithatha leli fomu elilandelayo:
= ATAN (inombolo)
Indlela 1: umsebenzi wokufaka ngesandla
Kumsebenzisi onolwazi, ngenxa yokulula kwe-syntax yalo msebenzi, kulula futhi uyashesha ukuyifaka ngesandla.
- Khetha iseli lapho umphumela wokubala kufanele ube khona, bese ubhala ifomula yohlobo:
= ATAN (inombolo)Esikhundleni sezingxabano "Inombolo"Ngokwemvelo, sishintsha inani elithile lezinombolo. Ngakho i-arctangent yezine izobalwa ngefomula elandelayo:
= ATAN (4)Uma inani lezinombolo likhona esitokisini esithile, ingxabano yomsebenzi ingaba ikheli layo.
- Ukuze ubonise imiphumela yesibalo esibukweni, cindezela inkinobho Ngena.
Indlela 2: Ukubala Ukusebenzisa iWeb function
Kodwa kulabo abasebenzisi abangazange bafunde ngokugcwele amasu okufaka ngesandla amafomula noma asetshenziselwa ukusebenzisana nabo kuphela ngokusebenzisa isikhombimsebenzisi esibonakalayo, kufaneleka kakhulu ukwenza isibalo usebenzisa Amakhosi omsebenzi.
- Khetha iseli ukubonisa umphumela wokucubungula idatha. Sicindezela inkinobho "Faka umsebenzi"kufakwe ngakwesokunxele kwe-bar yefomula.
- Ukutholakala kwenzeka Amakhosi omsebenzi. Esikhathini "Isibalo" noma "Uhlu oluphelele lwe-alfabhethi" kufanele athole igama "ATAN". Ukuze uqalise ifasitela leziphakamiso, ukhethe bese uchofoza inkinobho. "Kulungile".
- Ngemva kokwenza izenzo ezicacisiwe, iwindi le-arguments arguments lizovula. Inensimu eyodwa kuphela - "Inombolo". Kuyo udinga ukungena inombolo, i-arctangent okufanele ibalwe. Emva kwalokho, chofoza inkinobho "Kulungile".
Futhi, njengengxabano ungasebenzisa ireferensi yeseli lapho le namba ikhona khona. Kulesi simo, kulula ukungena izixhumanisi ngesandla, kodwa ukubeka isikhombisi endaweni yasendle bese ukhetha nje isici lapho inani elifunayo elitholakala khona kushidi. Emva kwalezi zenzo, ikheli laleli seli likhonjiswa ewindini lezimangalo. Khona-ke, njengenguqulo yangaphambilini, chofoza inkinobho "Kulungile".
- Ngemva kokwenza izenzo ku-algorithm engenhla, ukubaluleka kwe-arctangent kuma-radians wenombolo ebekiwe kulo msebenzi kuzoboniswa kuseli elanduliwe.
Isifundo: I-Excel Function Wizard
Njengoba ungabona, ukuthola inombolo ye-arctangent ku-Excel akuyona inkinga. Lokhu kungenziwa ngokusebenzisa opharetha okhethekile. ATAN nge-syntax elula kakhulu. Le fomula ingasetshenziswa noma ukufaka ngesandla noma nge-interface. Amakhosi omsebenzi.
