Yog tias koj xav pom cov cosine ntawm lub kaum sab xis, siv COS Function hauv Microsoft Excel. Txawm hais tias koj lub kaum sab xis nyob hauv degrees lossis radians, qhov kev daws teeb meem no ua haujlwm nrog me ntsis tweaking. Ua raws li cov lus qhia ib kauj ruam dhau los no kom pom tias nws yooj yim npaum li cas los ua kom zoo dua ntawm Excel cov kev txawj lej ceev.
Cov lus qhia hauv kab lus no siv rau Excel 2019, 2016, 2013, 2010, 2007; Excel rau Mac, Excel 365, Excel Online, Excel rau Android, Excel rau iPad, thiab Excel rau iPhone.
Nrhiav Cosine ntawm lub kaum sab xis hauv Excel
Lub trigonometric muaj nuj nqi cosine, zoo li lub sine thiab lub tangent, yog raws li ib tug txoj cai-angled daim duab peb sab (ib daim duab peb sab uas muaj ib tug kaum sab xis sib npaug zos rau 90 degrees) raws li qhia nyob rau hauv daim duab hauv qab no.
Hauv chav kawm lej, cov cosine ntawm lub kaum sab xis pom los ntawm kev faib qhov ntev ntawm sab uas nyob ib sab ntawm lub kaum sab xis los ntawm qhov ntev ntawm lub hypotenuse. Hauv Excel, lub cosine ntawm lub kaum sab xis tuaj yeem pom siv COS ua haujlwm ntev npaum li lub kaum sab xis ntsuas hauv radians.
COS muaj nuj nqi txuag koj ntau lub sijhawm thiab muaj peev xwm ua kom lub taub hau khawb vim tias koj tsis tas yuav nco ntsoov tias sab twg ntawm daim duab peb sab nyob ib sab ntawm lub kaum sab xis, uas yog qhov sib txawv, thiab qhov twg yog lub hypotenuse.
Nkag siab Degrees vs. Radians
Siv COS muaj nuj nqi los nrhiav cov cosine ntawm lub kaum sab xis yuav yooj yim dua li ua nws tus kheej, tab sis, raws li tau hais, nws yog ib qho tseem ceeb kom paub tias thaum siv COS muaj nuj nqi, lub kaum sab xis yuav tsum nyob hauv radians ntau dua li. degrees.
Radians cuam tshuam nrog lub vojvoog ntawm lub voj voog. Ib radian yog kwv yees li 57 degrees.
Txhawm rau ua kom yooj yim rau kev ua haujlwm nrog COS thiab Excel lwm cov haujlwm trig, siv Excel's RADIANS muaj nuj nqi los hloov lub kaum sab xis ntsuas los ntawm degrees rau radians raws li qhia hauv cell B2 hauv daim duab saum toj no. Hauv qhov piv txwv no, lub kaum sab xis ntawm 60 degrees hloov mus rau 1.047197551 radians.
Lwm cov kev xaiv rau kev hloov ntawm qib mus rau radians suav nrog kev ua zes RADIANS ua haujlwm hauv COS muaj nuj nqi (raws li qhia hauv kab 3 hauv daim duab piv txwv) thiab siv Excel's PI ua haujlwm hauv cov qauv (raws li qhia hauv kab 4 hauv qhov piv txwv duab).
Trigonometric Siv hauv Excel
Trigonometry tsom mus rau kev sib raug zoo ntawm ob sab thiab lub kaum sab xis ntawm daim duab peb sab, thiab thaum peb feem ntau tsis tas yuav siv nws txhua hnub, trigonometry muaj cov ntawv thov hauv ntau qhov chaw suav nrog architecture, physics, engineering, thiab soj ntsuam.
Cov kws tsim vaj tsev, piv txwv li, siv trigonometry rau kev suav nrog hnub ci, kev thauj khoom, thiab, ru tsev slopes.
Excel COS Function Syntax and 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. Cov syntax rau COS muaj nuj nqi yog:
=COS(Number)
Number: Lub kaum sab xis raug xam, ntsuas hauv radians. Qhov luaj li cas ntawm lub kaum sab xis hauv radians tuaj yeem nkag mus rau qhov kev sib cav no lossis kev siv ntawm tes rau qhov chaw ntawm cov ntaub ntawv no hauv daim ntawv ua haujlwm tuaj yeem nkag mus xwb.
Siv Excel's COS Function
Cov piv txwv hauv kab lus no suav nrog cov kauj ruam uas siv los nkag rau COS ua haujlwm rau hauv cell C2 hauv daim duab saum toj no kom pom cov cosine ntawm 60-degree lub kaum sab xis lossis 1.047197551 radians.
Cov kev xaiv rau kev nkag mus rau COS muaj nuj nqi suav nrog kev ntaus ntawv manually hauv tag nrho cov haujlwm lossis siv lub Function Arguments dialog box raws li tau teev tseg hauv qab no.
Enter the COS Function
- Xaiv xovtooj C2 hauv daim ntawv ua haujlwm kom nws ua haujlwm ntawm tes.
- Xaiv tus Formulas tab ntawm ribbon bar.
- Xaiv Math & Trig los ntawm ribbon los qhib cov npe ua haujlwm poob.
- Xaiv COS nyob rau hauv daim ntawv los qhib lub Function Arguments dialog box. Hauv Excel rau Mac, Formula Builder qhib.
-
Nyob rau hauv lub dialog box, tso tus cursor rau hauv tus lej kab.
Image - Xaiv xovtooj B2 hauv daim ntawv ua haujlwm kom nkag mus rau qhov kev siv ntawm tes rau hauv cov qauv.
- Xaiv OK kom ua tiav cov qauv thiab rov qab mus rau daim ntawv ua haujlwm. Tsuas yog hauv Excel rau Mac, qhov twg koj xaiv Done hloov.
- Cov lus teb 0.5 tshwm hauv cell C2, uas yog lub cosine ntawm 60-degree kaum.
- Xaiv tes C2 kom pom qhov ua tiav hauv cov qauv bar saum daim ntawv ua haujlwm.
=COS(B2)
Teeb meem nrog Excel's COS Function
VALUE! yuam kev
COS muaj nuj nqi qhia qhov VALUE! yuam kev yog hais tias siv raws li qhov muaj nuj nqi sib cav taw tes rau ib lub xov tooj ntawm tes uas muaj cov ntaub ntawv ntawv. Hloov lub xovtooj ntawm cov ntaub ntawv hom mus rau Tus lej los kho qhov yuam kev.
Blank Cell Results
Yog tias lub xovtooj taw qhia rau lub xovtooj khoob, qhov ua haujlwm rov qab tus nqi ntawm ib qho. Excel's trig functions txhais cov hlwb dawb li xoom, thiab cov cosine ntawm xoom radians yog sib npaug rau ib qho. Kho qhov yuam kev los ntawm kev taw qhia koj txoj haujlwm mus rau lub xovtooj ntawm tes.
