Nemi Darajar Mafi Ƙari ga Ranar Sadarwar Bayanai mai Mahimmanci
A cikin wannan misalin misali, muna da lokacin zafi don abubuwan da suka faru daga waƙa guda biyu - wajan mita 100 da 200.
Yin amfani da tsari na MIN na zai ba mu damar samun, sau ɗaya, lokaci mafi zafi ga kowace tseren tare da wata hanya ɗaya.
Ayyukan kowane ɓangare na ma'anar ita ce:
- aikin MIN yana samo mafi sauri ko ƙarami lokaci don abin da aka zaɓa
- Ayyukan IF yana ba mu damar zabar tseren ta hanyar kafa yanayin ta amfani da sunayen tseren
- Tsarin lissafi ya ba da izinin aikin IF don sharuɗɗan yanayi a cikin tantanin tantanin halitta, kuma, lokacin da aka cika yanayin, nau'in lissafi ya ƙayyade abin da bayanai (lokacin tsere) aikin MIN zai bincika don samun lokaci mafi sauri
CSE Formulas
An halicci samfurin tsari ta latsa Ctrl, Shift, kuma Shigar da maɓallai a kan keyboard a lokaci ɗaya da zarar an tattake ma'anar.
Saboda maballin maballin sun haɓaka don ƙirƙirar lissafin tsari, wasu lokuta ana kiran su CSE .
MIN IF Nested Formula Syntax da Arguments
Magangancin layin MIN IF shine:
= MIN (IF (logical_test, value_if_true, value_if_false))
- Tun da aikin IF wanda aka gwada a cikin aikin MIN, dukan aikin IF shine ƙaddamarwa ɗaya don aikin MIN
Ƙididdigar aikin IF shine:
- logical_test - (da ake buƙata) darajar ko faɗar da aka gwada don ganin ko gaskiya ne ko karya
- value_if_true - (da ake buƙata) darajar da aka nuna idan logical_test gaskiya ne
- value_if_false - (na zaɓi) darajar da aka nuna idan logical_test ƙarya ne
A wannan misali:
- gwaji na gwaji ya yi ƙoƙari ya sami matsala don sunan tsere ya shiga cikin tantanin halitta D10 na takardar aiki
- Tambayar_mar_if_true zata kasance, tare da taimakon aikin MIN, lokaci mafi sauri ga kabilan da aka zaba
- Za'a ƙaddamar da gardama mai muhimmanci_if_false tun lokacin da ba a buƙata kuma rashi ba zai rage takaicin. Idan sunan tseren da ba a cikin tarin bayanai ba - irin su mita 400 - an rubuta shi zuwa cikin tantanin halitta D10 wannan tsari zai dawo da zero (0)
Hanyoyin Fasaha na Fasaha na Excel & # 39;
Shigar da Bayanan Tutorial
- Shigar da bayanai masu zuwa cikin sel D1 zuwa E9 kamar yadda aka gani a hoton da ke sama: Race Times Race Time (sec) 100 mita 11.77 mita 100 11.87 mita 100 11.83 mita 200 21.54 200 mita 21.50 mita 200 21.49 Race Fastest Heat (sec)
- A cikin cell D10 type "mita 100" (babu quotes). Dabarar za ta duba a cikin wannan tantanin halitta don gano ko wane daga cikin ragamar da muke so ta samo lokaci mafi sauri
Shigar da nau'in NASA Nested Nested
Tun da yake muna samar da tsari guda biyu da aka samo asali, zamu buƙaci rubuta dukkan tsari a cikin ɗayan ɗigon ɗawainiya ɗaya.
Da zarar ka shigar da wannan tsari kada ka danna maɓallin Shigar da ke kan keyboard ko danna kan kwayar halitta daban-daban tare da linzamin kwamfuta kamar yadda muke buƙatar kunna tsari a cikin tsari.
- Danna kan tantanin halitta E10 - wurin da za a nuna sakamakon da aka nuna
- Rubuta da wadannan: = MIN (IF (D3: D8 = D10, E3: E8))
Ƙirƙirar takarda
- Latsa ka riƙe ƙasa Ctrl da Shift keys a kan keyboard
- Latsa maɓallin shigarwa a kan keyboard don ƙirƙirar tsari
- Amsar 11.77 ya kamata ya bayyana a tantanin salula F10 tun lokacin wannan shine mafi sauri (mafi ƙanƙanci) lokaci na tsawon mita 100 na mita
- Tsarin lissafi na gaba = = MIN (IF (D3: D8 = D10, E3: E8))}
- za a iya gani a cikin maɓallin tsari a sama da takardun aiki
Gwada tsarin
Gwada wannan tsari ta hanyar gano lokaci mafi sauri don mita 200
Rubuta mita 200 zuwa cikin cell D10 kuma danna maɓallin shigarwa akan keyboard.
Ma'anar ya kamata dawo da lokaci na 21,49 seconds a cikin cell E10.