Haɗa ayyukan MAX da IF a cikin takarda Array
Wannan misali na kwalejin yana amfani da matakan tsari na MAX IF don samun mafi kyawun (mafi girma) sakamakon sau biyu waƙa da filin abubuwan - zubar da tsalle da tsalle.
Halin yanayin ya ba mu damar bincika sakamako masu yawa ta hanyar sauya bayanan bincike - a cikin wannan yanayin sunan taron.
Ayyukan kowane ɓangare na ma'anar ita ce:
- aikin MAX ya sami mafi girma sakamakon sakamakon da aka zaɓa.
- Ayyukan IF yana ba mu dama mu zaɓi taron ta hanyar kafa yanayin ta amfani da sunayen abubuwan da suka faru.
- Daftarin tsari ya ba da izinin aikin IF don sharuɗɗan yanayi a cikin tantanin tantanin halitta, kuma, lokacin da aka cika yanayin, tsarin da aka tsara ya ƙayyade abin da bayanai (sakamakon binciken) aikin MAX zai bincika don samun sakamako mafi kyau.
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 .
MAX Idan Nested Formula Syntax da jayayya
Magana akan MAX IF tsari shine:
& # 61; MAX (IF (logical_test, value_if_true, value_if_false))
- Tun da aikin IF wanda aka samo shi a cikin aikin MAX, dukan aikin IF shine ƙaddamarwa ɗaya don aikin MAX.
Ƙ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 don nemo wani wasa don sunan sunan da aka buga a cikin tantanin halitta D10 na takardar aiki .
- Tambayar value_if_true za ta kasance tare da taimakon MAX aiki, mafi kyawun sakamakon da aka zaɓa.
- Za'a ƙaddamar da gardama mai muhimmanci_if_false tun lokacin da ba a buƙata kuma rashi ba zai rage takaicin. Idan sunan da ya faru da ba a cikin lissafin bayanai ba - irin su tsalle-tsalle - an rubuta shi zuwa cikin tantanin halitta D10 wannan tsari zai dawo da zero (0).
Excel & # 39; s MAX IF Firayi Formula Misali
- Shigar da wadannan bayanan a cikin sel D1 zuwa E9 kamar yadda aka gani a cikin hoton da ke sama: Abubuwan da ke faruwa aukuwa Aikin da aka samu (m) Hawan Jump 2.10 Babban Jump 2.23 Babban Jump 1.97 Pole Vault 3.58 Pole Vault 5.65 Pole Vault 5.05 Babban sakamako na karshe (m)
- A cikin tantanin halitta D10 irin "tsalle-tsalle" (babu quotes). Dabarar za ta duba a cikin wannan tantanin halitta don gano wane daga cikin abubuwan da muke son shi ya sami mafi kyawun sakamakon.
Shigar da MAX IF Nested Formula
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 ma'anar KA KA danna maɓallin Shigar da ke kan keyboard ko danna kan tantanin halitta 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:
= MAX (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 2.23 ya kamata ya bayyana a cikin cell E10 tun wannan shine mafi kyau (mafi girma) tsawo don tsalle mai girma.
- Tsarin lissafin tsararren
{= MAX (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 mafi kyawun sakamakon da aka samu a fili.
Rubuta vault a cikin cell D10 kuma danna maɓallin shigarwa akan keyboard.
Tsarin ya kamata ya dawo da tsawo na mita 5.65 a cikin cell E10.