Tsvaga Sine, Cosine, uye Tangent muGoogle Spreadsheets

Izvozvo zvinonzi trigonometric - sine, cosine, uye tangent - zvakabva pane katatu yakanyatsokwana (katatu ine kona yakaenzana ne12 degrees) sezvinoratidzwa mumufananidzo uri pamusoro.

Mumatunhu echikoro, izvi zvinoshandiswa zvinowanika kuburikidza nekuenzanisa kwakasiyana-siyana kwemaronometric kuenzanisa urefu hwekona katatu nechemberi dzakapoteredza neyekufungidzira kana kune umwe neumwe.

MuGoogle Spreadsheets, izvi zvinoshandiswa zvinogona kuwanika uchishandisa SIN, COS, uye TAN mabasa eangles akayerwa mumayera .

01 of 03

Degrees vs. Radians

Kushandisa zvinyorwa izvi zviri pamusoro apa zviri muGoogle Spreadsheets zvinogona kunge zviri nyore kupfuura kuzviita, asi, sezvakataurwa, zvinokosha kuziva kuti kana uchishanda mabasa aya, iyo ngano inofanira kuyerwa mumayera panzvimbo pezvidigiri - iyo inhengo huru isu hatizivi.

VaRadio vanowirirana nezera redu denderedzwa nerimwe radian riri rinenge rakaenzana ne 57 degrees.

Kuita kuti zvive nyore kushanda nemitambo yakagadzirisa, shandisa Google Spreadsheets RADIANS basa kuti uchinje ma angle ari kuyerwa kubva kumadire kusvika kuma radians sezvinoratidzwa muchitokisi B2 mumufananidzo uri pamusoro apa apo yakaenzana yegrigiri 30 inoshandurwa kuva 0.5235987756 radians.

Zvimwe zvingasarudzwa zvekushandura kubva kumadiresi kusvika kuma radians zvinosanganisira:

• kuvhara basa reRADIANS mukati meSIN function - sezvinoratidzwa mumutsara 3 mune muenzaniso;
• uchishandisa Google Spreadsheets PI inoshandiswa mumutsara: angle (digrii) * PI () / 180 sezvinoratidzwa mumutsara wechina mumuenzaniso.

02 of 03

Basa reMutatu "Syntax" uye "Arguments"

Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa , mabheji, uye nharo .

Izwi rechirevo cheSIN rinoshanda:

= SIN (angle)

Mutsara weCOS basa ndewokuti:

= COS (angle)

Izwi rechiito cheTAN rinoshanda:

= TAN (angle)

kona - iyo ingiro iri kuverengwa - yakayerwa mumayera
- hukuru hwekona mumayera anokwanisa kupindirwa nekuda kwechikonzero ichi kana, zvakare, sero rinotarisa panzvimbo ye data iyi mune pepa rekushanda .

Muenzaniso: Kushandisa Google Spreadsheets SIN Function

Muenzaniso uyu unobatanidza matanho anoshandiswa kupinda muSIN inoshanda mumusero C2 mumufananidzo uri pamusoro apa kuti uwane sine ye 30-degree angle kana 0.5235987756 radians.

Aya matanho anogona kushandiswa pakuverenga cosine uye tangent yekona sezvinoratidzwa mumitsara 11 ne12 mumufananidzo uri pamusoro.

Google Spreadsheets haishandisi dialog boxes kuti iite nharo dzebasa sezvazvinogona kuwanikwa mu Excel. Pane kudaro, ine bhaji- yebhokisi yebhokisi iyo inotasva sezvo zita rebasa racho richiiswa muchitokisi.

1. Dzvanya pachitokisi C2 kuti uite sero rinoshandiswa - iyi ndiyo iyo migumisiro yeSIN basa icharatidzwa;
2. Tora chikamu chakafanana (=) chinotevera nezita rebasa sin;
3. Sezvaunonyora, bhokisi -self- bhokisi rinowanikwa nemazita emabasa anotanga netsamba S;
4. Apo zita rokuti SIN rinowanikwa mubhokisi, chengetedza zita nezita rekushandisa kuti uise zita rebasa uye mazera ekuzarura kana kuti mabhodhi akaiswa muchitokisi C2.

03 of 03

Kupinda Basa reMabasa

Sezvakaratidzwa mumufananidzo uri pamusoro, nharo yeSIN basa inopinda mushure mekuvhara kwebhuka rakazaruka.

1. Dzvanya pachitsi B2 mune pepa rekushanda kuti uise iyi seferensi yekero seyo angle argument;
2. Dhinda pikicha inopinda mubhobhoyo kuti uise mavhesi ekuvhara " ) " mushure mekushanda kwebasa uye kupedzisa basa;
3. Inokosha 0.5 inofanira kuonekwa muchitokisi C2 - iyo inonzi sine ye 30-degree angle;
4. Paunenge uchinyora pachitsime C2 yakakwana basa = SIN (B2) inowanikwa mubhairi yepamusoro pane pepa pepaji.

#VALUE! Zvikanganiso uye Mucheka Asina Kubatsira

IIN Sinoshanda inoratidza #VALUE! kukanganisa kana shanduro inoshandiswa senyaya yebasa inongedzera kune sero rine text data row mishanu yemuenzaniso apo sero rinoshandiswa rinoshandiswa rinotarisa kumashoko okuti: Angle (Radians);

Kana sero rinotarisa kune rimwe risina chinhu, basa rinodzoka kukosha kwe zero-mutsara matanhatu pamusoro apa. Google Spreadsheets inotanga kushandura inoshandura isina masero se zero, uye sine ye zero radians yakaenzana ne zero.