I-Excel MAX IF Ifomu ye-Formula

Hlanganisa imisebenzi ye-MAX ne-IF ku-Formule Yomdwebo

Lesi sibonelo sokufundisa sisebenzisa i-formula ye-MAX IF ejwayelekile ukuze uthole imiphumela engcono kunazo zonke (umphumela ophezulu) wezenzakalo ezimbili zethrekhi nezenkundla - i-jump high kanye ne-pole vault.

Imvelo yefomula isivumela ukuthi sifune imiphumela eminingi ngokumane sishintshe umgomo wokusesha - kulokhu igama lomcimbi.

Umsebenzi wengxenye ngayinye yefomula ngu:

• umsebenzi we-MAX uthola imiphumela ephezulu kakhulu yomcimbi okhethiwe.
• Umsebenzi we-IF usivumela ukuba sikhethe umcimbi ngokubeka isimo usebenzisa amagama omcimbi.
• Ifomula ye-array ivumela umsebenzi we-IF ukuhlolwa kwemibandela eminingi esitokisini esisodwa, futhi, uma isimo sesifinyelelwe, ifomula yamakhethi inquma ukuthi yimiphi idatha (imiphumela yomcimbi) umsebenzi we-MAX uzohlola ukuthola imiphumela engcono kakhulu.

I-CSE Amafomula

Amafomu amaqoqo adalwe ngokucindezela okhiye be- Ctrl , Shift , no- Enter ekhibhodi ngesikhathi esifanayo uma ifomula ifakiwe.

Ngenxa yezihluthulelo ezicindezelwe ukudala ifomula yamakheli, ngezinye izikhathi zibizwa ngokuthi ama- CSE amafomula.

I-MAX IF I-Syntax ye-Formula ne-Arguments

I- syntax yefomu ye-MAX IF yi:

& # 61; MAX (IF (okuqondakalayo_kusezingeni, inani_if_true, value_if_false))

• Njengoba umsebenzi we-IF unamathele ngaphakathi komsebenzi we-MAX, wonke umsebenzi we-IF uba yinto ewukuphela komsebenzi we-MAX.

Iziphakamiso zomsebenzi we-IF ziyi:

• kunengqondo_kugqamile - (okudingekayo) inani noma inkulumo evivinywa ukuze ibone ukuthi iqinisile noma ingamanga.
• value_if_true - (edingekayo) inani eliboniswa uma kungenangqondo_kukuqiniso.
• inani_if_false - (ngokuzikhethela) inani eliboniswa uma logical_test ingamanga.

Kulesi sibonelo:

• ukuhlolwa okunengqondo kuzama ukuthola umdlalo wegama lomcimbi elifakwe esitokisini D10 kwiphepha lokusebenzela .
• I-argument value_if_true izoba, ngosizo lo msebenzi we-MAX, umphumela omuhle womcimbi okhethiwe.
• I-value_if_false ingxabano izoshiywa ngoba ayidingekile futhi ukungabi khona kwayo kuzofinyeza ifomula. Uma igama lomcimbi elingekho etafuleni lwedatha - njenge-jump jump eside - ifakwe kufoni ye-D10 ifomula izobuyisela i-zero (0).

I-Excel & # 39; s MAX IF I-Excel Formula Isibonelo

1. Faka idatha elandelayo kumaseli D1 kuya ku-E9 njengoba kuboniswa esithombeni esingenhla: Imiphumela Yomcimbi Isilinganiso Isisindo (m) Isijamo Esiphezulu 2.10 I-High Jump 2.23 I-High Jump 1.97 I-Pole Vault 3.58 I-Pole Vault 5.65 I-Pole Vault 5.05 Isiphumo Esihle Kunazo zonke (m)
2. Ngomakhalekhukhwini we-D10 uhlobo "ukujula okuphezulu" (akukho izingcaphuno). Ifomula izobukeka kule seli ukuze uthole ukuthi yiyiphi imicimbi esiyifunayo ukuze ithole imiphumela engcono kakhulu.

Ukufaka i-FORM ye-MAX IF

Njengoba sakha kokubili ifomula esakhiweyo kanye nefomula yamakhemikhali, kuzodingeka ukuthi siyifake yonke ifomula ibe yinye ishidi lomsebenzi weselula .

Uma usufake ifomula Awufaki ukhiye we- Enter kwikhibhodi noma uchofoze esitokisini esithile negundane njengoba sidinga ukuvula ifomula ibe ifomula yamalungu.

1. Chofoza kuseli E10 - indawo lapho imiphumela yefomula izoboniswa khona.
2. Thayipha okulandelayo:

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

Ukudala ifomu ye-Array

1. Cindezela bese ubamba izinkinobho ze- Ctrl ne- Shift ekhibhodi.
2. Cindezela ukhiye wokungena kwikhibhodi ukuze udale ifomula yamalungu.
3. Impendulo 2.23 kufanele ivele esitokisini se-E10 ngoba lokhu kungcono kakhulu (ukuphakama okukhulu) ukuphakama okukhulu.
4. Ifomula eqondile ye-array

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

   kungabonakala kubha yefomula ngaphezulu kwephepha lokusebenzela.

Hlola i-Formula

Hlola ifomula ngokuthola umphumela omuhle wendonga ye-pole.

Thayipha i- pole ye-pole esitokisini D10 bese ucindezela ukhiye wokungena kwikhibhodi.

Ifomula kufanele ibuyise ukuphakama kwamamitha angu-5.65 ku-E10 cell.