Excel MEDIAN IF Array Formula

Gwiritsani ntchito MEDIAN ndi IF Functions mu Mndandanda Wopangira

Chitsanzo ichi cha phunziroli chimagwiritsa ntchito njira ya MEDIAN IF kuti athe kupeza chisomo chapakati pazinthu ziwiri.

Chikhalidwe cha chilolezo chimatilola ife kufufuza zotsatira zambiri pokha potembenuza chotsatira - mu nkhani iyi, dzina la polojekiti.

Ntchito ya gawo lirilonse lalingaliro ndi:

• Ntchito ya MEDIAN imapeza mtengo wapatali wa polojekiti
• Ntchito ya IF ikutilola kusankha ntchito yomwe tikufuna mwachikondi poika chikhalidwe pogwiritsa ntchito mayina a polojekiti
• Mndandanda wa mapulogalamuwa umapangitsa kuti ntchito ya IF imayesedwe pazigawo zingapo mu selo imodzi, ndipo, ngati vutoli litakwaniritsidwa, ndondomekoyi ikulingalira kuti deta (ntchito zogwirira ntchito) ntchito ya MEDIAN idzayendera bwanji kuti ipeze pakati

CSE Mafomu

Zowonjezeredwa zimapangidwa mwa kukakamiza makiyi a Ctrl , Shift , ndi Enter mu khibodi yomweyo pokhapokha ndondomekoyi yayikidwapo.

Chifukwa cha mafungulo opanikizidwa kuti apange ndondomeko yowonjezera, nthawi zina amatchedwa mayina a CSE .

MALANGIZO NGATI MALANGIZO OYENERA KUTSATIRA MALAMULO NDI ZOKHUDZA

Chidule cha MEDIAN IF njira ndi:

& # 61; MEDIAN (IF (yomveka_motheka, mtengo_if_true, value_if_false))

• Popeza ntchito ya IF imakhala mwadothi mkati mwa ntchito ya MEDIAN, ntchito yonse ya IF imakhala zokhazokha zokha za ntchito ya MEDIA

Zokambirana za ntchito ya IF ndi izi:

• zogwirizana_zimene - (zofunikira) mtengo kapena mawu omwe amayesedwa kuti awone ngati ndi zoona kapena zabodza
• mtengo_if_true - (chofunika) mtengo umene umawonetsedwa ngati zowona_zowona ndi zoona
• value_if_false - (zosankha) mtengo umene umawonetsedwa ngati zomveka_zinthu zonyenga

Excel & # 39; s ZOKHUDZANA NDI IF Examples Formula Example

Monga tanenera, chitsanzo chikufufuzira mapulojekiti awiri osiyana kuti athandizire pakati. Zokambirana za IF IF zimakwaniritsa izi mwa kuika zotsatirazi ndi zotsatirazi:

• yesero lolondola limayesa kupeza machesi a dzina la polojekiti lopangidwira mu selo D10 pa tsamba
• Mtengo_if_nthano yeniyeni idzakhala, mothandizidwa ndi ntchito ya MEDIAN, chifundo cha pakati pa ntchito yosankhidwa
• Mndandanda wa value_if_fal_false udzachotsedwa chifukwa sichifunikira ndipo kusapezeka kwake kudzachepetsanso njirayi. Ngati dzina la polojekiti lomwe silili mu tebulo la deta - monga polojekiti C - idaikidwa mu selo D10 njirayi idzabwezera zero (0)

Kulowa Datorial Data

1. Lowetsani deta zotsatirazi mu maselo D1 mpaka E9 monga momwe tawonera pamwambapa: Project Project Tender Project A $ 15,785 Project A $ 15,365 Project A $ 16,472 Project B $ 24,365 Project B $ 24,612 Project B $ 23,999 Project Pender Tender
2. Mu selo la D10 mtundu "Project A" (palibe ndemanga). Fomuyi idzawoneka mu selo ili kuti ipeze polojekiti yomwe ikugwirizana.

Kulowa mu MEDIAN IF Nested Formula

Popeza tikupanga njira yodzitetezera komanso njira yowonjezeramo, tidzasintha mtundu wonsewo mu selo limodzi lamasamba.

Mukangowonjezera fomu musalowetse chilolezo cha Kulowa pa khibhodi kapena dinani selo losiyana ndi mbewa momwe tikufunira kuti fomuyi ikhale njira yowonjezera.

1. Dinani pa selo E10 - malo omwe zotsatira zake zidzasonyezedwe
2. Lembani zotsatirazi:

   = NGATI (NGATI (D3: D8 = D10, E3: E8))

Kupanga Mpangidwe Wowonjezera

1. Dinani ndi kugwira Ctrl ndi Shift mafungulo pa makiyi
2. Lembani fungulo lolowamo lolowera pa makina kuti mupange ndondomekoyi
3. Yankho la 15875 ($ 15,875 ndi ma formatting) liyenera kuoneka mu selo E10 chifukwa ichi ndichisomo chapakati cha Project A
4. Ndondomeko yonse

   {= MEDIAN (NGATI (D3: D8 = D10, E3: E8))}

   Zitha kuwonedwa muzenera zamatabwa pamwamba pa tsamba

Yesani Mchitidwe

Yesani njirayi mwa kupeza chikhulupiliro chapakati cha Project B

Lembani Pulojekiti B mu selo D10 ndipo yesani kulowera ku Enter key pa kambokosi.

Fomuyi iyenera kubwezera mtengo wa 24365 ($ 24,365) mu selo E10.