Excel TAN Basa: Tsvaga Tangent yeAngle

Izvo zvinonzi trigonometric function tangent , seyine uye cosine , inobva pakateteteredzwa yakarurama (katatu ine ine angle yakaenzana ne 90 degrees) sezvinoratidzwa mumufananidzo uri pamusoro.

Muchikoro chemasvomhu, tangent yekona inogona kuwanikwa uchishandisa chiyero ichifananidza kureba kwechidimbu chinopikisana nekona (o) kusvika kwerutivi rwakatarisana nekona (a).

Chirevo chechiyero ichi chinogona kunyorwa:

Tan Θ = o / a

apo Θ yakaenzana nekona iri pasi pekufungisisa (45o mumuenzaniso uyu)

MuExcel, kuwana mhepo yekona kunogona kushandiswa nekushanda kweTAN kushandiswa kwengiro dzakaenzana mumayera .

01 ye 05

Degrees vs. Radians

Kushandisa basa reTAN kuwana tangent yekona kunogona kuva nyore pane kuzviita nemunhu, asi, sezvakataurwa, ingiro inoda kuva mumayera panzvimbo yezvidimbu - iyo inhengo imwe chete yedu isingazivi.

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

Kuita kuti zvive nyore kushanda pamwe neTAN uye mamwe maExcel mamwe mabasa, shandisa basa reRALANS re Excel kuti uchinje ma angle ari kuyerwa kubva kumadigiri kusvika kumairada sezvinoratidzwa muchitokisi B2 mumufananidzo uri pamusoro apa apo yakaenzana nemadhigiri makumi mashanu akachinjwa kuva 0.785398163 radians.

Zvimwe zvingasarudzwa zvekushandura kubva kumadiresi kusvika kuma radians zvinosanganisira:

• kuvhara basa reRADIANS mukati meTAN basa - sezvinoratidzwa mumutsara 3 mune muenzaniso;
• uchishandisa Excel PI inoshandiswa mumutsetse: angle (digrii) * PI () / 180 sezvinoratidzwa mumutsara wechina mumuenzaniso.

02 of 05

Iko Syntax yeMabasa uye Arguments

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

Izwi rechiito cheTAN rinoshanda:

= TAN (Nhamba)

Nhamba - (inofanirwa) iyo yero yakaverengwa - yakayerwa mumayera;
- hukuru hwekona mumayera anokwanisa kupindirwa nekuda kwechikonzero ichi kana, zvakare, sero rinotarisa panzvimbo ye data iyi mune pepa rekushanda .

Muenzaniso: Kushandisa Tcel Basa reTAN

Uyu muenzaniso unovhara matanho anoshandiswa kupinda muTAN kushanda muchitokisi C2 mumufananidzo pamusoro apa kuti uwane tangent ye 45 degree angle kana 0.785398163 radians.

Zvisarudzo zvekupinda muTAN zvinosanganisira kunyora manyore mubasa rose = TAN (B2) , kana kushandisa sarudzo yebasa - sezvakataurwa pasi apa.

03 of 05

Kupinda Basa reTAN

1. Dzvanya pachitokisi C2 mune pepa rekushanda kuti uite sero rinoshanda ;
2. Dzvanya paMafomu tab yebhoni yebhoni ;
3. Sarudza Math & Trig kubva kubhoni kuti uzarure basa rinoyerera pasi;
4. Dzvanya paTAN mumutsetse kuti uburise hurukuro yebhokisi rebasa;
5. Mubhokisi rebhokisi, tora paNhamba yemurongo;
6. Dzvanya pachitsi B2 mune pepa rekushanda kuti uise iyo seferensi iri mumutsetse;
7. Dzvanya OK kuti upedze rondedzero uye dzoka kubheji rekushanda;
8. Mhinduro 1 inofanira kuonekwa muchitokisi C2 - iyo inonzi tangent ye 45 degree angle;
9. Paunenge uchinyora pachitsime C2 yakakwana basa = TAN (B2) inowanikwa mubhadha yepamusoro pane pepa pepaji.

04 of 05

#VALUE! Zvikanganiso uye Mucheka Asina Kubatsira

Basa reTAN rinoratidza #VALUE! kukanganisa kana shanduro inoshandiswa senyaya yebasa inongedzera kune sero rine text data - mutsara mishanu wemuenzaniso apo sero rinoshandiswa rinoshandiswa rinongedzera kumashoko ekunyora: Angle (Radians);

Kana sero rinotarisa kune seki risina chinhu, basa rinodzorera kukosha kweimwe-mutsara matanhatu pamusoro apa. Excel's trig functions inoshandura pasina mabhesi se zero, uye tangent ye zero radians yakaenzana nechimwe.

05 of 05

Trigonometric Uses mu Excel

Trigonometry inotarisa kuhukama pakati pemakona nemakona emakatatu, uye nepo vazhinji vedu tisingafaniri kuishandisa zuva rega rega, trigonometry ine maitiro mune zvimwe zvinhu zvakasanganisira mashizha, physics, engineering, nekuongorora.

Architects, somuenzaniso shandisa trigonometry kuti zviverengwe zvinosanganisira zuva shading, chimiro chetsika, uye, pamusoro pematenga.