Fumana i-Sine, i-Cosine, ne-Tangent kwi-Google Spreadsheets

Imisebenzi ye-trigonometric - i-sine, i-cosine, kunye ne-tangent-isekelwe kunxantathu echanekileyo (inxantathu ene-angle elingana nama-90 degrees) njengoko kuboniswe kumfanekiso ongentla.

Kwiklasi yeemathematika, le mi sebenzi ifunyenwe ngokusebenzisa izilinganiso ezahlukeneyo ze-trigonometric ngokuthelekisa ubude bomxantathu obusondelene kunye namacala aphikisanayo kunye nenkohlakalo okanye omnye nomnye.

Kwi-Google Spreadsheets, le mi sebenzi ye-trig itholakala usebenzisa i-SIN, i-COS, kunye ne-TAN imisebenzi yeenglese ezilinganiswe kuma- radians .

01 ka 03

IziGanga kunye namaRadi

Ukusebenzisa imisebenzi ye-trigonometric engentla kwi-Google Spreadsheets ingaba lula kunokuyenza ngokwenza ngesandla, kodwa, njengoko kubonisiwe, kubalulekile ukuqaphela ukuba xa usebenzisa le mi sebenzi, i-angle ifuna ukulinganiswa kuma- radians kunee- degrees - eyona nto iyunithi asiyazi kakuhle.

AmaRidiya anxulumene nomda weesangqa kunye ne-radian esilingana nokulingana nama-57 degrees.

Ukwenza kube lula ukusebenza kunye nemisebenzi ye-trig, sebenzisa i- Google Spreadsheets RADIANS ukuguqula i-angle ekulinganiselwe ukusuka kwiiyure ukuya kuma-radians njengoko kuboniswe kwiseli B2 kumfanekiso ongentla apho i-angle ye-degrees ezingama-30 iguqulwa ibe ngu-0.5235987756 i-radians.

Ezinye iinketho zokuguqula ukusuka kwiiyure ukuya kuma-radians ziquka:

• ukuhlalisa umsebenzi we-RADIANS ngaphakathi kwe-SIN umsebenzi - njengoko kuboniswe kumgca 3 kumzekelo;
• usebenzisa i-Google Spreadsheets umsebenzi wePI kwifom: i- angle (degrees) * PI () / 180 njengoko kuboniswe kumqolo 4 kumzekelo.

02 ka 03

ImiSebenzi ye-Trig 'yamaStell neArguments

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi , amabakethi kunye neengxabano .

I-syntax yomsebenzi we-SIN yi:

= ISIN (i-angle)

I-syntax yomsebenzi weCOS yile:

= ICOS (angle)

I-syntax yomsebenzi we-TAN ngu:

= TAN (angle)

i-angle - 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-Google Spreadsheets SIN Umsebenzi

Lo mzekelo ugubungela amanyathelo asetyenziswa ukufaka umsebenzi we-SIN kwisitellite C2 kumfanekiso ongentla ukufumana i-sine ye-angle-degree engama-30 okanye i-0.5235987756.

Amanyathelo afanayo angasetyenziselwa ukubala i-cosine kunye ne-tangent yekona njengoko kuboniswe kumqolo 11 no-12 kumfanekiso ongentla.

I-Google Spreadsheets ayisebenzisi ibhokisi yencoko yababini yokufaka iingxoxo zomsebenzi njengoko zifumaneka kwi-Excel. Endaweni yoko, inebhokisi ephakanyiswa yi- auto ephakamisa njengoko igama lomsebenzi lifakwe kwiseli.

1. Cofa kwifowuni C2 ukwenzela ukuba yenze iseli esebenzayo- yilapho iziphumo ze-SIN umsebenzi ziza kuboniswa;
2. Thayipha uphawu olulinganayo (=) olulandelwe igama lomsebenzi wesono;
3. Njengoko uthayipha, ibhokisi ephakamisa ngokuzenzekelayo ibonakala ngamagama emisebenzi eqala ngeleta S;
4. Xa igama le- SIN livela kwibhokisi, nqakraza egameni nge-pointer ye mouse ukuze ufake igama lomsebenzi kunye ne-parenthesis evulekile okanye ibhondi ejikelezayo kwi-cell C2.

03 ka 03

Ukungena kwiSigqibo sokuSebenza

Njengoko kuboniswe kumfanekiso ongentla, ingxabano yesenzo se-SIN ingenwe emva kwebhokisi evulekile.

1. Cofa kwiseli B2 kwiphepha lokusebenzela ukufaka le ferensi yeseli njengengxabano ye- angle ;
2. Cinezela ukhiye wokungena kwibhodibhodi ukungena kubazali bokuvala " ) " emva kombhikano womsebenzi kwaye uzalise umsebenzi;
3. Ixabiso le-0.5 kufuneka livele kwiseli yeC2 - eyona yimbi ye-angle-degree-30;
4. Xa ucofa kwiseli C2 umsebenzi opheleleyo = ISIN (B2) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela.

#VALUE! Iimpazamo kunye neziphumo zeeMbewu ezingenanto

Umsebenzi we-SIN ubonisa i- #VALUE! impazamo ukuba isalathiso esetyenziswe njengesigqibo somsebenzi sikhombisa iseli elineenkcukacha zedata yecatshulwa emithathu umzekelo apho isalathisi esetyenzisiweyo isetyenziswe kwibhile yombhalo: I- Angle (Radians);

Ukuba iseli likhomba kwisitenki esingenalutho, umsebenzi ubuyisela ixabiso lentlawulo yesine ngentla. Iipredishithi zeGoogle ezi-trig ziguqulela ii-cell ezingenanto njenge-zero, kwaye i-sine ye-radios i-zero ilingana no-zero.