Aikin la na ciki a Excel

Daya daga cikin sanannun ayyukan da ba su sanannu ba, wanda ake amfani da su a cikin lissafi, a cikin ka'idar bambance bambancen bambance-bambancen, a cikin ƙididdiga da kuma a cikin ka'idar mawuyacin aikina ne. Ayyukan warware ayyukan tare da shi yana buƙatar shiri mai mahimmanci. Bari mu gano yadda zaku lissafa wannan alamar ta amfani da kayan aikin fice.

Aikin Aikin

Aikin la na ciki yana da babban aikace-aikace da ka'idoji. Misali, ana yawan amfani dashi don magance daidaitattun daidaituwa. Wannan kalmar tana da wani suna daidai - da mahimmancin yiwuwar. A wasu halaye, tushen mafita shine gina tebur na dabi'u.

MALAMI MAI GIRMA.ST.SP

A Excel, ana magance aikin da aka kayyade ta amfani da ƙiyayya. St.SP. Sunansa ya ragu daga ajalin "tsarin rarraba al'ada". Tunda babban aikinta shine komawa zuwa ga sel mai girman kai na daidaitaccen rarraba al'ada. Wannan ma'aikaci yana nufin nau'in ƙididdigar ƙididdiga na daidaitattun ayyuka.

Are Excel 2007 kuma a farkon sigogin, wannan mai kiran ana kiranta MISTRAP. An bar shi cikin jituwa a cikin sigogin yau da kullun na aikace-aikace. Amma har yanzu, ana bada shawarar su amfani da ƙarin takwaransa na gaba - norm.stsp.

SynTax na Ma'aikata .St.r.rasp yayi kama da wannan:

= Kamma.stsSp (z; gaba ɗaya)

An rubuta Ma'aikata na Norstrap kamar haka:

= Normstp (z)

Kamar yadda muke gani, a cikin sabon rubutun, "mahimmin hujja" ga mahimmancin da ya kasance. Ya kamata a lura cewa kowace hujja ga wajibi ne.

Hujja "Z" tana nuna ƙimar adadi wanda aka gina da rarraba.

Hujja "Hujja" ƙimar ma'ana ce wacce zata iya samun wakilcin "gaskiya" ("1") ko "qarya" ("0"). A cikin farkon shari'ar, ana mayar da aikin rarraba mahaɗan zuwa ga tantanin halitta, kuma a cikin na biyu - nauyin nauyin rarraba.

Iya warware matsalar

Don aiwatar da lissafin da ake buƙata don m, ana amfani da wannan tsari:

= Ka'ida.stSp. (z; mafita (1)) - 0.5

Yanzu bari mu kalli amfani da ka'idodi. St.SPP don magance takamaiman aiki.

1. Mun nuna samfurin inda za'a nuna sakamakon da aka gama kuma danna aikin "Saka kayan" gunkin "wanda kusa da layi na dabara.



2. Bayan buɗe wa maye na ayyuka, muna zuwa rukunin "ƙididdigar" ƙididdigar "jerin haruffa". Ware sunan "Norm.st.spsp" kuma latsa maɓallin "Ok".



3. Kunna taga muhawara na ma'aikatan aiki. Mr.ras. A cikin filin "Z", muna shigar da canji ga wanda kuke so ku lissafa. Hakanan, ana iya wakiltar wannan hujja a matsayin tantanin halitta wanda ya ƙunshi wannan m. A cikin "hade" filin, muna shigar da darajar "1". Wannan yana nufin cewa mai aiki bayan lissafin zai dawo a matsayin mafita ga aikin hadin kai. Bayan an bi ayyukan, danna maɓallin "Ok".



4. Bayan haka, sakamakon sarrafa bayanan ke aiki ta hanyar sarrafa na'urori keyms.stppp za a nuna a cikin sel, wanda aka nuna a sakin farko na wannan littafin.



5. Amma wannan ba duka bane. Mun lissafta kawai rarraba ƙayyadaddun tsari na al'ada. Domin lissafta darajar aikin ku na ciki, kuna buƙatar ɗaukar lambar 0.5 daga gare ta. Select sel ya ƙunshi magana. A cikin dabara kirtani bayan ƙamus na ƙiyayya.St.SpSp. Ina ƙara darajar zuwa: -0.5.



6. Don yin lissafi, danna maɓallin Shigar. Sakamakon da aka samu kuma zai zama darajar da ake so.

Kamar yadda kake gani, lissafta aikin ku na don takamaiman darajar adadi na adadi a cikin shirin Excelon ba mai wahala bane. Don waɗannan dalilai, ƙiyayyun ka'idojin aiki. St.ras.