Hada MEDIAN da IF aikace-aikace a cikin takarda Array
Wannan misali na kwalejin yana amfani da matakan MEDIAN IF don gano tsakiyar ƙaƙafan ayyukan biyu.
Halin yanayin ya ba mu damar bincika sakamako masu yawa ta hanyar canza yanayin bincike - a cikin wannan yanayin, sunan aikin.
Ayyukan kowane ɓangare na ma'anar ita ce:
- aikin MEDIAN yana samun darajar tsakiyar aikin
- Ayyukan IF yana ba mu damar zaɓar wane aikin da muke son ƙaddamarwa ta hanyar kafa yanayin ta amfani da sunayen ayyukan
- Daftarin tsari ya ba da izinin aikin IF don sharuɗɗan yanayi a cikin tantanin tantanin halitta guda ɗaya, kuma, lokacin da aka cika yanayin, tsarin da aka tsara ya ƙayyade abin da bayanai (abubuwan da aka ba da aikin) aikin MEDIAN zai bincika don samun tsakiyar ƙarancin
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 .
MEDIAN IF Nested Formula Syntax da jayayya
Maganar don tsarin MEDIAN IF shine:
& # 61; MEDIAN (IF (logical_test, value_if_true, value_if_false))
- Tun da aikin IF wanda aka samo shi a cikin aikin MEDIAN, aikin IF duka shine ƙaddamarwa ɗaya don aikin MEDIAN
Ƙ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
Hanyoyin Fassara da Fassara Idan Fassara Formula Misali
Kamar yadda aka ambata, misalin ya nema nuni ga ayyukan daban-daban guda biyu don samo tsakiyar tsakiya ko na tsakiya. Ƙididdigar aikin IF yana cika wannan ta hanyar kafa yanayin da ke biyo baya da sakamakon:
- gwaji na gwaji ya yi ƙoƙari don nemo wasan don sunan aikin ya shiga cikin tantanin halitta D10 na takardar aiki
- Tambayar value_if_true za ta kasance, tare da taimakon aikin MEDIAN, tsakiyar m ga aikin zaɓaɓɓe
- Za'a ƙaddamar da gardama mai muhimmanci_if_false tun lokacin da ba a buƙata kuma rashi ba zai rage takaicin. Idan wani sunan aikin da ba a cikin kwamfutar data ba - irin su aikin C - an sare shi zuwa cikin tantanin halitta D10 wannan tsari zai dawo da zero (0)
Shigar da Bayanan Tutorial
- Shigar da wadannan bayanan cikin sel D1 zuwa E9 kamar yadda aka gani a hoton da ke sama: Tsarin Tenders Project Shirin Shirin Aikin $ 15,785 Aikin $ 15,365 Aikin $ 16,472 B $ 24,365 Bikin Shirin B $ 24,612 B $ 23,999 Tsarin Tsarin Hanya
- A cikin tantanin halitta D10 irin wannan "Aikin A" (ba a faɗi) ba. Dabarar zata duba cikin wannan tantanin halitta don gano wane aikin zai dace.
Shigar da MEDIAN 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:
= MEDIAN (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 15875 ($ 15,875 tare da tsarawa) ya kamata ya bayyana a cikin tantanin halitta E10 tun da wannan shine tsakiyar m ga Project A
- Tsarin lissafin tsararren
{= MEDIAN (IF (D3: D8 = D10, E3: E8))}
za a iya gani a cikin maɓallin tsari a sama da takardun aiki
Gwada tsarin
Gwada wannan matsala ta hanyar gano tsakiyar m ga Project B
Rubuta Bikin B a cikin cell D10 kuma danna maɓallin Shigar da ke keyboard.
Ma'anar ya sake mayar da darajan 24365 ($ 24,365) a cikin cell E10.