Yandisa inani kunye ne-Excel ye-PRODUCT Function

01 ngo 01

Sebenzisa i-PRODUCT Function kwi-Multiply Numbers, Arrays, okanye iiRanges zeMilinganiselo

Kanye nokusebenzisa ifom yokuphindaphinda , i-Excel inomsebenzi- umsebenzi we- PRODUCT-ongasetyenziselwa ukwandisa iinombolo kunye nezinye iindidi zedatha kunye.

Umzekelo, njengoko kuboniswe kumzekelo kumfanekiso ongentla, kwiiseli A1 ukuya ku-A3, amanani angabandiswa kunye kunye usebenzisa ifomu equlethe ukuphindaphinda ( * ) umqhubi wemathematika (umqolo wesi-5) okanye usebenzo olufanayo lunokuqhutywa kunye Umsebenzi we-PRODUCT (umgca 6).

Imveliso yiphumo lokusebenza ngokuphindaphinda kungakhathaliseki ukuba yiphi indlela esetyenziswayo.

Umsebenzi we-PRODUCT usetyenziswe kakhulu xa uphinda uhlanganisa idatha kwiiseli ezininzi. Umzekelo, kumgca 9 kumfanekiso, ifomula = I-PRODUCT (A1: A3, B1: B3) ilingana ne-formula = A1 * A2 * A3 * C1 * C2 * C3. Kulula kwaye ukhawuleze ukubhala.

I-Syntax kunye neengxoxo

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye ibandakanya igama lomsebenzi, iibakaki, abahluli be-comma kunye neengxabano .

I-syntax yomsebenzi we-PRODUCT yile:

= I-PRODUCT (Inani1, Inani2, ... Inani255)

Inombolo1 - (efunekayo) inombolo yokuqala okanye uluhlu ofuna ukuwandisa kunye. Le ngxabano ingaba ngamanani okwenene, izikhokelo zeeseli , okanye uluhlu kwindawo yokusebenza kwiphepha lokusebenzela.

Number2, Number3 ... Inombolo255 - (okukhethwa kukho) iinombolo ezongezelelweyo, iipragram, okanye uhla ukuya kuma-255 angqinelanayo.

Iintlobo zeDatha

Iintlobo ezahlukeneyo zedata ziphathwa ngokuhlukileyo kumsebenzi we-PRODUCT, kuxhomekeka ukuba ingafakwa ngqo ngokuphambene nomsebenzi okanye nokuba isetyenzisi seeseli kwindawo yaso kwiphepha lomsebenzi lisetyenzisiweyo.

Umzekelo, iinombolo kunye nemini zihlala zifundwa njengexabiso leenombolo ngomsebenzi, kungakhathaliseki ukuba zinikezelwa ngqo kumsebenzi okanye ukuba zibandakanywa usebenzisa izikhonkwane zeeseli,

Njengoko kuboniswe kumqolo 12 no-13 kumfanekiso ongentla, ixabiso le-Boolean (TRUE okanye FALSE kuphela), ngakolunye uhlangothi, zifundwa njengeenombolo kuphela xa zifakwe ngqo kumsebenzi. Ukuba isalathisi yeselingi kwixabiso leBoolean lingeniswa njengengxabano, umsebenzi we-PRODUCT uyayigatya.

Iinkcukacha zeTekisi kunye neePazamo

Njengoko kunye nemilinganiselo yeBoolean, ukuba isetyenzisiweyo sedatha yombhalo ifakiwe njengengxabano, umsebenzi uyayigatya idatha kwilo seli kwaye ubuyisela umphumo wezinye iinkcukacha kunye / okanye idatha.

Ukuba idatha yedatha ingeniswa ngqo kumsebenzi njengengxabano, njengoko kuboniswe kumgca 11 ngasentla, umsebenzi we-PRODUCT ubuyisela i- #VALUE! xabiso le mpazamo.

Le xabiso lephuso libuyiselwa kwakhona ukuba ngaba nayiphi na ingxabano enikezelwa ngqo kumsebenzi ayikwazi ukutolika njengamaxabiso enani.

Qaphela : Ukuba umbhalo wegama ungeniswe ngaphandle kwamanqaku-quotation-iphutha eliqhelekileyo-lo msebenzi uza kubuyisa i- #NAME? mpazamo endaweni ye #VALUE!

Yonke into ebhalwe phantsi ngqo kwi-Excel umsebenzi kufuneka ijikelezwe ngamanqaku okucaphuna.

Ukupapashwa kweNombolo yomzekelo

Amanyathelo angezantsi ajonga indlela yokufaka umsebenzi we-PRODUCT esekitini B7 kumfanekiso ongentla.

Ukufaka i-PRODUCT Function

Izinketho zokungena kumsebenzi kunye neengxabano zayo ziquka:

1. Ukuthayipha umsebenzi opheleleyo: = I-PRODUCT (A1: A3) kwi-cell B7;
2. Ukukhetha umsebenzi kunye neengxabano zayo usebenzisa ibhokisi yencoko yomsebenzi we-PRODUCT .

Nangona kunokwenzeka ukufaka umsebenzi opheleleyo ngesandla, abantu abaninzi bakuthola kulula ukusebenzisa ibhokisi yencoko njengoko kuthatha ukunakekelwa kokungena kwi-syntax yomsebenzi, njengabakaki kunye nabahluli be-comma phakathi kweengxabano.

Amanyathelo angezantsi angena kwi-PRODUCT umsebenzi usebenzisa ibhokisi yencoko yencoko yomsebenzi.

Ukuvula ibhokisi yeNtetho ye-PRODUCT

1. Cofa kwiseli ukwenzela ukuba isebenzi esebenzayo ;
2. Cofa kwiThebhu yefomula yerbhoni;
3. Cofa kwi- PRODUCT kwisahlu ukuvula ibhokisi yencoko yencoko yomsebenzi;
4. Kwibhokisi yencoko, nqakraza kumgca weNombolo1 ;
5. Phakamisa iiseli A1 ukuya ku-A3 kwiphepha lokusebenzela ukuze ungeze le fayile kwibhokisi yencoko;
6. Cofa Kulungile ukuqedela umsebenzi kwaye uvale ibhokisi yencoko;
7. Impendulo engu-750 kufuneka ibonakale kwiseli yeB7 ukususela ngo-5 * 10 * 15 ilingana no-750;
8. Xa ucofa kwiseli B7 umsebenzi opheleleyo = IKHUMA (A1: A3) ibonakala kwibha yefomula ngaphezu kwephepha lokusebenzela.