Excel Musiyano Fomula: 4 nzira dziri nyore

Kuverengera kwemusiyano ndeimwe yezviito zvakakurumbira mune masvomhu. Asi kuwanda uku hakuna kunyorwa kwete musainzi chete. Isu tinogara tichizviita, tisina kana kufunga, uye muhupenyu hwezuva nezuva. Semuenzaniso, kuitira kuti uverenge kutumirwa kwekutenga muchitoro, zvinoshandiswawo kuverenga mutsauko uripo pakati pehuwandu hwaakapihwa mutengesi, uye mutengo wezvinhu. Ngatione kuti ungaverenga sei mutsauko mukubuditsa kana uchishandisa dzakasiyana siyana data mafomu.

Kuverenga kwemusiyano

Kufunga nezveBudiriro iyo inoshanda pamwe dzakasiyana siyana data mafomu, kana uchibvisa kukosha kumwe kubva kune imwe, dzakasiyana mafomu efomasi rinoshandiswa. Asi kazhinji, zvese zvinogona kuderedzwa kune imwe chete mhando:

X = A-B

Uye ikozvino ngatitarisei kuti zvinokosheswa zvevakasiyana mafomu anoiswa pasi: Nhamba, mari, mazuva uye nguva.

Nzira 1: Bvisa nhamba

Pakarepo ngatimboonai zvakanyanya kushanda zvakasiyana-siyana zvekuverenga musiyano, zita rekuti kuiswa kwehuwandu hwehuwandu. Nezvimwe zvinangwa, chimiro chesvomhu chemasvomhu nechiratidzo "-" chinogona kuiswa muExle.

1. Kana iwe uchifanira kuita kuti ugare pasi pekutanga kwehuwandu nekushandisa Excel, seCalculator, wozoisa iyo "=" chiratidzo muchitokisi. Ipapo pakarepo mushure meiyi chiratidzo, nhamba yakaderera kubva kukhibhodi inofanira kunyorwa, isa chiratidzo "-", uye wozorekodha iyo yakadzorwa. Kana iwe ukabvisirwa zvimwe, saka iwe unofanirwa kuisa iyo "-" chiratidzo zvakare uye rekodha iyo nhamba yaunoda. Maitiro ekushanduka kwechiratidzo chemasvomhu uye nhamba dzinofanirwa kuitwa kusvikira ese mashoma apinda. Semuenzaniso, kubva pakati pegumi gumi nembiri 5 ne3, iwe unofanirwa kunyora iyo inotevera formula kune iyo Excel sheethos:

   = 10-5-3.

   Mushure mekunyora chirevo, kuwana mhedzisiro yekuverenga, tinya pane iyo Enter Key.



2. Sezvauri kuona, mhedzisiro yakaonekwa. Yakaenzana nenhamba yechipiri.

Asi kazhinji kazhinji kazhinji ndiyo nzira yekubvisa muExcel inoshandiswa pakati pehuwandu dzakaiswa mumasero. Panguva imwecheteyo, iyo algorithm yekuita kwemasvomhu haina kuchinja, chete zvino pachinzvimbo chehurukuro dzerudzidziso, zvinongedzo kumasero anoshandiswa, kwavanowanikwa. Mhedzisiro yacho inoratidzwa muchinhu chakaparadzana chebepa, pane hunhu "=" rakaiswa.

Ngatione kuti ungaverenga sei mutsauko pakati pemahara 59 ne26, iri zvakateerana mune zvinhu zvepepa nehurongwa hweA3 uye C3.

1. Sarudza chinhu chisina chinhu chebhuku ratiri kuronga kuratidza mhedzisiro yekuverenga kwemusiyano. Isu tinoisa mariri chiratidzo "=". Mushure meizvozvo, tinya pane cell A3. Isu tinoisa chiratidzo "-". Tevere, isu tinoita tinya pane chinhu cheC3 pepa. Iyo inotevera fomu inofanirwa kuoneka muchinhu chebepa kuti chibudise mhedzisiro:

   = A3-C3

   Sezvazviri kare, kuratidza mhedzisiro pachiratidziro, tinya kiyi yekupinda.



2. Sezvatinoona, mune iyi nyaya kuverenga kwakaitwa zvinobudirira. Iko kuverenga kwemhedzisiro yakaenzana neiyo nhamba 33.

