Hlanganisa ii-MAX kunye ne-IF imisebenzi kwi-Formula ye-Array
Umzekelo wokufundisa usebenzisa i-formula ye-MAX IF yokufumana umphumo ophezulu kakhulu (umgangatho ophezulu) kwiziganeko ezimbini zengoma kunye nezentsimi-i-jump jump high and pole vault.
Ubume bolu hlobo luvumela ukuba sifune iziphumo ezininzi nje ngokutshintsha i-criterion yokukhangela - kweli gama igama lomcimbi.
Umsebenzi wenxalenye nganye yefomyula ngu:
- umsebenzi we-MAX ufumana umphumo ophezulu kumcimbi okhethiweyo.
- Umsebenzi we-IF uvumela ukuba sikhethe umcimbi ngokubeka imeko ngokusebenzisa amagama omcimbi.
- I- formula formula ivumela ukuba umsebenzi we-IF uvavanyo lweemeko ezininzi kwiiseli enye, kwaye, xa iimeko zidibeneyo, ifomula yomgaqo ichaza ukuba yeyiphi idatha (iziganeko zesiganeko) umsebenzi we-MAX uya kuhlola ukufumana umphumo ogqwesileyo.
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.
I-MAX IF I-Syntax ne-Arguments ye-Formula
I- syntax yefom ye-MAX IF yile:
& # 61; MAX (IF (ingqiqo_kugqithisileyo, value_if_yiyo, value_if_false))
- Ekubeni umsebenzi we-IF uphelelwe ngaphakathi kwi-MAX, umsebenzi wonke we-IF uba yinto engumsebenzi wodwa we-MAX.
Iingxoxo zomsebenzi we-IF zilandelayo:
- ingqiqo_kugqithiseleyo - (efunekayo) ixabiso okanye ibinzana elivanywayo ukuze libone ukuba liyinyaniso okanye inkohliso.
- value_if_true - (efunekayo) ixabiso elibonakaliswe ukuba liqikelele -nje liyinyaniso.
- value_if_false - (ukhetho) ixabiso elibonakaliswe ukuba kunengqiqo_kugqithisileyo.
Kulo mzekelo:
- uvavanyo olunengqiqo luzama ukufumana umdlalo wegama lomcimbi elifakwe kwiseli D10 kwiphepha lokusebenzela .
- Ixabiso_i_i-argument yeqiniso iya kuba, ngoncedo lomsebenzi we-MAX, isiphumo esihle kakhulu kwisiganeko esikhethiweyo.
- I-value_if_false argument iya kushiywa kuba ayimfuneko kwaye ukungabikho kwayo kuya kufutshane ifom. Ukuba igama lesiganeko elingekho kwitheyibhile yedatha - njengokuba luxhamle ixesha elide - lufakwe kwisitokisi se-D10 ifomula iya kubuya i-zero (0).
I-Excel & # 39; s MAX IF IF Example Formula Example
- Faka idatha elandelayo kwiiseli ze-D1 ukuya ku-E9 njengoko kuboniswe kumfanekiso ongentla: Iziphumo zeNgxelo zentsuku Ukuphakama (m) I-Jump ephezulu 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 esona sihle (m)
- Kwi-cell D10 uhlobo "ukuxuma okuphezulu" (akukho zicaphulo). Ifomula iya kubonakala kule setysi ukufumana ukuba zeziphi iziganeko esizifunayo ukuba zifumane iziphumo ezilungileyo.
Ukufaka i-FORM ye-MAX IF
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.
- Cofa kwiseli E10 - indawo apho iziphumo zefomula ziza kuboniswa.
- Thayipha oku kulandelayo:
= MAX (IF (D3: D8 = D10, E3: E8))
Ukudala iFomula yeFom
- Cinezela kwaye ubambe iqhosha le Ctrl kunye neShift kwikhibhodi.
- Cinezela ukhiye wokungena kwibhodibhodi ukudala ifom yefayile.
- Impendulo 2.23 kufuneka ibonakale kwiseli ye-E10 kuba eli lihle kakhulu (likhulu) ukuphakama kwempuphu ephezulu.
- Ifom epheleleyo yokulandelelana
{= MAX (IF (D3: D8 = D10, E3: E8))}
inokubonwa kwifom yefomula ngaphezu kwephepha lokusebenzela.
Hlola iFormula
Hlola i-formula ngokufumana umphumo ogqwesileyo wesigxobo se-pole.
Thayipha intambo ye-pole kwi-cell D10 uze ucinezele ukungena kwikhibhodi.
Ifomula kufuneka ibuyise ubude be-5.65 metres kwi-cell E10.