Hlanganisa Izinombolo nge-PRODUCT Excel ye-PRODUCT

01 ka 01

Sebenzisa umsebenzi we-PRODUCT ku-Numerous Numbers, Arrays, noma Ranges of Values

Kanye nokusebenzisa ifomu lokuphindaphinda , i-Excel nayo inomsebenzi- umsebenzi we -PRODUCT-ongasetshenziselwa ukwandisa izinombolo kanye nezinye izinhlobo zedatha ndawonye.

Isibonelo, njengoba kuboniswe kusibonelo esithombeni esingenhla, amaseli A1 kuya ku-A3, izinombolo zingabuyekezwa ndawonye ngokusebenzisa ifomula equkethe ( * ) opharetha wezibalo (irowu 5) noma ukusebenza okufanayo kungenziwa nge umsebenzi we-PRODUCT (irowu 6).

Umkhiqizo umphumela wokusebenza kokubuyabuyelela kungakhathaliseki ukuthi iyiphi indlela esetshenziswayo.

Umsebenzi we-PRODUCT cishe uwusizo kakhulu uma ukwandisa ndawonye idatha kumaseli amaningi. Isibonelo, emgqeni 9 esithombeni, ifomu = PRODUCT (A1: A3, B1: B3) ilingana nefomula = A1 * A2 * A3 * C1 * C2 * C3. Kulula futhi kusheshe ukubhalela.

I-Syntax ne-Arguments

I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, ukwahlukanisa kwama-comma, nokuphikisana .

I-syntax yomsebenzi we-PRODUCT yilezi:

= PRODUCT (Inombolo1, Inombolo2, ... Inamba255)

Inombolo1 - (edingekayo) inombolo yokuqala noma i-array ofuna ukuyandisa ndawonye. Le mpikiswano ingaba izinombolo zangempela, izinkomba zeselula , noma ububanzi endaweni yedatha ekhasini lokusebenzela.

Number2, Number3 ... Inombolo255 - (okukhethwa kukho) izinombolo ezengeziwe, izigaba, noma ububanzi kuze kube yizingqinamba ezingama-255.

Izinhlobo Zedatha

Izinhlobo ezahlukene zedatha ziphathwa ngezindlela ezahlukene ngokusebenza kwe-PRODUCT, kuye ngokuthi ingeniswe ngokuqondile njengokungqubuzana emsebenzini noma ngabe isethenjwa seleseli endaweni yaso ekhasini lokusebenzela lisetshenziselwa esikhundleni.

Isibonelo, izinombolo nezinsuku zihlala zifundwa njengezinombolo zezinombolo ngomsebenzi, kungakhathaliseki ukuthi zinikezwe ngokuqondile emsebenzini noma ngabe zifakiwe usebenzisa izikhombisi zeselula,

Njengoba kuboniswe emigqeni engu-12 no-13 esithombeni ngenhla, amanani we-Boolean (TRUE noma FALSE kuphela), ngakolunye uhlangothi, afundwa njengezinombolo kuphela uma efakwa ngqo emsebenzini. Uma ireferensi yeseli ye-Boolean value ingeniswa njengengxabano, umsebenzi we-PRODUCT uyayinaki.

Izindinganiso zeDatha yedatha nokuphutha

Njengamanani we-Boolean, uma ukubhekisela kwedatha yombhalo kuhlanganiswa njengokungqubuzana, lo msebenzi nje uyayinaki idatha kuleso seli bese ubuyisa umphumela wezinye izinkomba kanye / noma idatha.

Uma idatha yombhalo ingeniswa ngqo emsebenzini njengokungqubuzana, njengoba kuboniswe kulayini 11 ngenhla, umsebenzi we-PRODUCT ubuyisa i- #VALUE! inani lephutha.

Leli xabiso lephutha libuyiselwe emuva ngempela uma ngabe yiziphi izimpikiswano ezinikezwa ngokuqondile emsebenzini azikwazi ukuhunyushwa njengezinombolo zezinombolo.

Qaphela : Uma umbhalo wegama ungeniswe ngaphandle kwamamaki-quotation-iphutha elivamile-lo msebenzi uzobuyisela i- #NAME? iphutha esikhundleni se- #VALUE!

Wonke umbhalo ongena ngqo emsebenzini we-Excel kufanele uzungezwe ngamanothi okucaphuna.

Ukuphindaphinda Inombolo Isibonelo

Izinyathelo ezingezansi zihlanganisa indlela yokufaka umsebenzi we-PRODUCT esesitokisini B7 esithombeni ngenhla.

Ukufaka umsebenzi we-PRODUCT

Izinketho zokufaka umsebenzi kanye neziphakamiso zalo zifaka:

1. Ukuthayipha umsebenzi ophelele: = PRODUCT (A1: A3) ibe esitokisini B7;
2. Ukukhetha umsebenzi nemibono yayo usebenzisa ibhokisi lebhokisi le-PRODUCT function .

Nakuba kungenzeka nje ukufaka umsebenzi ophelele ngesandla, abantu abaningi bakuthola kulula ukusebenzisa ibhokisi lebhokisi njengoba kuqapha ukungena kwe-syntax yomsebenzi, njengabakaki kanye nabahlukanisi be-comma phakathi kwama-arguments.

Izinyathelo ezingezansi kwekhava ezifaka umsebenzi we-PRODUCT usebenzisa ibhokisi lengxoxo lomsebenzi.

Ukuvula ibhokisi le-PRODUCT Dialog

1. Chofoza kuseli ukuze wenze iseli elisebenzayo ;
2. Chofoza kuthebhu yefomu yebhebhoni;
3. Chofoza ku- PRODUCT ohlwini ukuze uvule ibhokisi lengxoxo lomsebenzi;
4. Ebhokisini lebhokisi, chofoza kulayini leNombolo1 ;
5. Gqamisa amaseli A1 kuya ku-A3 kushidi lokusebenzela ukuze ungeze leli hlu ebhokisini lengxoxo;
6. Chofoza OK ukuze uqedele umsebenzi futhi uvale ibhokisi lengxoxo;
7. Impendulo 750 kufanele ivele esitokisini B7 kusukela 5 * 10 * 15 ilingana no 750;
8. Uma uchofoza ku-cell B7 umsebenzi ophelele = PRODUCT (A1: A3) ibonakala kubha yamatomu ngaphezulu kwephepha lokusebenzela.