Nzira yekubatanidza MIN uye IF Functions mune imwe Excel Array Formula

by Ted French

Tsvaga Chinyorwa Chidiki Kupfuura Zvekare Dzai Musangano Wakananga

Mumuenzaniso uyu wekudzidzisa, tine nguva yekupisa kwezviitiko zviviri kubva mumugwagwa unosangana - 100 uye 200 mamita sprints.

Kushandisa MIN IF shanduro yakatendesa kuchatibvumira kuwana, zvakare, nguva inotonhora yekupisa kune imwe nhangemutange ine fomu imwechete.

Basa rechikamu chimwe nechimwe chemurairo ndechekuti:

basa reM MIN rinowana nguva inokurumidza kana duku kudarika yekusarudzwa
Iko IF inoshanda inotibvumira kusarudza nhangemutange nekuisa chimiro tichishandisa mazita emakwikwi
Nzira yakarongeka inoita kuti IF basa riongorore mamiriro ezvinhu akawanda mune imwe sero, uye, kana mamiriro acho akazosangana, mazano arongwa anotsanangura kuti chii chingawanikwa (maruva nguva) MIN inoshanda ichaongorora kuti iwane nguva inokurumidza

CSE Formulas

Nzira dzakagadzirirwa dzinogadzirwa nokufambisa Ctrl, Shift, uye Enter keys pabhobho panguva imwe chete kana fomu yakanyorwa mukati.

Nemhaka yekiyi dzinomanikidzirwa kuti dzigadzire mazano akafanana, dzimwe nguva dzinozivikanwa seCSE mazano.

MIN IF Nested Formula Syntax uye Arguments

Mutsara weM MIN IF formula ndeyekuti:

= MIN (IF (inonzwisisika-yakanyanya, kukosha_if_true, value_if_false))

Kubvira sezvo basa reI IF rakasara mukati memakore MIN, iyo yose IF basa inongova mhirizhonga yemabasa MIN

Nharo dzenhengo ye IF kana iri:

zvinonzwisisika_test - (zvinodiwa) kukosha kana kutaura kunoedzwa kuti uone kana ichokwadi kana nhema
value_if_true - (inoda) kukosha kunoratidzwa kana kunonzwisisika_kuri chokwadi
value_if_false - (kusarudza) kukosha kunoratidzwa kana kunonzwisisika_kuda kunhema

Mumuenzaniso uyu:

muedzo unonzwisisika unoedza kuwana mutsara wezita remakwikwi akanyorwa muchitokisi D10 chebasa rekushanda
Iko-value_if_true argument ichave, nekubatsirwa kwe MIN, iyo nguva inokurumidza yerudzi rwakasarudzwa
Iko-value_if_false argument ichasiyiwa sezvo isingadiwi uye kusavapo kwayo kunopfupisa fomu. Kana zita rorudziro risiri mutafura yedhadha - yakadai semamita 400 - yakaiswa muchitokisi D10 iyo fomu ichadzoka zero (0)

Excel & # 39; s MIN IF Array Formula Example

Kupinda Tutorial Data

Isa inotevera data iri mumasero D1 kusvika E9 sezvinoonekwa mumufananidzo uri pamusoro: 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 Race Kurumidza Kupisa (sec)
Muchitokisi D10 rudzi "mamita 100" (hapana nhamba). Chimiro chichatarisa mumutanda uyu kuti uwane kuti ndeipi yemadzinza atinoda kuti awane nguva inokurumidza

Kupinda MIN kana Nested Formula

Kubva patinenge tichigadzira mhando yechando uye maitiro akafanana, tichadikanwa kutora fomu yose muchengeti rimwe remaeseji.

Kana wapinda muyo maitiro haufaniri kuvhara muIngiyi pikicha kana kuti tora pane imwe sero ine mouse sezvo isu tichida kuisa fomu iri murairi yakasiyana.

Dzvanya pachitokisi E10 - nzvimbo iyo migumisiro yefomu icharatidzwa
Nyora zvinotevera: = MIN (IF (D3: D8 = D10, E3: E8))

Kugadzira Array Formula

Dhinda uye ubatisise Ctrl uye Shift keys pane keyboard
Dhinda pikicha inopinda mukibhodi kuti ugadzire fomu yakarongwa
Mhinduro 11.77 inofanira kuonekwa muchitokisi F10 sezvo ichi ndicho chinokurumidza (chiduku) nguva ye matatu mamita sprint heats
Nzira yakakwana yechinyorwa {= MIN (IF (D3: D8 = D10, E3: E8))}
1. inogona kuonekwa mubhairi yepamusoro pane pepa pepaji

Edzai Formula

Edza maitiro acho nekuwana nguva inokurumidza yemamita 200

Tora mamita 200 muchikamu cheD10 uye pinda paImpikicha pabhodhi.

Nzira yacho inofanira kudzorera nguva ye21,49 masekondi muchitokisi E10.