Ƙara Lissafi tare da Ayyukan Harkokin Kayan Aiki na Excel

01 na 01

Yi amfani da Hanyoyin Hanya don Haɓaka Lissafi, Rubuce-tsaren, ko Range na Ƙimar

Har ila yau, ta yin amfani da wata mahimmanci don ƙaddamarwa , Excel yana da aiki - aikin aikin PRODUCT - wanda za'a iya amfani dashi don ninka lambobi da sauran nau'o'in bayanai tare.

Alal misali, kamar yadda aka nuna a cikin misalin a cikin hoton da ke sama, don ƙwayoyin A1 zuwa A3, ana iya haɓaka lambobi tare ta yin amfani da tsari wanda ya ƙunshi ƙaruwa ( * ) mai amfani da ilmin lissafi (jere 5) ko wannan aiki za a iya aiwatar da shi aiki na PRODUCT (jere 6).

Wani samfurin yana haifar da haɗin ƙaddamarwa ko ta yaya aka yi amfani da hanya.

Ayyukan PRODUCT zai kasance mafi amfani idan sun haɓaka bayanai a yawancin kwayoyin. Alal misali, a jere na 9 a cikin hoton, ma'anar = PRODUCT (A1: A3, B1: B3) daidai ne da ƙirar = A1 * A2 * A3 * C1 * C2 * C3. Yana da sauƙi da sauri don rubutawa.

Hadin rubutu da jayayya

Haɗin aikin aiki yana nufin layout na aikin kuma ya haɗa da sunan aiki, shafuka, rabuɗɗun takaddama, da muhawara .

Haɗin aikin aikin PRODUCT shine:

= PRODUCT (Number1, Number2, ... Number255)

Number1 - (da ake buƙata) lambar farko ko jerin da kake son ninka tare. Wannan hujja zata iya zama ainihin lambobi, tantancewar salula , ko kewayo zuwa wurin samo bayanai a cikin takardun aiki.

Number2, Number3 ... Number255 - (na zaɓi) ƙarin lambobi, jeri, ko jeri har zuwa iyakar 255 muhawara.

Bayanan Bayanan

Ana bambanta nau'o'in bayanai daban-daban ta hanyar aikin PRODUCT, dangane da ko an shigar da shi a matsayin kai tsaye a cikin aikin ko kuma ana amfani da tantanin halitta akan wurinsa a cikin takardar aiki a maimakon haka.

Alal misali, ana karanta lambobi da kwanakin lokaci a matsayin ƙididdiga ta hanyar aiki, ko da ko an ba su kai tsaye zuwa aikin ko kuma an haɗa su ta amfani da nassoshi na sel,

Kamar yadda aka nuna a cikin layuka 12 da 13 a cikin hoton da ke sama, Boolean dabi'u (TRUE ko FALSE kawai), a gefe guda, ana karanta ne kawai a matsayin lambobi idan an saka su kai tsaye cikin aikin. Idan an shigar da ƙirar salula zuwa tashar Boolean a matsayin hujja, aikin PRODUCT ba shi kula ba.

Bayanin Rubutun Bayanai da Kuskuren Kuskuren

Kamar yadda yake tare da dabi'un Boolean, idan aka yi la'akari da bayanan rubutu a matsayin hujja, aikin zai yi watsi da bayanai a cikin tantanin salula kuma ya dawo sakamakon saboda wasu nassoshi da / ko bayanai.

Idan an shigar da bayanan rubutu a cikin aikin a matsayin shaida, kamar yadda aka nuna a jere na 11 a sama, aikin na PRODUCT ya dawo #VALUE! kuskure kuskure.

Wannan kuskuren kuskure ɗin an mayar da shi ne idan wani daga cikin muhawara da aka ba da kai tsaye zuwa aikin ba za'a iya fassara shi a matsayin lambobi ba.

Lura : Idan an shigar da rubutun kalmomin ba tare da alamomi-kuskuren yau da kullum ba - aikin zai dawo da sunanMNAME? kuskure maimakon #VALUE!

Duk rubutun da ya shiga cikin aikin Excel dole ne a kewaye da alamomi.

Haɓaka Ƙidaya Misali

Matakan da ke ƙasa suna rufe yadda za a shigar da aikin PRODUCT dake cikin tantanin halitta B7 a cikin hoton da ke sama.

Shigar da aiki na PRODUCT

Zaɓuɓɓukan don shigar da aikin da ƙididdigar sun hada da:

1. Rubuta cikakken aikin: = PRODUCT (A1: A3) cikin cell B7;
2. Zabi aikin da kuma muhawara ta amfani da akwatin maganganu na PRODUCT .

Ko da yake yana yiwuwa a shigar da cikakken aikin tare da hannu, mutane da yawa sun fi sauƙi don amfani da akwatin maganganu kamar yadda yake kula da shigar da rubutun aikin, irin su baka da rabuwa tsakanin ɓangarori tsakanin jayayya.

Matakan da ke ƙasa da rufe shigar da aikin PRODUCT ta amfani da akwatin maganganun aikin.

Ana buɗe akwatin zane-zane na PRODUCT

1. Danna kan tantanin halitta don sa shi tantanin halitta ;
2. Danna kan Rubutun hanyoyin shafin rubutun;
3. Danna samfurin a cikin jerin don bude akwatin maganganun aikin;
4. A cikin akwatin maganganu, danna kan lambar Number1 ;
5. Sanya siffofin A1 zuwa A3 a cikin takardun aiki don ƙara wannan tashar zuwa akwatin maganganu;
6. Danna Ya yi don kammala aikin kuma don rufe akwatin maganganu;
7. Amsar 750 ya kamata ya bayyana a cell B7 tun 5 * 10 * 15 yana daidai da 750;
8. Lokacin da ka danna kan tantanin halitta B7 cikakkiyar aikin = PRODUCT (A1: A3) yana bayyana a cikin maɓallin tsari a sama da takardun aiki.