Umsebenzi we-ATAN (arctangent) ku-Excel

I-Arctangent umsebenzi we-trigonometric ophambene ne-tangent, osetshenziswa kusayensi eqondile. Njengoba sazi, ku-Excel asikwazi ukusebenza ngamaspredishithi kuphela, kodwa futhi senze izibalo - kusukela kokulula kuya kokuyinkimbinkimbi kakhulu. Ake sibone ukuthi uhlelo lungabala kanjani i-arc tangent enanini elinikeziwe.

Sibala i-arc tangent

I-Excel inomsebenzi okhethekile (opharetha) obizwa ngokuthi "ATAN", okukuvumela ukuthi ufunde i-arc tangent kuma-radians. I-syntax yayo evamile ibukeka kanje:

=ATAN(inombolo)

Njengoba sibona, umsebenzi unokuphikisana okukodwa kuphela. Ungayisebenzisa ngezindlela ezahlukene.

Indlela yoku-1: Ukufaka ifomula mathupha

Abasebenzisi abaningi abavame ukwenza izibalo zezibalo, okuhlanganisa ne-trigonometric, bagcina bebambe ngekhanda ifomula yomsebenzi futhi bayifake mathupha. Nansi indlela okwenziwa ngayo:

1. Sisukuma esitokisini lapho sifuna ukwenza khona izibalo. Bese sifaka ifomula kusuka kukhibhodi, esikhundleni sempikiswano sicacisa inani elithile. Ungakhohlwa ukubeka uphawu "okulingana" ngaphambi kwenkulumo. Ngokwesibonelo, esimweni sethu, makube njalo “I-ATAN(4,5)”.
2. Uma ifomula isilungile, chofoza Fakaukuthola umphumela.

amanothi

1. Esikhundleni senombolo, singacacisa isixhumanisi kwelinye iseli eliqukethe inani lenombolo. Ngaphezu kwalokho, ikheli lingafakwa ngesandla, noma mane uchofoze kuseli oyifunayo kuthebula ngokwalo.

Lolu khetho lungcono kakhulu ngoba lungasetshenziswa kukholomu yezinombolo. Isibonelo, faka ifomula yenani lokuqala emugqeni ohambisanayo, bese ucindezela Fakaukuthola umphumela. Ngemva kwalokho, hambisa ikhesa ekhoneni elingezansi kwesokudla seseli ngomphumela, futhi ngemva kokuvela kwesiphambano esimnyama, cindezela inkinobho yegundane kwesokunxele bese uhudulela phansi kuseli eligcwele eliphansi kakhulu.

Ngokukhulula inkinobho yegundane, sithola ukubala okuzenzakalelayo kwe-arc tangent yayo yonke idatha yokuqala.

2. Futhi, esikhundleni sokufaka umsebenzi esitokisini ngokwawo, ungakwenza ngokuqondile kubha yefomula - vele uchofoze ngaphakathi kuyo ukuze uqale imodi yokuhlela, ngemva kwalokho sifaka inkulumo edingekayo. Uma usulungile, njengokujwayelekile, cindezela Faka.

Indlela 2: Sebenzisa Isilekeleli Somsebenzi

Le ndlela yinhle ngoba awudingi ukukhumbula lutho. Into esemqoka ukukwazi ukusebenzisa umsizi okhethekile owakhiwe ohlelweni.

1. Sivuka esitokisini ofuna ukuthola umphumela kuso. Bese uchofoza isithonjana "Fx" (Faka Umsebenzi) kwesokunxele sebha yefomula.
2. Iwindi lizovela esikrinini. Umsebenzi Wizards. Lapha sikhetha isigaba “Uhlu oluphelele lwama-alfabhethi” (noma "Izibalo"), uskrola ohlwini lwabasebenzisi, maka "ATAN", bese ucindezela OK.
3. Kuzovela iwindi lokugcwalisa ukuphikisana komsebenzi. Lapha sicacisa inani lezinombolo bese sicindezela OK.Njengasendabeni yokufaka ifomula ngesandla, esikhundleni senombolo ethile, singacacisa isixhumanisi seseli (siyifaka mathupha noma siyichofoze etafuleni ngokwalo).
4. Sithola umphumela kuseli elinomsebenzi.

Qaphela:

Ukuguqula umphumela otholwe kuma-radians ube amadigri, ungasebenzisa umsebenzi "AMADREGRE". Ukusetshenziswa kwayo kufana nendlela esetshenziswa ngayo "ATAN".

Isiphetho

Ngakho-ke, ungathola i-arc tangent yenombolo ku-Excel usebenzisa umsebenzi okhethekile we-ATAN, ifomula yawo engafakwa ngokushesha ngesandla kuseli oyifunayo. Enye indlela ukusebenzisa i-Function Wizard ekhethekile, lapho kungadingeki sikhumbule ifomula.