Yadda za a yi da multiplication a Excel

Iko falle "Microsoft Excel" sauƙi zai ninka wani daga cikin lambobin, da jeri. Lokacin da shi zai iya zama da gaske taimako a wannan batun? Akwai da yawa mafita:

• A hannu ne ba a kalkuleta.
• Ninka manyan jeri na lambobi, kuma kana son ganin abin da irin lambobin suna da hannu, kuma watakila ma domin maye gurbin wasu daga cikinsu (a misali kalkuleta ayyuka ba tare da bukatar a fara da layin sake ajiye lissafi).
• Multiplication - kawai wani bangare na kumshin na dabara.

Kamar yadda ka gani, da multiplication zuwa Excel - abu gaba daya ba superfluous. Ba tare da multiplication ayyukan ba zai iya yi kusan babu daya dabara.

Bambance-bambancen karatu halitta a "Excel"

"Excel" ba ka damar ninka juna:

• Specific lambobi (m, korau, lamba, fractional).
• The lambobin da wadannan Kwayoyin.
• Jeri na lambobin.
• Boolean dabi'u

Yadda za a yi multiplication? Da dabara na multiplication a Excel ta fara da "daidai" alamar (=). Kamar yadda a wani dabara nana nuna daya bayan wata lambar (ko tunani cell dauke da su) da alaka alamar "star" (*). Irin wannan dabara zai zama kamar haka: "= 0.22 * 16 -5 *" (lokacin da yawaita takamaiman adadin) ko «= G4 * i5» (as muhawara a lokacin da kayyade cell nassoshi). Wannan shi ne na farko version na multiplication.

multiplication dabara a Excel za a iya rikodi ta yin amfani da ginannen "sa" aiki:

A amfani da yin amfani da wannan aikin shi ne yin multiplication zuwa Excel - da yiwuwar halitta da juna, ba kawai lambobi, amma kuma makada.

Mu yanzu la'akari da takamaiman misalai.

Multiplication da wani "star"

Gwada a kan wani worksheet na littafin "Excel" bi wadannan misalai:

Tare da su, za ka ga cewa yin multiplication a Excel ne mai sauki. Lura da cewa sakamakon da multiplication dabaru dabi'u zama 0 (ƙarya) ko 1 (gaskiya).

The kawai drawback na wannan hanya na multiplication - cewa kewayon lambobi a matsayin shaida, ba zai iya yarda da. Kila a kalla, wanda shi ne isa wani mai amfani da ayyana wani wuri a karshen na biyu goma lambobi ko cell, tafi, kuma interleaved domin haruffa "alama."

The kawai hanyar da kewaye wannan drawback ne don amfani da "yi" aiki.

Multiplication ta amfani da "yi" aiki

Ka yi la'akari da yadda za a yi multiplication a Excel amfani da gina-in aiki.

A Kundin "Excel" don ƙirƙirar wani irin farantin karfe kuma a duba a kan ta misalai. A daya shafi yin mahara dabi'u a cikin wani shafi ma sa da dama ma'ana. Ka yi kokarin amfani da aiki "sa" da makada, da kuma yi multiplication da hannu ta hanyar alamar "star".

A shafi "Formula" na wannan tebur a fili ya nuna cewa idan da darajar jeri ne nan kusa, su za a iya amfani da a matsayin zangon. Har ila yau, a kan tebur za ka iya ganin cewa aiki "sa" ya ninka duk wadannan jeri, da kuma samun sakamakon wannan hanya kamar yadda idan mun kasance a kan daya hannunka na ninka darajar da wadannan Kwayoyin. Kamar yadda ka gani, da multiplication zuwa Excel - shi ne mai karye.

Ban sha'awa gaskiya! Try daya darajar yanzu aka cire daga duk wani cell, wani ɓangare na zangon, komai Kwayoyin zai zama gaba daya babu komai. Za ka ga cewa a lokaci guda yi aiki su yi wani lissafi, kawai sakewa wani komai a cell. Kuma a nan ne sakamakon "manual" multiplication juya zuwa sifili. Wannan shi ne duk wani jinsin amfani da gina-in zaɓi don ninka "alama" - shi ba ya yarda da m Kwayoyin kamar yadda sifili, shi kawai saki da su daga lissafi.

Akwai sau lokacin da lissafin ake yi domin jam'i na aikin zanen gado littattafai, da kuma sakamakonsa takardar da aka adana dabara, hada da samfurin na dabi'u na sauran zanen gado. Idan wani daya daga cikinsu zai zama fanko, mai sau multiplication na "star" kunna duk sakamakon a sifili.

Daga wannan za mu iya kammala da cewa, management na hadaddun lissafin a kan mahara zanen gado ne mafi alhẽri ga amfani da aiki "sa" a matsayin fifiko.

multiplication tebur

Dubi na karshe, kirkiro wani multiplication tebur a Excel. Yana da sauki.

A cikin hadisin da misali multiplication tebur hada da wani shafi na daya sa na lambobin a jere - da sauran. Don su iya kwafa da dabara, shi wajibi ne a yi amfani da gauraye links - Gyaran da alamar "dollar" ($) shafi yawan jere daga tsaye data Lines da kuma kwance wa da data '= A2 * $ B $ 1 ".