Asi kutaura zvazviri, mune zvimwe zviitiko, zvinodikanwa kuti uite kuti uise pasi apo ivo vachatora chikamu, zvese zvakananga manhamba ehuwandu uye zvinongedzo kune masero ivaiwanikwa. Naizvozvo, kutaura, semuenzaniso, seinotevera:

= A3-23-C3-E3-5

Chidzidzo: Maitiro ekubvisa nhamba kubva pakati peExapa

Nzira 2: Cash Fomati

Kuverengera kwetsika mune mari yemari haina kusiyana neyenzi. Maitiro akafanana anoshandiswa, kubva, uye uye akakura, chimiro ichi chimwe chezvisarudzo zvehuwandu. Musiyano ndewekuti chete pakupera kwetsika kutora chikamu mukuverenga, chiratidzo chemari yemari yakatarwa chinosimbiswa.

1. Chaizvoizvo, iwe unogona kuitisa kuvhiyiwa seyakajairwa kugovaniswa kwenhamba, uye chete wobva wapomora mhedzisiro yekupedzisira yemhando yemari. Saka, tinogadzira kuverenga. Semuenzaniso, ichabvisa kubva pane gumi neshanu nhamba 3.



2. Mushure meizvozvo, tinya pane pepa chinhu, icho chine mhedzisiro. Mune menyu, sarudza kukosha kweiyo "cell form fomati ...". Panzvimbo pekufona mamiriro menyu, iwe unogona kunyorera mushure mekusarudzwa kweCTRL + 1 makiyi.



3. Nechero ipi neipi sarudzo mbiri dzakataurwa, hwindo rekugadzira rinotangwa. Famba mu "Chikamu" Chikamu. Mu "Nhamba dzeNhama" dzinofanira kucherechedzwa "mari" sarudzo. Panguva imwecheteyo, minda yakasarudzika ichaonekwa kurudyi kwewindows yepahwindo, mauri kusarudza iyo mhando yemari uye nhamba yezviratidzo zvecustomal. Kana iwe uine Windows seyese uye Microsoft Office, kunyanya, yakanangana neRussia, saka nokusvibiswa panofanirwa kuve nechiratidzo chekutanga, uye mumunda wezviratidzo zvechinyorwa, nhamba "2". Muhuwandu hwakawanda hwezviitiko, marongero aya haadiwe. Asi, kana iwe uchiri kuda kuwerengera mumadhora kana pasina zviratidzo zvechinyorwa, zvinodikanwa kuti vagadzirise zvinodiwa.

   Kutevera kuti shanduko dzese dzinodiwa dzinoitwa here, ivhu pane "ok".



4. Sezvatinogona kuona, mhedzisiro yekubvisa muchitokisi yakashandurwa kuita mari yemari ine nhamba yakatarwa yezviratidzo.

Pane imwezve sarudzo yekugadzira iyo inokonzeresa kudzima mari yemari. Kuti uite izvi, iwe unofanirwa kudzvanya paRibbon mu "Imba" tab iri paTriangle iri kurudyi kweiyo nzvimbo yekuratidzira yeiyo Cell Fommence mu "Nhamba" Toolbar. Kubva pane yekutanga chinyorwa, sarudza iyo "mari" sarudzo. Manhamba ehuwandu anoshandurwa kuita mari. Chokwadi, mune ino kesi, hapana mukana wekusarudza mari uye nhamba yezviratidzo zvechinyorwa. Musiyano wakaiswa mune iyo default system, kana yakagadzirirwa kuburikidza newindo rekugadzira rinotsanangurwa nesu pamusoro.

Kana iwe ukaverenga musiyano uripo pakati pehunyanzvi mumasero atove wakaumbwa nemhando yemari, wobva watonga zvinhu zveshizha kuti zvibudise mhedzisiro hazvitombodikanwa. Izvo zvichave zvakagadzirirwa zvoga pasi peiyo fomu yakakodzera mushure mekunge formula yapinda pamwe neZvinhu zvine manhamba akaderedzwa uye akanyorwa, pamwe nekudzvanya pane iyo Enter Entery kiyi.

Chidzidzo: Ungachinja sei cell yemhando muExcel

Nzira 3: Mazuva

Asi kuverenga kwemashure musiyano ane zvakakosha nuces pane imwe yapfuura sarudzo.

