I-Excel TAN Umsebenzi: Thola i-Tangent ye-Angle

Umsebenzi we-trigonometric, njenge -sine ne -cosine , usekelwe kunxantathu elungile (inxantathu ene-angle elingana nama-degree angu-90) njengoba kuboniswe esithombeni ngenhla.

Esiklasini sezibalo, i-tangent ye-angle ingatholakala ngokusebenzisa ubude obuqhathanisa ubude ohlangothini olubhekene ne-angle (o) ubude behlangothini eduze kwe-angle (a).

Ifomula yalesi isilinganiso ingabhalwa:

I-Tan Θ = o / a

lapho i-Θ iyingqayizivele yocingo elicatshangelwayo (45o kulesi sibonelo)

E-Excel, ukuthola i-angle yesikhala kungenziwa lula ngokusebenzisa umsebenzi we-TAN wezingalo ezilinganiselwe kuma- radians .

01 ka 05

Ama-Degrees vs. Radians

Ukusebenzisa umsebenzi we-TAN ukuthola i-angle ye-angle kungase kube lula kunokukwenza ngesandla, kodwa, njengoba kubonisiwe, i-angle idinga ukuba kuma- radians kunama- degree - okuyinto iningi lethu engazijwayele.

AmaRussia ahlobene nengqikithi yombuthano ngenye ye-radian esilingana nokulingana nama-57 degrees.

Ukuze wenze kube lula ukusebenza neminye imisebenzi ye-TAN kanye ne-Excel, sebenzisa umsebenzi we-RADIANS we-Excel ukuguqula i-engeni elinganiswa ukusuka kumadireyi kuya kuma-radians njengoba kuboniswe esitokisini B2 esithombeni ngenhla lapho i-angle yama-45 degrees iguqulwa ibe yi-radian 0.785398163.

Okunye okukhethwa kukho ukuguqula kusuka kumadiresi kuya kuma-radians kufaka:

• Ukwakha umsebenzi we-RADIANS ngaphakathi komsebenzi we-TAN - njengoba kuboniswe kulayini 3 kusibonelo;
• usebenzisa umsebenzi we-Excel we- PI kwifomula: i- angle (degrees) * PI () / 180 njengoba kuboniswe kulayini 4 kusibonelo.

02 ka 05

I-syntax ne-Arguments ye-TAN yomsebenzi

I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi , amabakaki, nokuphikisana .

I-syntax yomsebenzi we-TAN yile:

= I-TAN (Inombolo)

Inombolo - (edingekayo) i-angle ibalwa - kulinganiswa kuma-radians;
- ubukhulu be-angle kuma-radians bungangeniswa kule mpikiswano noma, ngokunye, ukubhekisela kweseli endaweni yale datha kushidi lokusebenzela .

Isibonelo: Ukusebenzisa i-TAN Umsebenzi we-Excel

Lesi sibonelo sihlanganisa izinyathelo ezisetshenziselwa ukufaka umsebenzi we-TAN esitokisini C2 esithombeni ngenhla ukuze uthole i-tangent engama-45 degree noma ama-radians angu-0.785398163.

Izinketho zokufaka umsebenzi we-TAN zifaka ukuthayipha ngesandla kuyo yonke imisebenzi = TAN (B2) , noma usebenzisa ibhokisi lengxoxo lomsebenzi - njengoba kuchazwe ngezansi.

03 ka 05

Ukufaka umsebenzi we-TAN

1. Chofoza kuseli C2 kushidi lokusebenzela ukuze wenze iseli elisebenzayo ;
2. Chofoza kuthebhu yefomula yemenyu ye- Ribbon ;
3. Khetha i- Math & Trig kusuka ku-riboni ukuvula uhlu lokudonsa phansi;
4. Chofoza ku- TAN kuhlu ukuze ukhiphe ibhokisi lengxoxo lomsebenzi;
5. Ebhokisini lengxoxo, chofoza kulayini lombhalo;
6. Chofoza kuseli B2 kusikripthi sokusebenzela ukufaka lelo referensi yeseli kufomula;
7. Chofoza u-Kulungile ukuqedela ifomu bese ubuyela ekhasini lokusebenzela;
8. Impendulo 1 kufanele ibonakale esitokisini C2 - okuyiyona engxenyeni engama-45 degree angle;
9. Uma uchofoza ku-cell C2 umsebenzi ophelele = I-TAN (B2) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela.

04 ka 05

#VALUE! Amaphutha kanye Nemiphumela Yelikhanda Elibukhali

Umsebenzi we-TAN ubonisa i- #VALUE! iphutha uma ireferensi esetshenziselwa ukuphikisana komsebenzi ikhomba iseli eliqukethe idatha yombhalo - umugqa wesihlanu wesibonelo lapho ireferensi yeseli esetshenzisiwe isebenzisa ilebula yombhalo: i- Angle (amaRudiya);

Uma iseli likhomba esitokisini esingenalutho, lo msebenzi ubuyisela inani elilodwa - irowu eyisithupha ngenhla. Imisebenzi ye-Excel ye-trig ihumusha amangqamuzana angenalutho njenge-zero, futhi i-radiant zero radians ilingana nenye.

05 ka 05

Ukusetshenziswa kwe-Trigonometric ku-Excel

I-Trigonometry igxile ebuhlotsheni phakathi kwezinhlangothi nezinhlangothi zontathu, futhi nakuba abaningi bethu kungadingeki bayisebenzise nsuku zonke, i-trigonometry inezinhlelo zokusebenza ezinkambu eziningi ezibandakanya izakhiwo, i-physics, ubunjiniyela, nokuhlola.

Abacwaningi, isibonelo sebenzisa i-trigonometry ngezibalo ezibandakanya ukushisa kwelanga, umthwalo wesakhiwo, kanye nemithambeka yephahla.