Yi amfani da Excel ta AVERAGEIF don Nuna Ƙimar Zama A lokacin da aka gano Matsayin

An saka aikin AVERAGEIF a Excel na 2007 domin ya sauƙaƙa don samun adadi mafi yawa a cikin kewayon bayanai wanda ya hadu da wani takamaiman bayanin.

Ɗaya daga cikin irin wannan amfani don aikin shine don ƙetare ƙananan dabi'u a bayanan da ke jefa jigilar mahimmanci ko mahimmanci yayin amfani da aikin AVERAGE na yau da kullum .

Bugu da ƙari, bayanan da aka ƙaddara zuwa ɗawainiyar, zane-zane na iya zama sakamakon sakamakon lissafi - musamman a cikin takardun aiki marasa cikakke.

Nuna ƙananan Zeros a lokacin neman Magancin

Hoton da ke sama ya ƙunshi wata maƙira ta amfani da AVERAGEIF wanda ke watsar da dabi'u marayu. Sakamakon wannan tsari shine " <> 0".

Halin "<>" ba shi da alamar daidai a Excel kuma an halicce shi ta hanyar buga bakunan kusurwa - located a cikin kusurwar dama dama na keyboard - baya zuwa baya;

Misalai a cikin siffar duk suna amfani da wannan mahimman tsari - kawai yanayin canje-canje. Sakamakon daban-daban da aka samo ne saboda bayanai daban-daban da aka yi amfani da su a cikin tsari.

BABI NA GABATARWA DA GABATARWA

Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, da muhawara .

Haɗin aikin aikin AVERAGEIF shine:

= AVERAGEIF (Range, Criteria, Average_range)

Ƙididdigar aikin AVERAGEIF shine:

Range - (da ake buƙata) rukuni na sel da aikin zai nema don neman matakan don hujjar Criteria a ƙasa.

Criteria - (buƙatar) ƙayyade ko bayanan a cikin tantanin halitta ya zama girman ko a'a

Average_range - (na zaɓuɓɓuka) zangon bayanan data wanda yake da girman idan kullin farko ya dace da ka'idodi da aka ƙayyade. Idan an kawar da wannan hujja, bayanan da ke cikin Range argument yana da ƙimar a maimakon - kamar yadda aka nuna a misalai a cikin hoton da ke sama.

Ayyukan AVERAGEIF ba su kula ba:

• Sel a cikin sharuddan Average_range wanda ya ƙunshi dabi'un Boolean (TRUE ko FALSE) - jere 5 a sama;
• Cells a cikin Average_range da suke komai - jere 4 a sama;

Lura:

• Idan babu Kwayoyin a Range ya hadu da ka'idodin da aka gano, AVERAGEIF ya sake dawo da # DIV / 0! kuskuren kuskure - jere 7 a cikin misalin, inda dukkanin sel a Range suna daidai da sifilin.
• Idan jigilar Range ya zama cikakke ko ya ƙunshi nauyin rubutu kawai, AVERAGEIF ya sake dawo da # DIV0! kuskure kuskure.- layuka 6 da 8 a sama;

Nuna Saro misali

Zaɓuɓɓuka don shigar da aikin AVERAGEIF da ƙididdigarsa sun haɗa da:

1. Rubuta cikakken aikin, kamar: = AVERAGEIF (A3: C3, "<> 0") a cikin sashin layi na aiki;
2. Zabi aikin da kuma muhawarar ta ta amfani da akwatin maganganun AVERAGEIF .

Ko da yake yana yiwuwa don kawai shigar da cikakken aikin da hannu, mutane da yawa sun fi sauƙi don amfani da akwatin maganganu kamar yadda yake kula da shigar da haɗin aikin - irin su sigina da rabuwa da aka buƙata da ake bukata tsakanin muhawarar.

Bugu da kari, idan an shigar da aikin da kuma muhawarar da hannu, dole ne a yi la'akari da hujjar Criteria ta alamomi: "<> 0" . Idan ana amfani da akwatin maganganu don shigar da aikin, zai ƙara alamomi don ku.

Da aka jera a kasa su ne matakan da aka yi amfani da su don shigar da AVERAGEIF zuwa cikin cell D3 na misali a sama ta amfani da akwatin maganganun aikin.

Ana bude Akwatin Magana na AVERAGEIF

1. Danna kan tantanin halitta D3 don sa shi tantanin aiki - wurin da za a nuna sakamakon aikin;
2. Danna kan Rubutun hanyoyin shafin rubutun ;
3. Zaɓi Ƙari Ayyuka> Lissafi daga rubutun don buɗe jerin sauƙaƙe aikin;
4. Danna AVERAGEIF a cikin jerin don kawo akwatin maganganu na aikin;
5. A cikin akwatin maganganu, danna kan Range ;
6. Sanya siffofin A3 zuwa C3 a cikin takardun aiki don shigar da wannan zangon cikin akwatin maganganu;
7. A kan Maɓallin Magana a cikin akwatin maganganu, rubuta: <> 0 ;
8. Lura: An ƙaura Average_range tun daga lokacin da muke gano adadi mafi yawa ga wadanda aka shigar dasu don maganganun Range ;
9. Danna Ya yi don rufe akwatin maganganu kuma komawa zuwa aikin aiki;
10. Amsar 5 ya kamata ya bayyana a cell D3;
11. Tun da aikin ba shi da daraja a cikin kwayar halitta B3, yawancin kwayoyin biyu da suka rage shi ne 5: (4 + 6) / 2 = 10;
12. Idan ka danna kan tantanin D8 da cikakken aikin = AVERAGEIF (A3: C3, "<> 0") ya bayyana a cikin maɓallin tsari a sama da takardun aiki.