1. Kana isu tichida kubvisa imwe nhamba yemazuva kubva pazuva rakatsanangurwa mune chimwe chezvinhu zviri papepa, ndokutanga pane zvese zvakaisa iyo "=" chiratidzo mune icho chinhu icho mhedzisiro yekupedzisira icharatidzwa. Mushure meizvozvo, tinya pane iyo pepa chinhu, uko zuva riripo. Kero yayo icharatidzwa mune iyo yekubuditsa chinhu uye mune formula tambo. Tevere, isu tinoisa chiratidzo "-" uye tyaira huwandu hwemazuva kubva kukhibhodi kuti iwe unofanirwa kubvisa. Kuitira kuti uverenge ivhu iri pinda.



2. Mhedzisiro yacho inoratidzwa muchitokisi yakasarudzwa nesu. Mune ino kesi, chimiro chayo chinotozoshandurwa mumutambo wezuva. Saka, tinowana zuva rakazara-rakazara.

Kune zvakare mamiriro ezvinhu anotsausa kana zvichidikanwa kubva kune rimwe zuva kuti abvise mumwe uye kusarudza mutsauko pakati pavo mumazuva.

1. Isa hunhu "=" muchitokisi panofanira kuratidzwa. Mushure meizvozvo, isu tine ivhu pane chinhu chebepa, uko nguva yazva iripo. Pashure pokunge kero yaro yakaonekwa mufomula, isu tinoisa chiratidzo "-". Ivhu muchitokisi rine zuva rekutanga. Ipapo ivhu pane pinda.



2. Sezvauri kuona, chirongwa ichi chakanyatsoverenga nhamba yemazuva ari pakati pemazuva akataurwa.

Zvakare, musiyano uripo pakati pemisi unogona kuverengerwa uchishandisa basa rekugadzirisa. Zvakanaka nekuti zvinokubvumira kuti ugadzirise nerubatsiro rweimwe nharo, mune zvikamu zvipi zvekuyera zvichawanikwa mutsauko: mwedzi, mazuva, nezvimwe. Iko kushushikana kwenzira iyi ndeyekuti basa racho nemabasa richiri kuoma kupfuura naro madekwana mafomula. Uye zvakare, iyo Solute Operator arikushaikwa mune rondedzero yemabasa emabasa, uye saka ichafanirwa kugoverwa mumabasa nekushandisa iyo inotevera syntax:

= Mirairo (nach_data; kon_dat;

Iyo "yekutanga zuva" kupokana, iyo iri yekutanga zuva kana kutaura nezvayo, iri mune chinhu pane pepa.

Iyo "yekupedzisira zuva" kupokana muchimiro chezuva rinotevera kana chinongedzo pazviri.

Nharo inonakidza kwazvo "imwe". Nayo, unogona kusarudza sarudzo chaizvo kuti mhedzisiro icharatidzwa sei. Inogona kugadziriswa uchishandisa zvinotevera kukosha:

• "D" - mhedzisiro inoratidzwa mumazuva;
• "M" - Mutsoka yakazara;
• "Y" - Mumakore akazara;
• "Yd" - mutsauko mumazuva (kunze kwemakore);
• "MD" mutsauko mumazuva (kunze kwemwedzi nemakore);
• "Ym" musiyano mumwedzi.

Saka, kwatiri, zvakakodzera kuverenga mutsauko mumazuva pakati pemay 27 kusvika Kurume 14, 2017. Aya mazuva anowanikwa mumasero ane marongero b4 uye D4, zvichiteerana. Isu tinogadza iyo inotsemura mune chero chinhu chisina chinhu chebepa chinhu, kwatinoda kuona mhedzisiro yekuverenga, uye nyora pasi nzira inotevera:

= D4; B4; "D")

Isu tinodzvanya pinda uye tinowana mhedzisiro yekupedzisira yekuverenga kwemusiyano 74. Zvirokwazvo, pakati pemazuva ano ari mazuva makumi manomwe nemashanu.

Kana zvichidikanwa kubvisa misi imwe chete, asi isina kuvapinda mumasero epa pepa, ipapo mune ino nyaya tinoshandisa nzira inotevera:

= Ottit ("03/14/2017"; "27.05.2017"; "D")

Zunza bhatani rePinda zvakare. Sezvatinoona, mhedzisiro yacho yakasikwa yakafanana, yaingowana zvishoma neimwe nzira.

