Da dabara na "division" to Excel - ka'idojin da misalai na amfani

Masu amfani saba aiki da dabarbari a falle aikace-aikace "Excel" daga "Microsoft", wani lokacin kokarin samun shirye-sanya aiki domin rarraba daya adadin da wani. Amma babu irin wannan aiki, da kuma amfani da wani ciwon kamar yadda shi ya aikata ba - shi ne a "Excel" ne aka yi nufi ga koma zuwa zangon. Da dabara na ƙungiyar zuwa Excel - dai kawai wata ãyã daga wani backslash (/).

Yadda za a raba daya adadin da wani

A cikin "Excel" littafin worksheet irin a daban-daban Kwayoyin wani biyu lambobi. Za su taimaka a magance yadda za a yi wani rabo dabara a Excel. Sai cell free irin alama farkon dabara (daidai =) kuma zaɓi tantanin farko tare da divisible. Next irin division ãyã a cikin dabara Excel - backslash - kuma zaɓi cell da divisor.

Dace, a lokacin da yunƙurin tantanin halitta division, da abinda ke ciki wanda shi ne 0, "Excel" nuna dace kuskure # rara / 0!.

Muhimmanci! Excel ba ka damar raba da juna wani lambar, gami da kwanan wata. Amma lokacin da ka yi kokarin yin wani rabo daga cikin sel dake dauke da rubutu, za ka samu kuskure "# VALUE!", Akwai daidai darajar.

Da rabo daga cikin kwanan wata

Yana da matukar ban sha'awa a raba kwanakin. Ka yi kokarin raba "01/01/2017" to "01.01.2016". Za ka zaton ku yi nasara ba? Wannan ba haka ba. Gaskiyar cewa "Excel" za ta atomatik maida duk kwanakin da dama, kirgawa yawan kwanaki elapsed tun Janairu 1, 1900. A kwanan wata "01.01.1900" - da lambar 1, "01/02/1900" - 2. Za ka iya duba wannan ta mayar da cell format da ajali kwanakin da "Kwanan" format a cikin format "Tazarar". Saboda haka, 1 Janairu, 2017 - wannan lambar ne 42736, shi ne don haka da yawa kwanaki sun shude tun da wannan rana da kuma wata a 1900. Saboda haka, ta rarraba wani lokaci zuwa wani, za mu iya samu takamaiman sakamakon.

Shi ne ma'ana cewa ba za ka iya raba ba kawai kwanan wata na ranar, amma da wani yawan da kwanan wata da kuma mataimakin versa. Tun da dabara na "division" a Excel har yanzu gabatar da kwanan wata a lamba. Kuma shi ne zai yiwu ta yi aiki kowace hanya kuke so.

Table fission "Excel"

Yi a tebur a "Excel", a cell A2: A6 sa lambobi da cewa zai raba (3, 7, 9, 12, 15), da kuma B1 Kwayoyin: E1 - lambar da za yi rabo (1, 2, 3 4).

Don ƙirƙirar ƙungiyar tebur, yana da muhimmanci a tuna game da cikakkar da kuma zumunta nassoshi a cikin "Excel". Da dabara na rabo a Excel a shiri na irin wannan tebur ne don amfani da gauraye nassoshi. Saboda haka cewa tantanin halitta adiresoshin lokacin kwashe ba a canja, shi wajibi ne don gyara a cikin rara shafi adireshin lambar, da kuma divider - line lambar. Saboda haka, shigar da cell B2 dabara «= $ A2 / B $ 1" da kuma ja da shi ta hanyar da kirtani? sa'an nan dukan tebur. Table cike da bayanai. Yanzu tsaya a kan wani cell, misali, a kan D5. Its dabara ne da wadannan: «= $ A5 / D $ 1". Mun yi duk abin da dama.

Division da saura

Lokacin yin division, a mafi yawan lokuta mu sami fractional lambar. Don rage wuya da fahimta irin wannan lambobi ne a "Excel" biyu da muhimmanci da maki.

A cell, wanda aka rubuta a sakamakon, tsoho ne "General" format. Idan ka je shafin "Home" a cikin "Number" sashe, yana yiwuwa su daga jerin zaɓuka list zabi format canji "Sauran yawan Formats" da kuma kafa format na "Tazarar". By wannan format za a iya sanya wani cell yawan gidan goma wurare. Saboda haka, ta rarraba 7/3 mu yawanci ga lamba 2,333333333, kuma tare da taimakon daidaici iyaka na uku gidan goma wurare, shi zai kama 2.333. Abin da za ka yarda, shi ne quite m.

The "Excel" yana da biyu jinsin ayyuka don samun quotient da saura daga cikin rabo. Suna da ake kira "Private" da "Balance" kuma duka da kai biyu m muhawara - da numerator kuma maimaita lamba. Za mu fahimci mafi tare da su.

Shigar da "Excel" biyu lambobin - 7 da kuma 3 (D9, kuma D10 a cikin cell a cikin wannan hali), da kuma ga dama daga gare su - da dabara:

Kamar yadda muka gani, da quotient ne daidai da biyu, da saura - 1. A wani komai a cell, shigar da dabara:

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

Ga ampersand taimaka hašawa da abinda ke ciki na daya cell abinda ke ciki a cikin wani rubutu.

A sakamakon wannan dabara ne da wadannan: 2 1/3 - biyu ma'ana daya-uku.

Kamar yadda ka gani, da dabara na rabo a Excel ne ba wani babban yarjejeniyar. Babban abu a tuna cewa a cikin lissafi dabarbari "Excel" yana amfani da daidaitattun dokoki na lissafi.