Mutungamiri weMutangisi weExcel Formulas

Kungodzidza nezvemafomu? Uyu ndiwo mutungamiri wenyu

Zvinyorwa zvese zvinokubvumira kuti uite maverengero pane nhamba ye data inowanikwa mune pepa .

Zvimwe zvinyorwa zvinogona kushandiswa kuti zvigadziriswe nhamba, zvakadai sokuwedzera kana kubvisa, pamwe chete nezvakaoma zvakawanda, zvakadai sekubviswa kwebhadharo, kuwana chiyero chemudzidzi pamigumisiro yekuedza, uye kuverenga kutora chikwereti.

Uyezve, kana shanduro yacho yakapinda zvakarurama uye data inoshandiswa mumusarudzo inoshanduka, nekutadza, Excel ichadzokorora zvakare nekuvandudza mhinduro.

Izvi zvinyorwa zvinowedzera mukana wekusika uye kushandisa mapurogiramu, kusanganisira danho-nhanho chienzaniso chekukosha kweExcel formula.

Icho chinosanganisirawo yakaoma yakawanda muenzaniso inoratidzika pane zvakarongeka zve Excel yekushanda kuverenga mhinduro yakarurama.

Dzidzo yakagadzirirwa kune avo vane zvishoma kana kuti vasina ruzivo mukushanda nemapurogiramu epadheseti akadai seEexcel.

Cherechedza: Kana iwe uchida kuwedzera imwe koromo kana mutsara wemanhamba, Excel yakavakwa mumushonga unonzi SUM basa rinoita kuti basa rikurumidze uye rive nyore.

Excel Formula Basics

Kunyora shanduro yepadheseti yakasiyana zvakanyanya pane kunyora rimwe mukirasi yechikoro.

Nguva dzose Tanga neEqual Sign

Kusiyana kunonyanya kukosha kuve iyo muExcel, mavara anotanga nechiratidzo chakaenzana ( = ) pane kupedza nayo.

Zvimwe mazita akafanana neaya:

= 3 + 2

pane ku:

3 + 2 =

Zvimwe Zvimwe

• Chiratidzo chakaenzana nguva dzose chinopinda muchitokisi umo unoda mhinduro yefomula kuonekwa.
• Chiratidzo chakaenzana chinopa Excel kuti izvo zvinotevera chikamu chemuumbi, uye kwete zita kana nhamba.
• Sezvinoratidzwa mumufananidzo wepamusoro, wakambopinda, sero rine rondedzero rinoratidza mhinduro, panzvimbo yeyo fomu.
• Nzira yacho inogona kuonekwa nguva dzose mubhokisi yepamusoro iri pamusoro pebasa.

Kushandisa Chirongwa Chema Cell mu Excel Formulas

Kunyange zvazvo rondedzero iri papeji yekare inoshanda, ine dambudziko guru-Kana uchida kushandura dhesi rinoshandiswa mumutsetse, unofanira kuchinja kana kunyorazve fomu.

Kuvandudza Murairi: Kushandisa Zviratidzo zveShona

Nzira iri nani ndeyokunyora chimiro kuitira kuti data ishanduke kusina kuchinja shanduko pachayo.

Izvi zvinogona kuitwa kuburikidza nekuisa deta mumashandisi ekushanda mapeji uye zvino kuzivisa purogiramu iyo masero ane data inoshandiswa mumutambo.

Nenzira iyi, kana data yefomula inoda kuchinjwa, inoshandiswa nekuchinja data mumasero ekushandura, pane kuchinja maitiro acho pachako.

Kuti uudze Excel izvo masero ane data yaunoda kushandisa, sero rimwe nerimwe rine kero kana kuti seferensi yekuverenga .

About References References

• Sero ndiyo nharo yepakati-kati pakati penhivi dzakatenderera uye mutsara wakanyatsopinda mubasa rekushanda.
• Chikamu chimwe nechimwe chinoratidzwa netsamba iri pamusoro pekamuri-yakadai seA, B, C.
• Mutsara mumwe nomumwe unoratidzwa nenhamba iri kuruboshwe rwomuganhu-wakadaro 1, 2, 3.
• Sero rinoreva, ikozvino, inosanganiswa yemutsara wepeyori uye mutsara wenhamba iyo inopindira pane imwe nzvimbo - seA1 , B2 , C3 , kana W345.
• Paunonyora zvinyorwa zvinyorwa, tsamba yekhoma nguva dzose inouya pakutanga.

Kuti uwane sero rinotarisa, tongotarisa kumusoro kuti uone kuti ndechipi chikamu sero iri mukati, uye ipapo tarisa kuruboshwe kuti uwane mutsara iwoyo urimo.

Sero iripo - iyo inoreva seni iri ikozvino yakanamatira - inoratidzwawo muBhokisi Razita riri pamusoro pe column A mune pepa rekushanda.

Saka, panzvimbo yekunyora iyi fomu musero D1:

= 3 + 2

Zvingava zviri nani kupinda mu data mumasero C1 neC2 uye nyora iyi fomu pane:

= C1 + C2

