Lembani Numeri ndi Excel PRODUCT Function

01 ya 01

Gwiritsani ntchito Ntchito YAM'MBUYO YOYENERA KUTSATIRA NKHANI ZOTHANDIZA Anthu Apabanja Ndiponso Makolo Achinyamata Ana PEZANI ZOKHUDZA IFEYO

Pogwiritsira ntchito njira yowonjezera , Excel imakhalanso ndi ntchito -PRODUCT PRODUCT-yomwe ingagwiritsidwe ntchito kuchulukitsa manambala ndi mitundu ina ya deta pamodzi.

Mwachitsanzo, monga momwe taonera pachithunzichi pamwambapa, maselo A1 mpaka A3, manambala akhoza kuchulukana palimodzi pogwiritsa ntchito fomu yomwe ili ndi kuchulukitsa ( * ) masamu ochita masewera (mzere 5) kapena ntchito yomweyi ingathe kuchitidwa ndi PRODUCT PRODUCT (mzere 6).

Chigulangondo ndi zotsatira za ntchito yowonjezera mosasamala kanthu komwe ntchito imagwiritsidwa ntchito.

Ntchito ya PRODUCT ingakhale yopindulitsa kwambiri pophatikiza palimodzi data mu maselo ambiri. Mwachitsanzo, mu mzere wa 9 mu chithunzicho, chikhombo = PRODUCT (A1: A3, B1: B3) chikufanana ndi formula = A1 * A2 * A3 * C1 * C2 * C3. Ndi zophweka komanso mofulumira kulemba.

Syntax ndi Arguments

Mawu omasulira a ntchito amatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakiteriya, olekanitsa, ndi zifukwa .

Chidule cha PRODUCT ndicho:

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

Namba1 - (yofunika) nambala yoyamba kapena gulu lomwe mukufuna kuti muchulukane palimodzi. Mtsutso uwu ukhoza kukhala chiwerengero chenichenicho, mafotokozedwe a selo , kapena kuyang'ana pa malo a deta mu tsamba la ntchito.

Number2, Number3 ... Namba255 - (zosankha) zowonjezera manambala, zolembapo, kapena mzere mpaka mavoti okwana 255.

Ma Deta

Mitundu yosiyanasiyana ya deta imathandizidwa mosiyana ndi ntchito ya PRODUCT, malingana ndi kuti imalowa mwachindunji monga mtsutso ku ntchitoyo kapena ngati selo likulozera malo ake pa tsambalo ntchito.

Mwachitsanzo, nambala ndi masiku nthawi zonse zimawerengedwa ngati ziwerengero zamagwiridwe ndi ntchito, ziribe kanthu ngati zimaperekedwa mwachindunji ku ntchito kapena ngati zikuphatikizidwa pogwiritsa ntchito mafotokozedwe,

Monga momwe tawonetsedwera m'mizere 12 ndi 13 mu chithunzi pamwambapa, chiyero cha Boolean (CHOONA kapena CHOKHUDZA chokha), komano, amawerengedwa ngati nambala chabe ngati atayikidwa mwachindunji kuntchito. Ngati mafotokozedwe a selo kwa chiwerengero cha Boolean alowa ngati mkangano, ntchito ya PRODUCT imanyalanyaza izo.

Mauthenga a Malemba ndi Zolakwitsa Malemba

Monga momwe zimakhalira ndi chikhalidwe cha Boolean, ngati kutchulidwa kwa malemba kumakhala ngati kutsutsanako, ntchitoyo imangonyalanyaza deta mu seloyo ndikubwezera zotsatira za zolemba zina ndi / kapena deta.

Ngati mauthenga a mauthenga amalowa mwachindunji kuntchito ngati mkangano, monga momwe tawonedwera mu mzere 11 pamwambapa, ntchito ya PRODUCT imabwerera #VALUE! malingaliro olakwika.

Cholakwika ichi chikubwezeretsedwanso ngati zifukwa zina zomwe zimaperekedwa mwachindunji kuntchito sizingakhoze kutanthauzidwa ngati zilembo zamtengo wapatali.

Dziwani : Ngati mawu amalembedwa popanda zizindikiro zowonongeka-kulakwitsa kwakukulu-ntchitoyi idzabwezeretsa #NAME? cholakwika mmalo mwa #VALUE!

Malembo onse amalowa mu Excel ntchito ayenera kuzunguliridwa ndi zizindikiro zogwiritsira ntchito.

Kuchulukitsa Nambala Chitsanzo

Masitepe omwe ali m'munsimu akuthandizira momwe mungalowerere PRODUCT yomwe ili mu selo B7 mu chithunzi pamwambapa.

Kulowetsa PRODUCT Function

Zosankha zogwira ntchito ndi zifukwa zake zikuphatikizapo:

1. Kujambula ntchito yonse: = PRODUCT (A1: A3) mu selo B7;
2. Kusankha ntchito ndi zifukwa zake pogwiritsa ntchito PRODUCT dialog box.

Ngakhale kuti n'zotheka kungolowera polojekitiyi, anthu ambiri amavutika kuti agwiritse ntchito bokosi la nkhaniyi pamene zimasamala kuti alowe m'ma syntax, monga mabakita ndi ogawanikana pakati pa zifukwa.

Masitepe omwe ali pansipa angalowe mu PRODUCT ntchito pogwiritsa ntchito ndondomeko ya bokosi.

Kutsegula Bokosi la Mauthenga la PRODUCT

1. Dinani pa selo kuti mupange selo yogwira ntchito ;
2. Dinani pa Fomu tab ya riboni;
3. Dinani pa PRODUCT mu mndandanda kuti mutsegule lazokambirana la bokosi;
4. Mu bokosi la bokosi, dinani pa Number1 line;
5. Onetsetsani maselo A1 mpaka A3 mu tsamba lothandizira kuti muwonjezere izi mubox;
6. Dinani OK kuti mutsirize ntchitoyo ndi kutseka bokosi la dialog;
7. Yankho 750 liyenera kuoneka mu selo B7 kuyambira 5 * 10 * 15 ali ofanana ndi 750;
8. Mukasindikiza pa selo B7 ntchito yonse = PRODUCT (A1: A3) ikuwoneka pa bar barolomu pamwamba pa tsamba.