Sebenzisa i-AVERAGEIF ye-Excel ukuze Unganaki ama-Zero Amanani Uma Uthola Isilinganiso

Umsebenzi we-AVERAGEIF wanezelwa ku-Excel 2007 ukwenza kube lula ukuthola inani elilinganiselwe kuluhlu lwemininingwane ehlangabezana nomgomo ocacisiwe.

Ukusetshenziswa okufanayo kwalokhu msebenzi kungukuthi kungayinaki amanani we-zero kudatha elahla isilinganiso noma isilinganiso sokusebenzisa ama - arithmetic uma usebenzisa umsebenzi ovamile we-AVERAGE .

Ngaphezu kwedatha eyongezwa kwiphepha lokusebenzela, amanani we-zero angaba umphumela wokubala kwefomula - ikakhulukazi kumashidi okusebenza angaphelele.

Yeka i-Zeros lapho uthola isilinganiso

Isithombe esingenhla sinefomula esebenzisa i-AVERAGEIF enqabe amanani we-zero. Isimiso kwifomu esenza lokhu " <> 0".

Umlingisi we- "<>" yi-symbol engalingani ku-Excel futhi idalwe ngokuthayipha amabakaki angama-angle - ekhoneni elingezansi kwesokudla lekhibhodi - emuva emuva;

Izibonelo ezithombeni zonke zisebenzisa ifomula efanayo eyisisekelo - kuphela ukuguquka kwebanga. Imiphumela ehlukene etholakalayo ingenxa yedatha ehlukene esetshenziselwa ifomula.

I-AVERAGEIF Yesebenzayo i-Syntax ne-Augments

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

I-syntax yomsebenzi we-AVERAGEIF yilezi:

= AVERAGEIF (I-Range, i-Criteria, i-average_range)

Iziphakamiso zomsebenzi we-AVERAGEIF ziyi:

Izinga - (elidingekayo) iqembu lamaseli umsebenzi uzosesha ukuthola ukufaniswa kwempikiswano yeCriteria ngezansi.

Imigomo - (edingekayo) inquma ukuthi ngabe idatha esitokisini kufanele ibe nesilinganiso noma cha

Isilinganiso_esilinganiso - (ngokuzithandela) uhla lwedatha olulinganiselwe uma ibanga lokuqala lihlangabezana nezimiso ezicacisiwe. Uma ngabe le mpikiswano ishiyiwe, idatha esikhundleni se- Range argument esikhundleni-njengoba kuboniswe kwizibonelo esithombeni ngenhla.

Umsebenzi we-AVERAGEIF uyayinaki:

• Amaseli ku- Average_range argument equkethe amanani we-Boolean (TRUE noma FALSE) - irowu 5 ngenhla;
• Amaseli e- Average_range engenalutho - umugqa 4 ngenhla;

Qaphela:

• Uma kungekho amangqamuzana e- Range ahlangabezana ne-criteria ekhonjiwe, u-AVERAGEIF ubuyisa i- # DIV / 0! inani lesiphambeko - umugqa wesi-7 kusibonelo, lapho wonke amaseli e- Range elingana no-zero.
• Uma impikiswano yeRange ingenalutho ngokuphelele noma iqukethe kuphela amanani wombhalo, i-AVERAGEIF ibuyisela i- # DIV0! iphutha inani.- imigqa 6 no-8 ngenhla;

Yeka Isibonelo seZeros

Izinketho zokufaka umsebenzi we-AVERAGEIF nezimpikiswano zayo zifaka:

1. Ukuthayipha umsebenzi ophelele, njengokuthi: = AVERAGEIF (A3: C3, "<> 0") esitokisini somsebenzi;
2. Ukukhetha umsebenzi kanye neziphakamiso zayo usebenzisa ibhokisi lebhokisi lebhokisi le-AVERAGEIF .

Nakuba kungenzeka nje ukufaka umsebenzi ophelele ngesandla, abantu abaningi bakuthola kulula ukusebenzisa ibhokisi lengxoxo njengoba kunakekela ukungena kwe-syntax yomsebenzi - njengabakaki kanye nokuhlukanisa ama-comma okudingekayo phakathi kwezingxabano.

Ngaphezu kwalokho, uma umsebenzi nezimpikiswano zawo zingena ngesandla, ukuphikisana kweCriteria kufanele kuzungezwe ngamamaki okucaphuna: "<> 0" . Uma ibhokisi lengxoxo lisetshenziselwa ukungena emsebenzini, lizofaka amamaki okucaphuna kuwe.

Okubekwe ngezansi yizinyathelo ezisetshenziselwa ukungena ku-AVERAGEIF kuseli D3 yesibonelo ngenhla usebenzisa ibhokisi lengxoxo lomsebenzi.

Ivula ibhokisi le-AVERAGEIF

1. Chofoza kuseli D3 ukuze wenze iseli elisebenzayo - indawo lapho imiphumela yomsebenzi izoboniswa khona;
2. Chofoza kuthebhu yefomu yebhebhoni ;
3. Khetha Imisebenzi Engaphezulu> Isitatimende kusuka kubhebhoni ukuvula uhlu lwehla lokusebenza;
4. Chofoza ku- AVERAGEIF ohlwini ukuze ulethe ibhokisi lengxoxo lomsebenzi;
5. Ebhokisini lebhokisi, chofoza ku- Range line;
6. Qinisekisa amaseli A3 kuya ku-C3 kusikripthi sokusebenzela ukuze ufake lolu hlu ebhokisini lengxoxo;
7. Emgqeni wokuqondisa ebhokisini lebhokisi, thayipha: <> 0 ;
8. Qaphela: I- Average_range ishiywe ingenalutho ngoba sithola inani elilinganiselwe lamaseli afanayo afakwe kwi- Range argument;
9. Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela;
10. Impendulo 5 kufanele ivele kuseli D3;
11. Njengoba lo msebenzi unganaki inani le-zero esitokisini B3, isilinganiso samaseli amabili asele angama-5: (4 + 6) / 2 = 10;
12. Uma uchofoza ku-cell D8 umsebenzi ophelele = AVERAGEIF (A3: C3, "<> 0") ivela kubha yefomula ngaphezulu kwephepha lokusebenzela.