Yuav Paub
- Siv cov syntax rau RADIANS muaj nuj nqi, uas yog =RADIANS(Angle), hloov degrees rau radians.
- Xav siv lub thawv muaj nuj nqi / Cov qauv tsim, xaiv qhov chaw koj xav kom cov lus teb tshwm, tom qab ntawd mus rau Formula > Math & Trig > RADIANS.
- Los yog, muab lub kaum sab xis los ntawm PI() ua haujlwm thiab tom qab ntawd faib cov txiaj ntsig los ntawm 180 kom tau lub kaum sab xis hauv radians (piv txwv li, 45PI() / 180).
Kab lus no piav qhia yuav ua li cas hloov cov degrees rau radians hauv Excel 2019, 2016, 2013, 2010, thiab Excel rau Microsoft 365.
Excel RADIANS Function Piv txwv
piv txwv no siv RADIANS muaj nuj nqi los hloov lub kaum sab xis 45 rau radians. Cov ntaub ntawv npog cov kauj ruam uas siv los nkag rau RADIANS muaj nuj nqi rau hauv cell B2 ntawm daim ntawv ua piv txwv.
Kev xaiv rau nkag mus rau lub luag haujlwm suav nrog:
- Typing qhov ua tiav rau hauv cell B2, raws li qhia hauv cell C3 saum toj no.
- Xaiv txoj haujlwm thiab nws cov lus sib cav siv lub Function Dialog lub thawv.
Txawm hais tias nws tuaj yeem nkag mus rau qhov ua tiav ntawm tus kheej, ntau tus neeg pom tias nws yooj yim dua los siv lub Function dialog box, vim nws saib xyuas kev nkag mus rau kev ua haujlwm ntawm syntax xws li brackets thiab comma separators ntawm kev sib cav.
Siv lub thawv muaj nuj nqi (Formula Builder ntawm Mac) rau RADIANS
-
Click on cell B2 hauv daim ntawv ua haujlwm - qhov no yog qhov ua haujlwm yuav mus.
- Click on the Formulas tab ntawm ribbon menu.
- Xaiv Math & Trig los ntawm ribbon los qhib cov npe ua haujlwm poob.
- Click on RADIANS hauv daim ntawv txhawm rau nqa lub Function Dialog Box.
- Click on the Angle kab.
- Nias rau Cell A2 hauv daim ntawv ua haujlwm kom nkag mus rau ntawm tes siv raws li qhov kev sib cav.
- Click Done kom ua tiav txoj haujlwm - cov lus teb 0.785398163, uas yog 45-degrees qhia hauv radians, tshwm hauvcell B2.
- Yog tias koj daim ntawv ua haujlwm qhia tsawg tus lej mus rau sab xis ntawm tus lej lej, koj tuaj yeem tsim lub xovtooj los tso saib ntau dua.
Koj tuaj yeem nkag cov ntaub ntawv ncaj qha rau hauv lub thawv sib tham es tsis yog cov ntaub ntawv ntawm tes, tab sis qhov ntawd ua rau nws nyuaj rau hloov cov qauv thiab cov haujlwm.
Siv PI() Muaj nuj nqi kom tau lub kaum sab xis hauv Radians
Ib qho kev xaiv, raws li qhia hauv cell C4ntawm cov duab piv txwv, yog muab lub kaum sab xis los ntawm PI() ua haujlwm thiab ces faib qhov tshwm sim los ntawm 180 kom tau lub kaum sab xis nyob rau hauv radians.
Nws zoo li no:
=A2PI()/180
Vim li cas thiaj siv Excel RADIANS Function?
Excel muaj cov haujlwm trigonometric built-in uas ua rau nws yooj yim los nrhiav cov cosine, sine, thiab tangent ntawm lub kaum sab xis ntawm daim duab peb sab - daim duab peb sab uas muaj lub kaum sab xis sib npaug li 90 degrees.
Qhov teeb meem nkaus xwb yog tias cov haujlwm no xav tau cov kaum qhia hauv radians, tsis yog degrees. Thaum radians, ib chav tsev ntawm cov ces kaum, yog ib txoj kev raug cai ntawm kev ntsuas lub kaum sab xis raws li lub vojvoog ntawm lub voj voog, lawv tsis yog ib yam dab tsi uas tib neeg feem ntau ua hauj lwm nrog ib txwm.
Txhawm rau pab cov neeg siv daim ntawv nthuav dav nruab nrab ntawm qhov teeb meem no, Excel muaj qhov RADIANS, uas ua rau nws yooj yim los hloov cov degrees rau radians.
RADIANS Function Syntax thiab Arguments
A muaj nuj nqi syntax hais txog kev teeb tsa ntawm txoj haujlwm thiab suav nrog cov haujlwm lub npe, cov hlua khi, thiab cov lus sib cav. Lub syntax rau RADIANS muaj nuj nqi yog:
=RADIANS(Angle)
Lub kaum sab xis yog lub kaum sab xis hauv qib koj xav hloov mus rau radians; Nws tuaj yeem nkag mus rau qib lossis raws li kev siv xovtooj ntawm qhov chaw ntawm cov ntaub ntawv no hauv koj daim ntawv Excel.