Excel Basic Formula Example

Uyu muenzaniso unopa nhanho nhanho mirayiridzo yekuumba yakakosha Excel fomu yakaonekwa mumufananidzo uri pamusoro.

Chipiri, muenzaniso wakaoma kunzwisisa mashandisi emasvomhu uye kusanganisira urongwa hweExcel hwekushanda hunowanikwa papeji yekupedzisira yekudzidzisa.

Kupinda Tutorial Data

Zvinowanzoita kuti utange kuisa zvose data mumushandi webasa usati watanga mazano. Izvi zvinoita kuti zvive nyore kutaurira kuti zviyero zvitsanangudzo zvinodikanwa sei kuiswa mubumbiro.

Kuisa deta mumusero webhesi yepurogiramu isitiro mbiri:

1. Tora iyo data muchikamu.
2. Dhinda pikicha inopinda mubhobhoyo kana tora pane imwe sero. ine mouse inogadzirisa kuti upedze kupinda.

Tutorial Steps

1. Dzvanya pachitokisi C1 kuti uite sero rinoshanda.
2. Tora 3 mukati memusero uye diya Enter Enter pakhibhodi.
3. Kana zvichidikanwa, chengeta pane cell C2 .
4. Tora 2 muchipinda mumusero uye diya Enter Enter pakiti.

Kupinda Muforomo

1. Dzvanya pane sero D1 - iyi ndiyo nzvimbo iyo migumisiro yefomu ichaonekwa.
2. Nyora iyi inotevera fomu mu cell D1: = C1 + C2
3. Dhinda pikicha inopinda mubhokisi kuti upedze fomu.
4. Mhinduro 5 inofanira kuonekwa muchitokisi D1.
5. Kana iwe ukatora pane cell D1 zvakare, basa rakakwana = C1 + C2 rinowanikwa mubhadha yepamusoro pane pepa pepaji.

Kuvandudza Mufomu - Zvakare: Kupinda Mune Zvinyorwa Zvinyorwa neKutsanangura

Kunyora muchitokisi zvinyorwa sechikamu chemuumbiro inzira inobvumirwa yekupinda-sekusimbiswa nemhinduro ye5 muchitokisi D1 - haisi iyo nzira yakanakisisa yekuita nayo.

Nzira yakanakisisa yekupinda majekiseni echitsauko mumushonga ndeyekushandisa kunongedza.

Kutaura kunosanganisira kuvhara masero ane pointer ye mouse kuti apinde muchitokisi cheseferensi muchirevo. Kubudirira kukuru kwekushandisa kunongedzera ndechokuti kunobatsira kubvisa zvikanganiso zvingave zvichikonzerwa nekunyora mune zvisina kukodzera sero reference.

Mirayiridzo iri papeji inotevera inoshandisa kuisa majekesero esero yefomu iri muchitokisi D2.

Kushandisa Kuratidza Kupinda Kwemaferensi Mumagetsi muExcel Formula

Iyi danho iri mukudzidzisa rinoshandisa purogiramu yeguru kuti uise zvinyorwa zvinyorwa zvefomu iri muchitokisi D2.

1. Dzvanya pane cell D2 kuti iite iyo inoshanda masero.
2. Tora mufananidzo wakaenzana ( = ) muchitokisi D2 kutanga fomu.
3. Dzvanya pachitokisi C1 pamwe nehope pointer kuti uise seferensi yesero mufomu.
4. Tora imwe chiratidzo ( + ).
5. Dzvanya pachitokisi C2 pamwe nemushonga pointer kuti upinde wechipiri seferensi yekutsvaga mumutsetse.
6. Dhinda pikicha inopinda mubhokisi kuti upedze fomu.
7. Mhinduro 5 inofanira kuonekwa muchitokisi D2.

Kuvandudza Iforomu

Kuti uedze kukosha kwekushandisa masero zvinyorwa mufomula ye Excel, shandura dhesi iri muchitokisi C1 kubva pa3 kusvika ku6 uye shandisa diki yeKuisa pane keyboard.

Mhinduro dzemasero maviri D1 uye D2 dzinofanira kunge dzichinyatsochinja kubva pa5 kusvika ku8, asi maitiro acho ose ari maviri anoramba asingashanduki.

Mathematical Operators uye Mutemo weKushanda

Sezvinoratidzwa nemuenzaniso wakarurama-wakagadzirwa, kuumba mafomu muMicrosoft Excel hakusi nyore.

Iyo inongova nyaya yekubatanidza, nenzira yakarurama, sezvikamu zvinyorwa zvepa data yako neyakakodzera mashematical operator.

Mathematical Operators

Mathematical operators anoshandiswa mu Excel mazwi akafanana neaya anoshandiswa mumatunhu ekirasi.

• Kubvisa - kudisa chiratidzo ( - )
• Kuwedzera - pamwe nechiratidzo ( + )
• Kurambidza - mberi slash ( / )
• Kuwedzera - asterisk ( * )
• Exponentiation - caret ( ^ )

Mutemo weKushanda

