Momwe Mungagwirizanitse Ntchito za MIN ndi IF mu Excel Array Formula

Pezani Phindu Lalikulu Kwambiri pa Zambiri Zambiri Msonkhano Wopambana

Mu chitsanzo cha phunziroli, ife tiri ndi nthawi yotentha kwa zochitika ziwiri kuchokera pamsewu wothamanga - 100 ndi 200 mita sprints.

Kugwiritsa ntchito njira ya MIN IF kumatithandiza kuti tipeze nthawi yotentha kwambiri ya mpikisano uliwonse ndi ndondomeko imodzi.

Ntchito ya gawo lirilonse lalingaliro ndi:

• Ntchito ya MIN imapeza nthawi yofulumira kapena yaying'ono kwambiri pazochitika zosankhidwa
• Ntchito ya IF IF imatithandiza kusankha mpikisano poika chikhalidwe pogwiritsa ntchito mayina a masewera
• Mndandanda wa mapulogalamuwa umapangitsa kuti ntchito ya IF iyesedwe kwa maulendo angapo mu selo imodzi, ndipo, ngati vutoli litakwaniritsidwa, ndondomekoyi ikulongosola kuti deta (MINU) idzafufuza nthawi yanji kuti ipeze nthawi yofulumira kwambiri.

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 .

MIN IF Syntax Makhalidwe Abwino ndi Maganizo

Mawu omasulira a formula IF IF ndi:

= MIN (IF (yomveka_motheka, mtengo_if_true, value_if_false))

• Popeza ntchito ya IF imakhala mwadothi mkati mwa ntchito ya MIN, ntchito yonse ya IF imakhala mpikisano wokha wa ntchito ya MIN

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

Mu chitsanzo ichi:

• mayesero oyenerera amayesera kupeza machesi a dzina la mpikisano wotchulidwa mu selo D10 pa tsambali
• Ndalama_n_nthano yeniyeni idzakhala, mothandizidwa ndi MIN, nthawi yofulumira kwa mtundu wosankhidwa
• Mndandanda wa value_if_fal_false udzachotsedwa chifukwa sichifunikira ndipo kusapezeka kwake kudzachepetsanso njirayi. Ngati dzina la mpikisano lomwe silili mu tebulo ladeta - monga mamita 400 - likuyimikidwa mu selo D10 njirayi idzabwezera zero (0)

Excel & # 39; s MIN IF Array Formula Example

Kulowa Datorial Data

1. Lowetsani deta zotsatirazi mu maselo D1 mpaka E9 monga momwe tawonera pa chithunzi pamwambapa: Race Times Race Time (sec) mamita 100 11.77 100 mamita 11.87 100 mamita 11.83 200 mamita 21.54 200 mamita 21.50 200 mamita 21.49 Mphindi Mafuta otentha (sec)
2. Mu selo la D10 mtundu "mamita 100" (palibe ndemanga). Fomuyi idzawoneka mu selo ili kuti tipeze mtundu uti umene tikufuna kuti upeze nthawi yofulumira kwambiri

Kulowa mu MIN IF Nested Formula

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

Mukangoyamba kugwiritsa ntchito njirayi musamangokakamiza kuyika pa fungulo kapena dinani pa selo losiyana ndi mbewa momwe tikufunira kuti fomuyi ipangidwe.

1. Dinani pa selo E10 - malo omwe zotsatira zake zidzasonyezedwe
2. Lembani izi: = MIN (IF (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 11.77 liyenera kuoneka mu selo F10 chifukwa iyi ndiyo nthawi yofulumira kwambiri (yaing'ono) yamoto ya mamita 100
4. Njira yowonjezera {= MIN (IF (D3: D8 = D10, E3: E8))}
   1. Zitha kuwonedwa muzenera zamatabwa pamwamba pa tsamba

Yesani Mchitidwe

Yesani njirayi mwa kupeza nthawi yofulumira ya mamita 200

Lembani mamita 200 mu selo D10 ndipo yesani kulowera mu Enter key pa makiyi.

Njirayi iyenera kubwereza nthawi ya masekondi 21.49 mu selo E10.