I-Excel I-MEDIAN IF Ifom ye-Formula

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:

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))

Iingxoxo zomsebenzi we-IF zilandelayo:

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:

Ukufaka i-Tutorial Data

  1. 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
  2. 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.

  1. Cofa kwiseli E10 - indawo apho iziphumo zefomula ziza kuboniswa
  2. Thayipha oku kulandelayo:

    = UMANZI (Ukuba (D3: D8 = D10, E3: E8))

Ukudala iFomula yeFom

  1. Cinezela kwaye ubambe iqhosha le Ctrl kunye neShift kwikhibhodi
  2. Cinezela ukhiye wokungena kwibhodibhodi ukudala ifom yefayile
  3. Impendulo ye- 15875 (i-$ 15,875 ngefomathi) kufuneka ibonakale kwiseli ye-E10 kuba eli lithenda eliphakathi kweProjekthi A
  4. 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.