Hlanganisa i-MEDIAN kunye ne-IF imisebenzi kwi-Formula ye-Array
Lo mzekelo wokufundisa usebenzisa i-formula ye-MEDIAN IF ekhethiweyo yokufumana ithenda ephakathi kweeprojekthi ezimbini ezahlukeneyo.
Ubume bolu hlobo luvumela ukuba sifune iziphumo ezininzi nje ngokutshintsha i-criterion yokukhangela - kulo mzekelo, igama leprojekthi.
Umsebenzi wenxalenye nganye yefomyula ngu:
- Umsebenzi weMEDIAN ufumana ixabiso eliphakathi kwiprojekthi
- Umsebenzi we-IF usenza sikhethe ukuba yiyiphi iprojekthi esiyifunayo ithenda ngokubeka imeko ngokusebenzisa amagama eeprojekthi
- Umgaqo- nkqubo uvumela ukuba umsebenzi we-IF uvavanyo lweemeko ezininzi kwiiseli enye, kwaye, xa iimeko zidibeneyo, ifomula yamalungu ichaza ukuba yeyiphi idatha (iithenda zeprojekthi) umsebenzi we-MEDIA uya kuhlola ukufumana ithenda ephakathi
CSE Ifomu
Iifomula zomdlalo zidalwa ngokucinezela i- Ctrl , Shift , kunye neefayile zokungenisa kwikhibhodi ngexesha elinye xa ifomula ifakiwe.
Ngenxa yezitshixo eziciniweyo zokudala iifom zoluhlu, ngamanye amaxesha zibizwa ngokuba yi- CSE ifomu.
IMIBA YOKUBA I-MEDIAN IF Nested Symbol Syntax kunye neeArguments
I- syntax ye-MEDIAN IF ifom:
& # 61; MEDIAN (IF (ingqiqo_kugqithiseleyo, value_if_yiyo, value_if_false))
- Ekubeni umsebenzi we-IF uphelelwe ngaphakathi kumsebenzi we-MEDIAN, yonke imisebenzi ye-IF iyona ingxoxo yodwa ye-MEDIAN function
Iingxoxo zomsebenzi we-IF zilandelayo:
- ingqiqo_kugqithiseleyo - (efunekayo) ixabiso okanye ibinzana elivanywayo ukuze libone ukuba liyinyaniso okanye inkohliso
- value_if_true - (efunekayo) ixabiso elibonakaliswe ukuba liqikelele -nje liyinyaniso
- value_if_false - (ukhetho) ixabiso elibonakaliswe ukuba kunengqiqo_kugqithisileyo
I-Excel & # 39; s IMBONO IF IF Example Formula Example
Njengoko kuthethwe, umzekelo uphando iithenda zeeprojekthi ezimbini ezahlukeneyo ukufumana ithenda eliphakathi okanye eliphakathi. Iingxoxo zomsebenzi we-IF zifezekisa ngoku kubeka le miqathango kunye neziphumo ezilandelayo:
- Uvavanyo olunengqiqo luzama ukufumana umdlalo wegama leprojekthi efakwe kwiseli D10 kwiphepha lokusebenzela
- Ingxabano-value_if_yiyo iya kuba, ngoncedo lomsebenzi we-MEDIA, ithenda ephakathi kwiprojekthi ekhethiweyo
- I-value_if_false argument iya kushiywa kuba ayimfuneko kwaye ukungabikho kwayo kuya kufutshane ifom. Ukuba igama leprojekthi elingekho kwitheyibhile yedatha - njengeprojekthi C - ifakwe kwifowuni ye-D10 ifomu iya kubuyisa i-zero (0)
Ukufaka i-Tutorial Data
- Faka idatha elandelayo kwiiseli D1 ukuya ku-E9 njengoko kuboniswe kumfanekiso ongentla: IProjekthi yeTender Project Tender Project Iprojekthi eyi-15,785 yeProjekthi Iprojekthi eyi-15,365 yeprojekthi Iprojekthi eyi-$ 16,472 ye-B B $ 24,365 yeprojekthi ye-Project B eyi-24,612 yeprojekthi ye-Project B $ 23,999 yeProjekthi ye-Middle Middle Tender
- Kwiseli ye-D10 "Iprojekthi A" (akukho zicatshulwa). Ifomula iya kujonga kule setysi ukufumana ukuba yeyiphi iprojekthi efana nayo.
Ukungena kwi-MEDIAN IF Nested Formula
Ekubeni sakha zombini ifom yezilwanyana kunye nefomula yoluhlu, siya kufuna ukuthayipha yonke ifomu kwifom yeseshishini esisodwa.
Emva kokuba ungenise ifomu MAFUNI cindezela ukhiye wokungena kwibhodibhodi okanye nqakraza kwiseli eyahlukileyo kunye nemouse njengoko sifuna ukuguqula ifomula ibe yifom yefayile.
- Cofa kwiseli E10 - indawo apho iziphumo zefomula ziza kuboniswa
- Thayipha oku kulandelayo:
= UMANZI (Ukuba (D3: D8 = D10, E3: E8))
Ukudala iFomula yeFom
- Cinezela kwaye ubambe iqhosha le Ctrl kunye neShift kwikhibhodi
- Cinezela ukhiye wokungena kwibhodibhodi ukudala ifom yefayile
- Impendulo ye- 15875 (i-$ 15,875 ngefomathi) kufuneka ibonakale kwiseli ye-E10 kuba eli lithenda eliphakathi kweProjekthi A
- Ifom epheleleyo yokulandelelana
{= MEDIAN (Ukuba (D3: D8 = D10, E3: E8))}
inokubonwa kwifom yefomula ngaphezu kwephepha lokusebenzela
Hlola iFormula
Hlola i-formula ngokufumana ithenda ephakathi yeProjekthi B
Thayipha iProjekthi B kwi-cell D10 uze ucinezela ukungena kwikhibhodi.
Ifomula kufuneka ibuyisele ixabiso le-24365 (i-24 24365) kwi-cell E10.