Kodi kuwerengera gawo mu kupambana

Ntchito mu "Eksele", mukhoza kugwira ntchito zosiyanasiyana, kuphatikizapo masamu. A zipangizo zosiyanasiyana mapulogalamu amalola inu kubala zochita chofunika musati amafuna mapulogalamu zina. Wina mbali zoterozo ndi unit - mu kupambana, amagwiritsidwanso ntchito kamodzikamodzi, koma cholinga yofunika.

ndi gawo chimene

Ndi tanthauzo, gawo - ndi ntchito masamu kuti akubwerera phindu mtheradi zingapo, mwachitsanzo, chiwerengero popanda chizindikiro ake. Ngakhale ntchito yeniyeni gawo Tingaone osati kuthetsa mavuto masamu, komanso zitsanzo zachuma, sayansi ndi sayansi zina zambiri.

Kodi kuwerengera gawo "Eksele"?

Pofuna kuwerengera gawo mu kupambana, mungagwiritse ntchito mu njira zingapo, chophweka amene ali ABS ntchito. Limabwerera ubwino wachilengedwe manambala osankhidwa kapena mawu masamu.

The malembedwe a ntchito gawo lophweka - mu "Eksele" ndi chokwanila mwachindunji mu chilinganizo bala "= ABS", ndipo mu parentheses akusonyeza mkangano, zomwe zingakhale ndi anthu angapo, selo Buku, komanso ntchito kuti akubwerera mtengo M'ndandanda. Komanso ntchito izi zikhoza kutheka mwa kuwonekera kwa "Ikani Ntchito", imene kusankha njira yoyenera, kapena mwa kufunafuna ndi kulowa mawu akuti "gawo" kapena "ABS".

Kuwerengetsa kuchuluka kwa zigawo

Imodzi mwa ntchito ambiri kupambana - Uwerenge modulo. Timatha kuwonjezera mfundo maselo mosatengera kuti chizindikiro chawo. Kuti apange amenewa si chofunika kuwerengera nambala yoyamba ya lililonse gawo, kenako ntchito ntchito ndalama.

Pamene akuchita opareshoni kugwirizana ndi mfundo angapo mu kupambana gawo mwina ntchito imodzi ndi akonzedwa kapena osiyanasiyana maselo. Choncho, kuwerengera ndalama modulo zokwanira ntchito zotsatirazi dongosolo kafufuzidwe:

= Ndalama (ABS (A1: A4))

Apa ndime A choyamba mizere anayi muli mfundo imene mufuna kubala modulo.

zitsanzo

Kulimbitsa kumvetsa zokhudza gawo mu kupambana ndi mmene ntchito, m'pofunika kuganizira angapo zitsanzo yosavuta zimene zimasonyeza kugwira ntchito.

Pakuti mawerengedwe amodzi chiwerengero anakonzeratu kapena Mwachitsanzo masamu Mwachitsanzo, kusiyana 2 ndi 5, ntchito kulowa zotsatirazi:

= ABS (2-5)

The chifukwa cha kafufuzidwe ili ndi chiwerengero "3".

Ngati chofunika kuwerengera ndalama za zigawo za zinthu masanjidwewo amene makhalidwe awo analembedwa gome, ndi mndandanda wa A1: C3, njira yachangu kupeza yankho ndi kapangidwe:

= Ndalama (ABS (A1: C3))