Formula uye mabasa muExcel

• Kuisa formula
• Kugadzirisa mafomula
• Operation Priority
• Kopa/Namira fomula
• Kupinza basa

Formula ishoko rinotara kukosha kwesero. Mabasa akafanotsanangurwa mafomula uye akatovakwa muExcel.

Somuenzaniso, mumufananidzo uri pasi apa, sero A3 ine formula inowedzera maseru kukosha A2 и A1.

Mumwe muenzaniso. Sero A3 ine basa SUM (SUM), iyo inoverengera huwandu hwehuwandu A1:A2.

=SUM(A1:A2)

=СУММ(A1:A2)

Kuisa formula

Kuisa fomula, tevera mirairo iri pasi apa:

1. Sarudza sero.
2. Kuita kuti Excel izive kuti unoda kuisa fomula, shandisa chiratidzo chakaenzana (=).
3. Semuenzaniso, mumufananidzo uri pazasi, fomula inoiswa inoverengera maseru A1 и A2.

   

Tip: Panzvimbo pekunyora nemaoko A1 и A2ingobaya pamasero A1 и A2.

4. Shandura kukosha kwesero A1 pane 3.

   

   Excel inoverengera otomatiki kukosha kwesero A3. Ichi ndicho chimwe chezvinhu zvine simba zveExcel.

Kugadzirisa mafomula

Paunosarudza sero, Excel inoratidza kukosha kana fomula muchitokisi mubhari yeformula.

1. 1. Kuti ugadzirise fomula, tinya pane fomula bar uye gadzirisa iyo fomula.

1. dzvanya pinda.

   

Operation Priority

Excel inoshandisa yakavakirwa-mukati kurongeka umo maverengero anoitwa. Kana chikamu chemafomula chiri mumaparenthesi, chinotanga chaongororwa. Zvadaro kuwanza kana kupatsanura kunoitwa. Excel inozowedzera uye kubvisa. Ona muenzaniso pazasi:

Kutanga, Excel inowedzera (A1*A2), wobva wawedzera kukosha kwesero A3 kune mhedzisiro iyi.

Mumwe muenzaniso:

Excel inotanga kuverenga kukosha mumaparentheses (A2 + A3), wobva wawedzera mhedzisiro nehukuru hwesero A1.

Kopa/namira fomula

Paunokopa fomula, Excel inogadzirisa otomatiki mareferensi ega rega rega sero iyo fomula inokopwa. Kuti unzwisise izvi, tevera matanho aya:

1. Isa fomura yakaratidzwa pazasi musero A4.

   

2. Simbisa sero A4, tinya pairi wobva wasarudza kuraira mufananidzo (Kopi) kana kudzvanya nzira yekudimbudzira kiibhodhi Ctrl + C.

   

3. Zvadaro, sarudza sero B4, tinya pairi wobva wasarudza kuraira Kuisa (Isa) muchikamu Paste Options (Namira Sarudzo) kana kudzvanya nzira yekudimbudzira kiibhodhi Ctrl + V.

   

4. Iwe unogona zvakare kukopa fomula kubva musero A4 в B4 kutambanudza. Simbisa sero A4, bata pasi kona yaro yezasi yekurudyi woikwevera kuchitokisi V4. Zviri nyore uye zvinopa mhedzisiro yakafanana!

   

   Mhinduro: Formula muchitokisi B4 inoreva kukosha muchikamu B.

   

Kupinza basa

Mabasa ese ane chimiro chakafanana. Semuyenzaniso:

SUM(A1:A4)

СУММ(A1:A4)

Zita rebasa iri ndere SUM (SUM). Mutsara uripakati pemabhuraketi (arguments) unoreva kuti tapa mutsara A1:A4 sekupinza. Iri basa rinowedzera kukosha mumaseru A1, A2, A3 и A4. Kuyeuka kuti ndeapi mabasa uye nharo dzekushandisa kune yega yega basa hakusi nyore. Sezvineiwo, Excel ine murairo Isa Basa (Isa basa).

Kuisa chinhu, ita zvinotevera:

1. Sarudza sero.
2. dzvanya Isa Basa (Isa basa).

   

   Bhokisi rebhokisi rezita rimwechete richaonekwa.

3. Tsvaga basa raunoda kana sarudza kubva muchikamu. Somuenzaniso, unogona kusarudza basa COUNTIF (COUNTIF) kubva muchikamu nhamba (Statistical).

   

4. dzvanya OK. A dialog box ichaonekwa Basa Kukakavara (Nhau dzebasa).
5. Dzvanya bhatani kurudyi kwemunda - (Range) uye sarudza renji A1:C2.
6. Dzvanya mumunda Zvikonzero (Criterion) uye isa "> 5".
7. dzvanya OK.

   

   Mhinduro: Excel inoverenga nhamba yemasero ane kukosha kwakakura kupfuura 5.

   =COUNTIF(A1:C2;">5")

   =СЧЁТЕСЛИ(A1:C2;">5")

   

Cherechedza: Panzvimbo yekushandisa "Isa basa“, ingonyora =COUNTIF(A1:C2,”>5”). Paunonyora »=COUNTIF(«, pachinzvimbo chekunyora nemaoko “A1:C2”, sarudza rudzi urwu negonzo.