Wedzera Numeri neExcel PRODUCT Function

01 ye 01

Shandisa PRODUCT Function kuwanda ma Numeri, Arrays, kana Ranges of Values

Sezvo kushandisa shanduro yekuwedzera , Excel inewo basa -Chidzo cheMUSP-iyo inogona kushandiswa kuwedzera nhamba nemamwe marudzi e data pamwechete.

Somuenzaniso, sezvinoratidzwa mumuenzaniso uri mumufananidzo wepamusoro, pamasero A1 kusvika kuA3, nhamba dzinogona kuwedzerwa pamwechete uchishandisa fomu iri ine kuwedzera ( * ) mashematics operator (mutsara 5) kana kushanda kumwe kunogona kuitwa ne iyo PRODUCT PRODUCT (mutsara 6).

Chigadzirwa chigumisiro chebasa rokuwedzera pasinei nokuti nzira ipi inoshandiswa.

Iko PRODUCT inoshanda inonyanya kukosha kana kuwedzera pamwe chete data mumasero akawanda. Somuenzaniso, mumutsara we 9 mumufananidzo, fomu = PRODUCT (A1: A3, B1: B3) yakaenzana neyomutambo = A1 * A2 * A3 * C1 * C2 * C3. Zviri nyore nyore uye nokukurumidza kunyora.

Syntax uye Arguments

Mutsara webasa unoreva kurongeka kwebasa racho uye rinosanganisira zita rebasa, mabheji, vatengesi vemavara, uye nharo .

Izwi rechiito che PRODUCT chinonzi:

= MITI (Nhamba1, Nhamba2, ... Nhamba255)

Nhamba1 - (inoda) nhamba yekutanga kana kuti yaunoda kuwedzera pamwe chete. Iyi nharo inogona kunge iri nhamba chaiyo, zvinyorwa zvemasero , kana kutarisa kune nzvimbo yedhesi mubasa rekushanda.

Nhamba2, Nhamba3 ... Nhamba255 - ((zvichida) nhamba inowanikwa, mabhii, kana kuti yakasvikira kusvika pa 255 nharo.

Data Types

Mhando dzakasiyana dzematare dzinotariswa zvakasiyana neyo PRODUCT PRODUCT, zvichienderana nokuti yakapinda zvakananga sepikisheni mubasa here kana kuti sero rinoreva nzvimbo yaro mune pepa rinoshandiswa panzvimbo.

Semuenzaniso, nhamba nematafura zvinogara zvichiverengwa sezvinodiwa nhamba kuburikidza nebasa racho, zvisinei pasinei nokuti zvakapiwa zvakananga kumabasa here kana kuti zvinosanganisira kushandiswa kwemasero,

Sezvinoratidzwa mumitsara 12 ne13 mumufananidzo wepamusoro, maBoolean maonero (TRUE kana FALSE chete), kune rumwe rutivi, anoverengwa seanhamba chete kana akaiswa zvakananga mubasa. Kana sero rinotaura kuBoolean kukosha rakapinda sepikisano, basa reMPR rinorashivirira.

Text Data uye Error Values

Sezvo neBoolean maonero, kana kureva kunyoresa deta kunosanganiswa sepikisano, basa racho rinongorega ruzivo rwemukati iyoyo uye rinodzorera mhinduro yezvimwe zvinyorwa uye / kana deta.

Kana zvinyorwa zvinyorwa zvakapinda zvakananga mubasa sepikisano, sezvinoratidzwa mumuganhu 11 pamusoro apa, PRODUCT PRODUCT inodzorera #VALUE! kukanganisa kukosha.

Iko kukanganisa kukosha kunonyatsodzorerwa kana chero chekukakavadzana kunowanikwa zvakananga kubasa hakukwanisi kududzirwa senhamba dzepamusoro.

Cherechedza : Kana shoko racho rakapinda pasina zvinyorwa-chikanganiso chinowanikwa-basa racho richadzoka #NAME? kukanganisa panzvimbo ye #VALUE!

Zvose zvinyorwa zvakanyatsopinda muExcel basa zvinofanira kunge zvakakombwa nemashoko ekudzokorora.

Kuwandisa Numeri Muenzaniso

Matanho ari pasi apa anowanikwa sei kuisa PRODUCT PRODUCT iri muchitokisi B7 mumufananidzo uri pamusoro.

Kupinda PRODUCT Function

Zvisarudzo zvekupinda mubasa uye nharo dzayo dzinosanganisira:

1. Kunyora basa rakakwana: = PRODUCT (A1: A3) muchikamu B7;
2. Kusarudza basa uye mazano ayo achishandisa PRODUCT PRODUCT dialog box.

Kunyange zvazvo zvichibvira kungopinda basa rakakwana nemaoko, vanhu vazhinji vanoona zviri nyore kushandisa bhokisi rebhokisi sezvo rinotarisira kupinda mumashandisirwo emabasa, akadai mabheji uye maparamadzi ekuparadzanisa pakati pezvikonzero.

Matanho ari pasi apa anopinda mu PRODUCT PRODUCT vachishandisa basa rebhokisi rebhokisi.

Kuzarura Bhokisi reDhiyabhorosi Dialog

1. Dzvanya pane sero kuti uite iyo inoshandiswa seki ;
2. Dzvanya paMafomu tab yebhoni;
3. Dzvanya pa PRODUCT mukati mutsamba kuti uzarure hurukuro yebhokisi rebasa;
4. Mubhokisi rebhokisi, tora paNhamba1 line;
5. Simbisai masero A1 kusvika kuA3 mubasa rekushandisa kuti uwedzere urwu mubhokisi rebhokisi;
6. Dzvanya OK kuti upedze basa uye kuvhara bhokisi rebhokisi;
7. Mhinduro 750 inofanira kuonekwa muchitokisi B7 kubvira 5 * 10 * 15 yakaenzana ne 750;
8. Paunenge uchibvisa pa cell B7 basa rakakwana = PRODUCT (A1: A3) rinowanikwa mubhadha yepamusoro pane pepa pepaji.