Umsebenzi we-trigonometric, njenge -sine kunye ne -cosine , isekelwe kunxantathu echanekileyo (inxantathu ene-angle elingana nama-90 degrees) njengoko kuboniswe kumfanekiso ongentla.
Kwiklasi yeemathematika, i-tangent yekona ingatholakala ngokusetyenziswa komlinganiselo ngokulinganisa ubude becala ngokubhekiselele kwinqanaba (o) ubude becala ecaleni kwinqanaba (a).
Umhlathi walo mlinganiselo ungabhalwa:
I-Tan Θ = o / a
apho u-Θ ubukhulu bekota ekuqwalaselweyo (45o kulo mzekelo)
Kwi-Excel, ukufumana i-angle ye angle kungenziwa lula ngokusebenzisa umsebenzi we-TAN ngeenglesa ezilinganiswe kuma- radians .
01 ngo 05
IziGanga kunye namaRadi
Ukusebenzisa umsebenzi we-TAN ukufumana i-angle yekona ingaba lula kunokuyenza ngokwenza ngesandla, kodwa, njengoko kuchaziwe, i-angle ifuna ukuba kuma- radians kunee- degrees- eyona yunithi ininzi esingaziwayo.
AmaRidiya anxulumene nomda weesangqa kunye ne-radian esilingana nokulingana nama-57 degrees.
Ukwenza kube lula ukusebenza kunye nezinye izinto ze-TAN kunye ne-Excel, sebenzisa umsebenzi we-RADIANS we-Excel ukuguqula i-angle ekulinganiselwe ukusuka kumadireyi ukuya kuma-radians njengoko kuboniswe kwiseli B2 kumfanekiso ongaphezulu apho i-angle ye-45 degrees iguqulwa ibe yi-radian 0.785398163.
Ezinye iinketho zokuguqula ukusuka kwiiyure ukuya kuma-radians ziquka:
- ukuhlalisa umsebenzi we-RADIANS ngaphakathi komsebenzi we-TAN - njengoko kuboniswe kumgca 3 kumzekelo;
- usebenzisa umsebenzi we-Excel we- PI kwifom: i- angle (degrees) * PI () / 180 njengoko kuboniswe kumgca 4 kumzekelo.
02 we 05
I-Syntax ne-Arguments ye-TAN
I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi , amabakethi kunye neengxabano .
I-syntax yomsebenzi we-TAN ngu:
= TAN (Inombolo)
Inani - (elifunekayo) i-angle ibalwa - ilinganiswe kuma-radians;
- ubungakanani bekota kuma-radians banokungeniswa kule ngxabano okanye, ngokukodwa, isalathisi yesalathisi kwindawo yolu datha kwiphepha lokusebenzela .
Umzekelo: Ukusebenzisa i-Excel TAN Function
Lo mzekelo ugubungela amanyathelo asetyenziswa ukufaka umsebenzi we-TAN kwiseli C2 kumfanekiso ongentla ukuze ufumane i-angle yangama-45 degree okanye i-radians engu-0.785398163.
Izinketho zokungena kwi-TAN umsebenzi zibandakanya ukuthayipha ngesandla kuyo yonke imisebenzi = TAN (B2) , okanye usebenzisa ibhokisi yencoko yencoko yomsebenzi - njengoko kuchazwe ngezantsi.
03 we 05
Ukufaka umsebenzi we-TAN
- Cofa kwiseli C2 kwiphepha lokusebenzela ukuze wenze iseli esebenzayo ;
- Cofa kwiThebhu yefomula yemenyu yebhondi ;
- Khetha i- Math & Trig kwi-ribbon ukuvula uluhlu lwehla lokuhla;
- Cofa kwi- TAN kuloluhlu ukukhupha ibhokisi yencoko yencoko yomsebenzi;
- Kwibhokisi yencoko, nqakraza kumgca weNombolo ;
- Cofa kwifowuni B2 kwiphepha lokusebenzela ukuze ufake loo fom yefom yefomula;
- Cofa u-OK ugcwalise ifomu uze ubuyele kwiphepha lokusebenzela;
- Impendulo 1 kufuneka ibonakale kwiselfowuni C2 - yinto engumlinganiselo wee-45 degree degree;
- Xa ucofa kwiseli C2 umsebenzi opheleleyo = TAN (B2) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela.
04 we 05
#VALUE! Iimpazamo kunye neziphumo zeeMbewu ezingenanto
Umsebenzi we-TAN ubonisa i- #VALUE! impazamo xa isalathiso esetyenziswe njengengxoxo yomsebenzi ibonisa iseli equkethe idatha yombhalo - umqolo wesihlanu umzekelo apho isalathisi esetyenzisiweyo isetyenzisiweyo kwibhile yombhalo: I- Angle (Radians);
Ukuba iseli likhomba kwisitenki esingenalutho, umsebenzi ubuyisela ixabiso lenye imitha emathandathu ngasentla. Imisebenzi ye-Excel ye-Trig isichaza iifentile ezingenanto njenge-zero, kwaye i-tangent ye-zero radians ilingana nelinye.
05 we 05
Ukusetyenziswa kweTrigonometric kwi-Excel
I-Trigonometry igxininisa ubudlelwane phakathi kwamacandelo kunye neengcangca zontathutathu, kwaye ngelixa abaninzi bethu abayidingi ukuyisebenzisa imihla ngemihla, i-trigonometry inezicelo kwiinkalo ezininzi ezibandakanya izakhiwo, i-physics, ubunjineli kunye nokuhlola.
Abacwangcisi, umzekelo sebenzisa i-trigonometry ngokubala okubandakanya umthunzi welanga, umthwalo wendawo, kunye neentaba.