Mokhoa oa ho atisa Numere ho Google Spreadsheets

Tsela e bonolo ka ho fetisisa ea ho atisa linomoro tse peli ka Google Spreadsheets ke ho etsa foromo ka seleng ea lipampiri.

Lintlha tse bohlokoa tseo u lokelang ho li hopola ka liforomo tsa Google Spreadsheet:

01 ea 06

Ho sebelisa Litlhaloso tsa Cell ka Litlhahlobo

Tlhaloso ea ho atolosa Google Spreadsheets. © Ted French

Le hoja ho kena linomoro ka ho toba ka mokhoa o kang oa:

= 20 * 10

mesebetsi - joalokaha ho bontšoa moleng oa bobeli mohlala - hase tsela e molemo ea ho etsa litlhaloso.

Tsela e molemohali - e bontšitsoeng ka mela e mehlano le e tšeletseng - ke ho:

  1. Kenya linomoro hore li atolosoe ka lisele tse arohaneng tsa lipampiri;
  2. Kenya litšobotsi tsa sele bakeng sa lisele tse nang le data ka foromo ea phallo.

Litemana tsa lisele ke motsoako oa lengolo la molumo o totobetseng le nomoro ea mola o lekanang le lengolo le ngotsoeng le ngotsoeng kamehla - e kang A1, D65, kapa Z987.

02 ea 06

Melemo ea Likarolo tsa Cell

Hero Images / Getty Images

Litlhaloso tsa sele li sebelisoa ho khetholla sebaka sa data e sebelisitsoeng ka mokhoa o itseng. Lenane lena le bala likarolo tsa sele ebe joale li kenya lipalo ho lisele tsena ho ea sebakeng se loketseng.

Ka ho sebelisa li-cell reference ho e-na le lintlha tsa sebele ka mokhoa o mocha - hamorao, haeba ho hlokahala hore u fetole data , ke taba e bonolo ea ho nkela data liseleng ho e-na le hore u ngole mokhoa oo hape.

Ka tloaelo, liphello tsa foromo li tla fetola hang-hang ha data e fetoha.

03 ea 06

Ho Hlahisa Formula Example

Westend61 / Getty Images

Joalokaha ho bontšitsoe setšoantšong se ka holimo, mohlala ona o hlahisa foromo ka cell C4 e tla eketsa data ka cell A4 ka data A5.

Morero o phethiloeng ka seleng ea C4 e tla ba:

= A4 * A5

04 ea 06

Ho kenya Foromo

Boemo / Sam Edwards / Getty Images
  1. Tobetsa ka seleng ea C4 ho e etsa hore e be sele e sebetsang - ena ke moo liphello tsa foromo li tla bontšoa;
  2. Tšoaea letšoao le lekanang ( = ) ka seleng ea C4;
  3. Tobetsa seleng ea A4 e nang le pointer ea mouse ho kena selekaneng eo ea selefounong;
  4. Ngola letšoao la asterisk ( * ) ka mor'a A4;
  5. Tobetsa ho cell A5 e nang le pointer ea mouse ho kenya sele eo reference;
  6. Tobetsa konopo ea Kena ho lebokose ho tlatsa foromo;
  7. Karabo 200 e lokela ho ba teng ka seleng ea C4;
  8. Le hoja karabo e bontšoa ka seleng ea C4, ho tobetsa seleng eo ho tla bontšoa foromo ea sebele = A4 * A5 leboteng la foromo ka holim'a leqephe la mosebetsi.

05 ea 06

Ho fetola Data Formule

Guido Mieth / Getty Images

Ho lekola bohlokoa ba ho sebelisa lisele tsa sele ka mokhoa o itseng:

Karabo ka seleng ea C4 e lokela ho ntlafatsa ho fihlela ho 50 ho bontša phetoho ea data ka seleng ea A4.

06 ea 06

Ho fetola Foromo

Klaus Vedfelt / Getty Images

Haeba ho hlokahala ho lokisa kapa ho fetola foromo, tse peli tsa tse molemo ka ho fetisisa ke tsena: