ATAN (arctangent) basa muExcel

Arctangent itrigonometric function inverse to tangent, iyo inoshandiswa mune chaiyo sainzi. Sezvatinoziva, muExcel hatigone kungoshanda nemaspredishiti, asiwo kuita masvomhu - kubva pane zviri nyore kusvika kune zvakanyanya kuoma. Ngationei kuti chirongwa chinogona kuverenga sei arc tangent kubva pane yakapihwa kukosha.

Isu tinoverenga arc tangent

Excel ine basa rinokosha (operator) rinonzi "ATAN", iyo inokubvumira kuti uverenge arc tangent mu radians. Yayo general syntax inoita seizvi:

=ATAN(nhamba)

Sezvatinoona, basa racho rine nharo imwe chete. Unogona kuishandisa nenzira dzakasiyana.

Method 1: Kuisa fomula nemaoko

Vazhinji vashandisi vanowanzoita masvomhu, kusanganisira trigonometric, vanopedzisira vaziva nemusoro fomula yebasa uye vanoiisa nemaoko. Heino maitiro azvinoitwa:

1. Tinosimuka muchitokisi matiri kuda kuita masvomhu. Ipapo isu tinoisa fomula kubva kukhibhodi, pachinzvimbo chekupokana isu tinotsanangura kukosha chaiko. Usakanganwa kuisa chiratidzo "chakaenzana" pamberi pekutaura. Somuenzaniso, kwatiri, ngazvive zvakadaro “ATAN (4,5)”.
2. Kana fomula yagadzirwa, tinya pindakuwana mhedzisiro.

Notes

1. Panzvimbo yenhamba, tinogona kutsanangura chinongedzo kune imwe sero ine nhamba yakakosha. Uyezve, kero inogona kuiswa kana nemaoko, kana kungodzvanya pane yaunoda sero mutafura pachayo.

Iyi sarudzo iri nyore nekuti inogona kuiswa kune column yenhamba. Semuenzaniso, isa fomula yekutanga kukosha mumutsara unoenderana, wobva wadzvanya pindakuwana mhedzisiro. Mushure meizvozvo, fambisa cursor kukona yekurudyi yesero nemhedzisiro, uye mushure memuchinjiko mutema waoneka, bata pasi bhatani rekuruboshwe uye dhonza pasi kune yakaderera yakazara sero.

Nekuburitsa bhatani rembeva, tinowana otomatiki kuverenga kwearc tangent kune ese ekutanga data.

2. Uyezve, panzvimbo yekupinda basa muchitokisi pachako, iwe unogona kuzviita zvakananga mubhari yekugadzira - ingofa mukati mayo kuti utange maitiro ekugadzirisa, mushure mokunge tapinda chirevo chinodiwa. Kana wagadzirira, semazuva ese, dzvanya pinda.

Method 2: Shandisa Basa Wizard

Iyi nzira yakanaka nekuti haufanire kurangarira chero chinhu. Chinhu chikuru ndechokukwanisa kushandisa mubatsiri anokosha akavakwa purogiramu.

1. Isu tinosimuka muchitokisi chaunoda kuwana mhedzisiro. Wobva wadzvanya pane icon "Fx" (Isa Basa) kuruboshwe rweformula bar.
2. Hwindo richaonekwa pachiratidziri. Basa Wizards. Pano tinosarudza chikamu “Runyorwa ruzere rwearufabheti” (kana "Mathematics"), uchipfuura nepakati pezvinyorwa zvevashandisi, maka "ATAN", ipapo shandisa OK.
3. Hwindo richaonekwa rekuzadza mugakava rebasa. Pano tinotsanangura kukosha kwenhamba uye tinya OK.Sezviri muchiitiko chekuisa manyore fomu, panzvimbo yenhamba chaiyo, tinogona kutsanangura chinongedzo kune sero (tinopinda nemaoko kana kudzvanya pairi patafura pachayo).
4. Tinowana chigumisiro musero rine basa.

Cherechedza:

Kushandura mhedzisiro inowanikwa mu radians kune madhigirii, unogona kushandisa basa "DEGREES". Kushandiswa kwayo kwakafanana nemashandisirwo ayo "ATAN".

mhedziso

Saka, iwe unogona kuwana iyo arc tangent yenhamba muExcel uchishandisa yakakosha ATAN basa, iyo fomula inogona kuiswa pakarepo nemaoko muchitokisi chaunoda. Imwe nzira ndeye kushandisa yakakosha Function Wizard, mune iyo kesi isu hatifanirwe kurangarira formula.