Excel MAX IF Kupanga Maonekedwe

Gwirizanitsani ntchito MAX ndi IF mu Mndandanda Wopangira

Chitsanzo ichi cha phunziroli chimagwiritsa ntchito njira ya MAX IF kuti ipeze zotsatira zabwino kwambiri pazochitika ziwiri zamtundu ndi masewera - kulumpha kwapamwamba ndi phokoso lapamwamba.

Chikhalidwe cha chilolezo chimatilola ife kufufuza zotsatira zambiri pokha posintha ndondomeko yowunikira - mu nkhaniyi dzina lochitika.

Ntchito ya gawo lirilonse lalingaliro ndi:

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 .

ZOCHITIKA ZIKHALIDWE ZOCHITIKA ZOKHUDZA IFEYO NDI ZOKHUDZA

Mawu omasulira a MAX IF njira ndi:

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

Zokambirana za ntchito ya IF ndi izi:

Mu chitsanzo ichi:

Excel & # 39; s MAX IF IF Array Formula Example

  1. Lowani deta zotsatirazi mu maselo D1 mpaka E9 monga momwe tawonera pa chithunzi pamwambapa: Zotsatira Zomwe Zachitika Kukwera (m) High Jump 2.10 High Jump 2.23 High Jump 1.97 Pole Vault 3.58 Pole Vault 5.65 Pole Vault 5.05 Zotsatira Zabwino Best (m)
  2. M'chipinda cha D10 mtundu "kulumphira" (palibe ndemanga). Fomuyi idzawoneka mu selo ili kuti tipeze zochitika zomwe tikufuna kuti zipeze zotsatira zabwino.

Kulowa mu MAX IF Nested Form

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:

    = MAFUPI (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 lachiwiri 2.23 liyenera kuoneka mu selo E10 popeza izi ndizopambana (zazikulu) kutalika kwa kuthamanga kwakukulu.
  4. Ndondomeko yonse

    {= MAX (IF (D3: D8 = D10, E3: E8))}

    Zitha kuwonedwa muzenera zamatabwa pamwamba pa tsamba.

Yesani Mchitidwe

Yesani ndondomekoyi mwa kupeza zotsatira zabwino zogwirira ntchito.

Lembani chovala chojambulira mu selo D10 ndikusindikizira fungulo lolowamo ku Enter .

Fomuyi iyenera kubwerera kutalika kwa mamita 5.65 mu selo E10.