Indlela Yokuhlanganisa Imisebenzi ye-MIN neye-IF ku-Excel Array Formula

Thola inani elincinci kunazozonke ngezinga lemininingwane Ukuhlangabezana neCredit Specific

Kulesi sibonelo sokufundisa, sinezikhathi zokushisa imicimbi emibili kusukela ekuhlanganisweni komzila - i-sprints yamamitha angu-100 no-200.

Ukusebenzisa ifomula yamaminithi we-MIN IF kuzosisiza ukuba sithole futhi isikhathi sokushisa esisheshayo sohlanga ngalunye ngefomula eyodwa.

Umsebenzi wengxenye ngayinye yefomula ngu:

• umsebenzi we- MIN uthola isikhathi esisheshayo noma esincane kunazo zonke zomcimbi okhethiwe
• Umsebenzi we-IF uvumela ukuthi sikhethe umncintiswano ngokubeka isimo ngokusebenzisa amagama ohlanga
• Ifomula ye-array ivumela umsebenzi we-IF ukuhlolwa ngezimo eziningi esitokisini esisodwa, futhi, uma isimo sesifinyelelwe, ifomula yamagama ibeka ukuthi iyiphi idatha (izikhathi zomjaho) umsebenzi we-MIN uzohlola ukuze uthole isikhathi esisheshayo

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.

MIN Uma ngabe i-Syntax ye-Formula ne-Arguments

I- syntax yefomu ye-IF IF yi:

= MIN (IF (okuqondakalayo_kusezingeni, value_if_true, value_if_false))

• Njengoba umsebenzi we-IF unamathele ngaphakathi komsebenzi we-MIN, yonke imisebenzi ye-IF iba yinto ewukuphela komsebenzi we-MIN

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 lomncintiswano elifakwe esitokisini D10 kwiphepha lokusebenzela
• I-argument value_if_true izoba, ngosizo lomsebenzi we-MIN, isikhathi esisheshayo sohlanga olukhethiwe
• I-value_if_false ingxabano izoshiywa ngoba ayidingekile futhi ukungabi khona kwayo kuzofinyeza ifomula. Uma igama lomncintiswano elingekho etafuleni lwedata - njengamamitha ayi-400 - lifakwe efolini D10 ifomula izobuyisela i-zero (0)

I-Excel & # 39; s MIN IF Isibonelo se-formula

Ukufaka idatha yokufundisa

1. Faka idatha elandelayo kumaseli D1 kuya ku-E9 njengoba kuboniswa esithombeni esingenhla: Isikhathi seRace Times Isikhathi (sec) 100 amamitha 11.77 100 amamitha 11.87 100 amamitha 11.83 200 amamitha 21.54 200 amamitha 21.50 200 amamitha 21.49 Uhlanga Ukushisa Okusheshayo (sec)
2. Enceleni ye-D10 uhlobo "amamitha ayi-100" (ayikho izingcaphuno). Ifomula izobukeka kule seli ukuze ithole ukuthi yiziphi izinhlanga esizifunayo ukuze zithole isikhathi esisheshayo

Ukufaka i-IF IF ye-Nested Formula

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

Uma usufake ifomula ungacindezeli ukhiye we- Enter kwikhibhodi noma uchofoze kuseli elihlukile negundane njengoba sidinga ukuvula ifomula ibe ifomula yamalungu.

1. Chofoza kuseli E10 - indawo lapho imiphumela yefomula izoboniswa khona
2. Thayipha okulandelayo: = MIN (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 11.77 kufanele ivele esitokisini F10 ngoba lesi yisikhathi esincane kunazo zonke (esincane kunazo zonke) sezimoto ezintathu zemitha eziyi-sprint
4. Umshini ophelele we-array {= MIN (IF (D3: D8 = D10, E3: E8))}
   1. kungabonakala kubha yefomula ngaphezulu kwephepha lokusebenzela

Hlola i-Formula

Hlola ifomula ngokuthola isikhathi esisheshayo samamitha angu-200

Thayipha amamitha angu-200 ibe yiselula D10 bese ucindezela ukhiye wokungena kwikhibhodi.

Ifomula kufanele ibuyisele isikhathi se-21.49 amasekhondi kuseli E10.