Fumana ixabiso elincinane kunazo zonke kwiiNkcazo zeDatha
Kulo mzekelo wokufundisa, sinexesha lokufudumala kweziganeko ezimbini ukusuka kumzila wokuhlangana-i-100 kunye ne-200 imitha ye-sprints.
Ukusebenzisa ifom ye-IF IF equlathekileyo iya kusivumela ukuba sifumane, ngokukhawuleza, ixesha lokushisa ngokukhawuleza kohlanga ngalunye ngefomula enye.
Umsebenzi wenxalenye nganye yefomyula ngu:
- Umsebenzi we-MIN ufumana ixesha elikhawulezayo okanye elincinci kumcimbi okhethiweyo
- Umsebenzi we-IF uvumela ukuba sikhethe uhlanga ngokubeka imeko ngokusebenzisa amagama omdlalo
- I- formula formula ivumela ukuba umsebenzi we-IF uvavanyo lweemeko ezininzi kwiiseli enye, kwaye, xa iimeko zidibeneyo, ifomula yomgaqo ichaza ukuba yeyiphi idatha (amaxesha omdaniso) umsebenzi we-MIN uya kuhlola ukuze afumane ixesha elikhawulezayo
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.
IMPHI UKUBA UMSEBENZI WOMSEBENZI WOMSEBENZI WAMASEBENZI NEMIGAQO
I- syntax ye-IF IF ifom:
= MIN (i-IF (ingqiqo_kugqithiseleyo, value_if_yiyo, value_if_false))
- Ekubeni umsebenzi we-IF uphelelwe ngaphakathi kumsebenzi we-MIN, wonke umsebenzi we-IF uba ngumphambili wecandelo lomsebenzi we-MIN
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 lomncintiswano olufakwe kwiseli D10 kwiphepha lokusebenzela
- Ixabiso_i_i-ingqinano yenyaniso iya kuba, ngoncedo lomsebenzi we-MIN, ixesha elikhawulezayo lomncintiswano okhethiweyo
- I-value_if_false argument iya kushiywa kuba ayimfuneko kwaye ukungabikho kwayo kuya kufutshane ifom. Ukuba igama lomncintiswano ongekho kwitheyibhile yedatha - njengamitha engama-400 - ityikitye kwi-cell D10 ifomula iya kubuyisa i-zero (0)
I-Excel & # 39; s I-MIN Nangona umzekelo wohlobo lwe-Formula
Ukufaka i-Tutorial Data
- Faka idatha elandelayo kwiiseli ze-D1 ukuya ku-E9 njengoko kuboniswe kumfanekiso ongentla: I-Race Times Race Time (sec) 100 metres 11.77 100 amamitha 11.87 100 amamitha 11.83 200 iimitha 21.54 200 iimitha 21.50 200 iimitha 21.49 Uhlanga olukhawulezileyo Ukushisa (sec)
- Kwiseli ye-D10 "iimitha ezili-100" (akukho zicaphuno). Ifomula iya kubonakala kule setysi ukufumana yiphi imidyarho esiyifunayo ukuba ifumane ixesha elikhawulezayo
Ukungena kwi-IF IF ifom ye-Nested
Ekubeni sakha zombini ifom yezilwanyana kunye nefomula yoluhlu, siya kufuna ukuthayipha yonke ifomu kwifom yeseshishini esisodwa.
Emva kokuba ungenise ifomula ungacinezeli ukhiye wokungena kwikhibhodi 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: = MIN (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 11.77 ifanele ivele kwiseli yeF10 kuba eli lixesha elikhawulezayo (elincinane) ixesha leemitha ezintathu zeemitha eziyi-sprint
- Isalathiso esipheleleyo samagama {= MIN (IF (D3: D8 = D10, E3: E8))}
- inokubonwa kwifom yefomula ngaphezu kwephepha lokusebenzela
Hlola iFormula
Hlola i-formula ngokufumana ixesha elikhawulezayo leemitha ezingama-200
Uhlobo lwama- 200 emitha kwi-cell D10 uze ucindezele ukhiye wokungena kwikhibhodi.
Imfomula kufuneka ibuyele ixesha le-21.49 imizuzwana kwiseli E10.