Chidzidzo: Nhamba yemazuva ari pakati pematanho muExcle

Nzira 4: Nguva

Iye zvino takaswedera pakudzidza kweiyo algorithm nguva yekureba muExle. Nheyo huru inosara yakafanana nekwavanobvisa misi. Iwe unofanirwa kubvisa mangwanani kubva pane imwe nguva inotevera.

1. Saka, tiri kusarudza rokuwana sei maminitsi akawanda akapfuura kubva 15:13 kusvika 22:55. Tinonyora izvi nguva netsika munzvimbo muzvitokisi pamusoro jira. Chii kunakidza, tapinda data, jira zvirimo zvichaparadzwa rwoga mashoko pasi zviri kana havana mashoko pamberi. In zvakashandurwa nyaya, vachafanira Format pasi musi manually. Muchitokisi kuti, umo mugumisiro kubvisa ichaparadzwa uratidzwe, tinoisa mutambi "=". Takabva clasme kuti chinhu chine nguva pashure (22:55). Mushure kero unoratidzwa nenzira yemaitiro, isu kupinda mutambi "-". Ikozvino tiri ivhu riri chinhu pamusoro jira umo tanga nguva iri (15:13). Kwatiri, kuti nzira yacho fomu:

   = C4-E4

   Kuverenga dope KUPINDA.



2. Asi, sezvo tinoona, mugumisiro rakaratidzwa zvishoma kwete muchimiro umo zvatakakumbira. Taida kusiyana chete mumaminitsi, uye rakaratidzwa maawa 7 maminitsi 42.

   Kuti tiwane zvishoma, tinotevedzera rapfuura mugumisiro kuti muwande nokuda coefficient 1440. coefficient iyi yaunganidzwa vachiwedzera kuwanda maminitsi neawa (60) uye maawa mumazuva (24).

Saka, akaisa "=" chiratidzo muchitokisi chinhu pamusoro jira. Pashure paizvozvo, tinobudisa tinya kuti chinhu jira, umo kusiyana nguva Tikabvisa iri (7:42). Mushure Coordinates foni iyi vakanga akaratidza muna yemaitiro, tinya "Muwande" chiratidzo (*) pamusoro keyboard, uye ipapo nemiwo kunhonga nhamba 1440. Kuti kuwana mugumisiro nevhu pamusoro KUPINDA.



3. Asi, sezvo tinoona, zvakare pamusana akazviratidza kururama (0:00). Izvi imhaka yokuti kana vachiwedzera mashizha chinhu yakanga yaibva reformatted panguva format. Kuti kuita musiyano mumaminitsi, tinofanira kudzokera mukuru zvinowanika pazviri.



4. Saka, isu govera sero ichi uye mu "Home" Tab kubudikidza dope kare zvaizivikanwa Triangle kwatiri kuenda kurudyi pamanyorerwo kuratidza munda. Munyaya kusashanda Pamazita, kusarudza "General" kuita.

   

   Unogona kupinda zvakasiyana. Sarudza wainyatsotaura jira chinhu achizviendesa Ctrl + 1 kiyi. The formatting hwindo iri raparurwa zvatakakuitirai kare apindura kwokutanga. Ibva munzvimbo "Number" Tab uye pakarongwa Numeric zvinogona, kusarudza "General" kuita. Ivhu pane "ok".



5. Pashure kushandisa chero dzakasiyana idzi, sero riri reformatted neimwewo format. It anoratidza kusiyana yakanatsa nguva mumaminitsi. Sezvaunogona kuona, musiyano pakati 15:13 uye 22:55 iri maminitsi 462.

Chidzidzo: sei kushandura wachi mumaminitsi muna Excel

Sezvatinoona, iyo nuChinters yekuverenga mutsauko mukuratidzira kunoenderana nemashandisirwo emushandisi ane data. Asi, zvakadaro, iyo nheyo huru yekusvika pakuita uku kwemasvomhu inoramba isina kuchinjika. Izvo zvinodikanwa kuti ubvise zvakasiyana kubva kune imwe nhamba. Izvi zvine hunyanzvi kuti uwane maficha emasvomhu adzoshandiswa zvichienderana neiyo yakakosha Excel Syntax, pamwe nekushandisa mabasa akanyudzwa.