The yokuita "kupesana" kuna Excel - zvinhu zvinotaurwa uye mienzaniso kushandiswa

Users vajaira kushanda pamwe zvokuimba imwe spreadsheet kushanda "Excel" kubva "Microsoft", dzimwe nguva vachiedza kuwana vakagadzirira akagadzirwa mashandiro kuti kuparadzanise nhamba mumwe nomumwe. Asi hakuna zvakadaro basa, uye kushandisa muura sezvo hazvina - zviri "Excel" rinotarisirwa kureva kuwanda. The yemaitiro weboka kuna Excel - chiri chiratidzo backslash (/).

How kukamura nhamba mumwe nomumwe

Mu "Excel" bhuku pepa mhando muzvitokisi zvakasiyana chero nhamba mbiri. Zvichakubatsira kukurira sei kuti kupesana inonyatsoita muna Excel. Ipapo sero vakasununguka mhando kutanga payakavakirwa (vakaenzana =) uye kusarudza sero wokutanga divisible. Next mhando nokupesana wemasaini payakavakirwa Excel - backslash - uye kusarudza sero ane divisor.

Nyore, kana kuedza Cell nokupesana, zviri izvo zviri 0, "Excel" anoratidza rakakodzera kukanganisa # DIV / 0!.

Kunokosha! Excel unokubvumira kuudza mumwe nhamba ipi, kusanganisira zuva. Asi kana iwe edza kuita kupesana yamakamuri ane rugwaro, uchawana kukanganisa "# ZVINOKOSHA!", Pane chakaipa ukoshi.

The weboka musi

Zvinofadza chaizvo kugoverana mazuva. Edza kugoverana "01/01/2017" kuti "01.01.2016". Unofunga haana kubudirira? Izvi hazvisi izvo. Chokwadi chokuti "Excel" vachangoerekana exchange misi yose kuti nhamba, kuverenga mazuva akapfuura kubva January 1, 1900. Musi "01.01.1900" - nhamba 1, "01/02/1900" - 2. Unogona nyore kutarisa iyi unoponesa sero pamanyorerwo pamwe chaiyo mazuva ne "Date" pamanyorerwo pamanyorerwo "Numeric". Saka, January 1, 2017 - nhamba iri 42736, nokuda kwemazuva mazhinji kudaro kubvira iwoyo chaiwo uye mwedzi 1900. Naizvozvo, kubudikidza Vakagovana mumwe musi kune mumwe, tinogona kuwana chaicho mugumisiro.

Hazvina musoro kuti unogona kugoverana kwete chete musi musi, asi chero nhamba musi ndiEzekieri. Sezvo nzira yokuita "kupesana" muna Excel vachiri kusuma musi wako nhamba. Uye zvinoita kuti ishande chero nzira waunoda.

Table fission "Excel"

Avake tafura mu "Excel", foni A2: A6 akaisa nhamba kuti vachabatsirana (3, 7, 9, 12, 15), uye masero B1: E1 - nhamba kuti uchatenda nokupesana (1, 2, 3 4).

Kuti pave nokupesana petafura, zvakakosha kuyeuka pamusoro kumhedziso uye hama dzinotaura zviri "Excel". The yokuita nokupesana Excel pakugadzirira tafura akadaro kushandisa yakavhenganiswa arimo. Saka kuti sero kero kana kukopa isina haachatauri, zvakakodzera kugadzirisa zviri dividend mbiru kero nhamba, uye mugoveri - mutsetse nhamba. Saka, kupinda sero B2 payakavakirwa «= $ A2 / B $ 1" uye achizvuzvurudza nawo tambo? uye ipapo yose tafura. Table akazadzwa mashoko. Zvino kumira chero sero Somuenzaniso, musi D5. fomura waro zvinotevera: «= $ A5 / D $ 1". Isu zvose zvakanaka.

Division aine zvasara

Kana achiita weboka, kazhinji tinogamuchira fractional nhamba. Kurerutsa omumwe nhamba dzakadaro ndiye "Excel" pfungwa mbiri kukosha.

Muchitokisi, iyo yakanyorwa Somugumisiro, default ndiye "General" format. Kana ukaenda kune Tab "Home" mu "Nhamba" chikamu, zvinokwanisika kuti kubva dropdown mazita sarudza pamanyorerwo shanduko "Other nhamba zvinogona" uye akaisa pamanyorerwo ari "Numeric". By nemanyorerwo ichi chinogona kupiwa foni nhamba grade nzvimbo. Saka kugovera 7/3 isu kazhinji kuona nhamba 2,333333333, uye tichibatsirwa zvakarurama panogumira matatu grade nzvimbo, zvichava seungano 2.333. Chii uchabvuma, ndizvo chaizvo nyore.

The "Excel" rine mbiri akasiyana mabasa kuti vawane quotient uye zvasara weboka. Vari kunzi "Woga" uye "Balance" uye vose tora mbiri fanira nharo - the numerator uye dhinomineta. Tichanzwisisa zvakawanda navo.

Kupinda "Excel" nhamba mbiri - 7 3 (D9, uye D10 muchitokisi iyi), uye kurudyi kwavo - kubva fomura:

Sezvatinoona, kuti quotient akaenzana vaviri, vakasara - 1. In muchitokisi chimwe chinhu, kupinda fomura:

= E9 & "" & E10 & "/" & D10

Pano ampersand kunobatsira batanidza zviri rimwe muchitokisi zviri mune imwe ndima.

Mugumisiro payakavakirwa uyu zvinotevera: 2 1/3 - maviri pfungwa imwe-rechitatu.

Sezvaunogona kuona, kuti nzira yokuita mapoka Excel haisi hombe. Chinhu chikuru kuyeuka kuti dzemaitirwe Zvituko "Excel" anoshandisa mureza mitemo wemasvomhu.