Pezani Sine, Cosine, ndi Tangent mu Google Spreadsheets

Ntchito za trigonometric - sine, cosine, ndi tangent - zimachokera pa katatu kakang'ono (katatu kakang'ono kamene kali ndi ngodya yofanana ndi madigiri 90) monga momwe taonera pa chithunzi pamwambapa.

Mu masamu a masamu, ntchito izi zimapezeka pogwiritsa ntchito maulendo osiyanasiyana a trigonometric poyerekeza kutalika kwa mbali zitatu zamphongo zapafupi ndi zotsutsana ndi zomwe zimakhala zovuta kapena zosiyana.

Mu Google Spreadsheets, ntchito zowonongekazi zingapezeke pogwiritsa ntchito SIN, COS, ndi TAN ntchito zazingwe zomwe zimayikidwa mu radians .

01 a 03

Malemba ndi Ma Radi

Kugwiritsira ntchito ntchito zapamwambazi zapamwamba pa Google Spreadsheets zingakhale zophweka kusiyana ndi kuzichita mwadongosolo, koma monga tanenera, ndikofunikira kudziwa kuti pogwiritsa ntchito ntchitoyi, mbali imafunika kuyeza mu miyendo yambiri kuposa madigiri - yomwe ili gawo limodzi la magawo ambiri ife sitidziwa bwino.

Asilikali akugwirizana ndi malo ozungulira omwe ali ndi radian omwe amakhala ofanana ndi madigiri 57.

Kuti ntchitoyi ikhale yosavuta kugwira ntchito, gwiritsani ntchito Google Spreadsheets RADIANS kuti mutembenuzire mbali yomwe ikuyambira kuchokera madigiri mpaka kumawonekedwe monga momwe akusonyezera mu selo B2 mu fano pamwambapa pomwe mpweya wa madigiri 30 ukutembenuzidwa kukhala radians 0,5235987756.

Zosankha zina kuti mutembenuke kuchoka ku madigiri mpaka kumawuni ndi awa:

• kumanga ntchito za RADIANS mkati mwa ZINTHU ntchito - monga momwe tawonetsera mzere 3 mu chitsanzo;
• pogwiritsa ntchito Google Spreadsheets PI pogwiritsa ntchito njirayi: angle (madigiri) * PI () / 180 monga momwe tawonedwera mzere 4 mu chitsanzo.

02 a 03

Ntchito za Trig 'Syntax ndi Arguments

Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito , mabaki, ndi zifukwa .

Chidule cha ntchito ya SIN ndi:

= SIN (ngodya)

Chidule cha ntchito ya COS ndi:

= COS (mbali)

Chidule cha ntchito ya TAN ndi:

= TAN (ngodya)

mbali - ngodya ikuwerengedwa - imayeza mu radians
- kukula kwa mbali ya radians kungalowetsedwe pazokambirana izi, kapena, kutanthauzira selo kumalo a deta iyi mu tsamba la ntchito .

Chitsanzo: Gwiritsani ntchito Google Spreadsheets SIN Function

Chitsanzo ichi chikuphimba njira zomwe zimagwiritsidwa ntchito kulowa mu CHINTHU ntchito mu selo C2 mu chithunzi pamwambapa kuti mupeze sine ya madigiri 30 digiri kapena 0,5235987756 radians.

Miyeso yomweyo ingagwiritsidwe ntchito powerengera cosine ndi tangent ya ngodya monga momwe akuwonetsera mzere 11 ndi 12 mu chithunzi pamwambapa.

Google Spreadsheets sagwiritsira ntchito bokosi la dialogso kuti muike zifukwa za ntchito monga zingapezeke mu Excel. M'malo mwake, ili ndi bokosi lopangira mothandizira lomwe limatuluka ngati dzina la ntchito likuyimikidwa mu selo.

1. Dinani pa selo C2 kuti likhale selo yogwira ntchito - izi ndi zomwe zotsatira za uchimo ntchito zidzawonetsedwa;
2. Lembani chizindikiro chofanana (=) chotsatira dzina la ntchitoyo tchimo;
3. Pamene mukuyimira, bokosi lopangira okhalo likuwonekera ndi mayina a ntchito zomwe zimayamba ndi kalata S;
4. Pamene dzina la SIN likuwonekera m'bokosilo, dinani pa dzina ndi ndondomeko ya mouse kuti mulowetse dzina la ntchito ndi kutseguka kwachinsinsi kapena makina ozungulira mu selo C2.

03 a 03

Kulowa Kutsutsana kwa Ntchito

Monga momwe tawonera mu chithunzi pamwambapa, kutsutsana kwa ntchito ya SIN imalowa pambuyo poyika makina ozungulira.

1. Dinani pa selo B2 papepala la ntchito kuti mulowetse selo ili ngati mtsutso wongodya;
2. Lembani fungulo lolowamo lolowera mu khididi kuti mulowetse mawu omaliza otsekemera " ) " pambuyo pa kukangana kwa ntchitoyo ndi kumaliza ntchitoyo;
3. Phindu la 0,5 liyenera kuoneka mu selo C2 - yomwe ndi sine ya digiri ya digirii 30;
4. Mukasindikiza pa selo C2 ntchito yonse = SIN (B2) ikuwoneka mu barra yazenera pamwamba pa tsamba.

#VALUE! Zolakwa ndi Msewu Wosawona Kumapezeka

Ntchito YONSE imasonyeza #VALUE! cholakwika ngati mawu omwe akugwiritsidwa ntchito monga ndondomeko ya ntchitoyo akulozera selo lokhala ndi deta mzere mzere wachitsanzo zisanu zomwe malo ogwiritsira ntchito selo akugwiritsira ntchito polemba: Angle (Ma Radiya);

Ngati selo likulozera ku selo yopanda kanthu, ntchitoyo imabweretsanso mtengo wa zero - mzere sikisi pamwambapa. Google Spreadsheets amayambitsa ntchito kumasulira maselo opanda kanthu ngati zero, ndipo sine ya zero radians ndi ofanana ndi zero.