Thola i-Sine, i-Cosine, ne-Tangent kuma-Google Spreadsheets

Imisebenzi ye-trigonometric - i-sine, i-cosine, ne-tangent-isekelwe unxantathu olungenalutho (unxantathu equkethe i-angle elingana nama-90 degrees) njengoba kuboniswe esithombeni ngenhla.

Esiklasini sesibalo, lezi zinsuku zitholakala ngokusebenzisa izilinganiso ezihlukahlukene ze-trigonometric ngokuqhathanisa ubude bezinhlangothi ezingxenyeni eziphambene nezinhlangothi eziphambene nalokho okwenziwa yi-hypotenuse noma komunye nomunye.

Ku-Google Spreadsheet, le miisebenzi emithathu ingatholakala ngokusebenzisa imisebenzi ye-SIN, COS, kanye ne-TAN yezingelo ezilinganiselwe kuma- radians .

01 ka-03

Ama-Degrees vs. Radians

Ukusebenzisa imisebenzi ye-trigonometric engenhla kuma-Google Spreadsheets kungase kube lula kunokukwenza ngesandla, kodwa, njengoba kubonisiwe, kubalulekile ukuqaphela ukuthi uma usebenzisa le misebenzi, i-angeli idinga ukulinganiswa kuma- radians kunama- degree - okuyinto iyunithi kakhulu thina asijwayele.

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

Ukuze wenze kube lula ukusebenza ngemisebenzi emibili, sebenzisa umsebenzi we- Google Spreadsheets RADIANS ukuguqula i-engeni ukuthi ibalwe kusuka kumadiresi kuya kuma-radians njengoba kuboniswe esitokisini B2 esithombeni ngenhla lapho i-angle yama-degrees angu-30 iguqulwa ibe yi-radians engu-0.5235987756.

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

• ukuhlalisa umsebenzi we-RADIANS ngaphakathi komsebenzi we-SIN - njengoba kuboniswe kumugqa wesi-3 kusibonelo;
• usebenzisa umsebenzi we-Google Spreadsheets PI kwifomula: i- angle (degrees) * PI () / 180 njengoba kuboniswe kulayini 4 kusibonelo.

02 ka-03

I-Syntax ye-Trig nemigomo

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

I-syntax yomsebenzi we-SIN yile:

= ISIN (i-angle)

I-syntax yomsebenzi we-COS yilezi:

= I-COS (i-angle)

I-syntax yomsebenzi we-TAN yile:

= TAN (i-angle)

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

Lesi sibonelo sihlanganisa izinyathelo ezisetshenziselwa ukungena umsebenzi we-SIN esitokisini C2 esithombeni esingenhla ukuze uthole i-sine ye-angle engama-30 degree noma ama-radians angu-0.5235987756.

Izinyathelo ezifanayo zingasetshenziselwa ukubala i-cosine ne-tangent ye-angle njengoba kuboniswe emigqeni engu-11 no-12 esithombeni ngenhla.

I-Google Spreadsheets ayisebenzisi amabhokisi okuxoxa ukuze ufake izingqinamba zomsebenzi njengoba zingatholakala ku-Excel. Esikhundleni salokho, inebhokisi elikhombisa ukuzenzekelayo eliphambuka njengoba igama lomsebenzi lifakwe esitokisini.

1. Chofoza ku-cell C2 ukuze wenze iseli elisebenzayo - yilapho imiphumela yomsebenzi we-SIN izoboniswa;
2. Thayipha uphawu olulinganayo (=) olulandelwe igama lomsebenzi wesono;
3. Njengoba uthayipha, ibhokisi eliphakamisa ngokuzenzakalelayo livela ngamagama wemisebenzi eqala ngencwadi S;
4. Uma igama le- SIN livela ebhokisini, chofoza igama nge-pointer yegundane ukufaka igama lomsebenzi kanye ne-parenthesis evulekile noma ibhakhodi elizungezile esitokisini C2.

03 ka 03

Ukufaka Ukungqubuzana Komsebenzi

Njengoba kuboniswe esithombeni esingenhla, ukuphikisana komsebenzi we-SIN kufakwe ngemuva kwesibhakela evulekile.

1. Chofoza kuseli B2 kusikripthi sokusebenza ukuze ufake leli khenferensi yeseli njengengxabano ye angle ;
2. Cindezela ukhiye wokungena kwikhibhodi ukuze ufake ama-parenthesis wokuvala " ) " ngemuva kokuphikisana komsebenzi futhi ukuqedela umsebenzi;
3. Inani le-0.5 kufanele livele esitokisini C2 - okuyi-sine ye-angle engama-30 degree;
4. Uma uchofoza ku-cell C2 umsebenzi ophelele = I-SIN (B2) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela.

#VALUE! Amaphutha kanye Nemiphumela Yelikhanda Elibukhali

Umsebenzi we-SIN ubonisa i- #VALUE! iphutha uma ireferensi esetshenzisiwe njengengxabano yomsebenzi ikhomba esitokisini equkethe idatha yombhalo wesigcawu sesihlanu isibonelo lapho isethenjwa selesithenjwa esetshenzisiwe sikhombise ilebula yombhalo: I- Angle (amaRudiya);

Uma iseli likhomba esitokisini esingenalutho, umsebenzi ubuyisela inani le-zero - irowu eyisithupha ngenhla. I-Google Spreadsheets i-trig isebenza ngokuhumusha amangqamuzana angenalutho njenge-zero, futhi i-sine yama-zero radians ilingana no-zero.