Kana vakawanda kupfuura imwe yevashandi vanoshandiswa mumutsetse, kune urongwa humwechete iyo Excel inotevera kutevera izvi masvomhu maitiro.

Iri urongwa hwekushanda rinogona kuchinjwa nekuwedzera mabhakiti kune equation. Nzira iri nyore yekuyeuka kurongeka kwekushanda ndekushandisa shanduro iyi:

BEDMAS

Mutemo wekushanda ndewe:

B rackets E xponents D kugunun'una M kukurudzira Chirevo S kubtraction

Kuti Mutemo weKushanda Unoshanda sei

• Chero basa chero ripi zvaro riri mune mabheji richaitwa kutanga rinoteverwa nemamwe mavara.
• Mushure meizvozvo, Excel inofunga kubatana kana kuwedzera pakuita mabasa ekuenzanisira, uye inoita mabasa aya nenzira iyo inoitika kuruboshwe kuenda kurudyi mu equation.
• Izvo zvinoenda kune mamwe maviri anotevera kushanda nekuwedzera. Vanonzi vanoenzana muhutano hwekushanda. Kunyangwe imwe inotanga kuonekwa muy equation, kana kuwedzera kana kubvisa, ndiko kushanda kwakaitwa kutanga.

Muenzaniso: Kushandisa Multiple Operators uye Mutemo weKushanda muExcel Formula

Pane peji rinotevera mune mirayiridzo yekugadzira fomu inosanganisira dzakawanda mashematical operators uye inoshandisa urongwa hweExpcel yekushanda kuverenga mhinduro.

Kushandisa Multiple Operators mu Excel Formulas

Uyu muenzaniso wechipiri wechimiro, unoratidzwa mumufananidzo uri pamusoro, unoda kuti Excel ishandise urongwa hwemabasa ekuverenga mhinduro.

Kupinda Data

1. Vhura mahwendefa ebasa risina chinhu uye nyora data inoratidzwa mumasero C1 kusvika kuC5 mumufananidzo uri pamusoro.

A More Complex Excel Formula

Shandisa zvinongororwa pamwe neakakodhi akakodzera uye mashematical operators kuisa inotevera inomira muchitokisi D1.

= (C2-C4) * C1 + C3 / C5

Dhinda pikicha inopinda pabhodhi kana wapedza uye mhinduro -4 inofanira kuonekwa muchitokisi D1. Zvinyorwa zvekuti Excel inotora sei mhinduro iyi yakanyorwa pasi apa.

Tsanangudzo Dzakananga yekupinda Muforomo

Kana iwe uchida rubatsiro, shandisa matanho ari pasi apa kuti upinde maitiro.

1. Dzvanya pane sero D1 kuti uite sero rinoshanda.
2. Tora chiyero chakakwana ( = ) muchitokisi D1.
3. Tora bhora rakazaruka bracket " ( " shure kwechiratidzo chakangofanana.
4. Dzvanya pachitokisi C2 pamwe nemushonga wepiguru kuti uise seferensi yechipinda mumutsetse.
5. Tora minus sign ( - ) mushure meC2.
6. Dzvanya pachitokisi C4 kuti uise iko rekero rekuisa mumutsetse.
7. Tora bhivha rekuvhara " ) " mushure meC4.
8. Tora chiratidzo chekuwedzera ( * ) mushure mekuvhara mabhirikiti.
9. Dzvanya pachitokisi C1 kuti ugoona iyi seferensi iri mumutsetse.
10. Tora imwe chiratidzo ( + ) mushure meC1.
11. Dzvanya pachitokisi C3 kuti uise mutsetse wekero iri mumutsetse.
12. Tora chikamu chekuparadzanisa ( / ) mushure meC3.
13. Dzvanyira pane cell C5 kuti uise mutsetse wekero iri mumutsetse.
14. Dhinda pikicha inopinda mubhokisi kuti upedze fomu.
15. Mhinduro -4 inofanira kuonekwa muchitokisi D1.
16. Kana iwe ukatora pane cell D1 zvakare, iyo yakakwana basa = (C2-C4) * C1 + C3 / C5 inowanikwa mubhairi yepamusoro pane pepa pepaji.

Iyo Excel Inoshandisa Sei Murairi Mhinduro

Excel inosvika pane mhinduro ye--4 yemuchina wepamusoro uchishandisa mitemo yeBEDMAS yekuita mabasa akasiyana-siyana emasvomhu nenzira inotevera:

1. Excel inotanga kubvisa basa rekubvisa (C2-C4) kana (5-6), sezvo rakapoteredzwa mabheji, uye rinowana mhinduro ye--1.
2. Zvadaro purogiramu yacho inowedzera kuti -1 ne7 (zviri mukati yesero C1) kuwana mhinduro -7.
3. Zvadaro Excel inopfuurira mberi kuti iparadzanise 9/3 (zvinyorwa zveC3 / C5) sezvo inosvika kusati yawedzerwa muBEDMAS, kuwana mhinduro ye3.
4. Basa rekupedzisira rinoda kuitwa ndeyekuwedzera -7 + 3 kuti uwane mhinduro yemhando yose ye -4.