Pakati pa ntchito zambiri zomwe Microsoft Excel zimagwira nazo, ntchito ya IF iyenera kuwonetsedwa. Ichi ndi chimodzi mwa ogwira ntchito omwe abasebenzisi amagwiritsa ntchito nthawi zambiri pochita ntchito pulogalamuyi. Tiyeni tiwone chimene chiri "IF", ndi momwe mungagwirire ntchito.
Kufotokozera ndi zolinga
"NGATI" ndi mbali ya Microsoft Excel. Ntchito yake ndi kuyang'ana kukwaniritsidwa kwake. Ngati chikhalidwechi chikukwaniritsidwa (chowonadi), ndiye kuti mtengo umodzi umabweretsedwa ku selo komwe ntchitoyi ikugwiritsidwa ntchito, ndipo ngati si (zabodza), wina amabwezeretsedwa.
Chidule cha ntchitoyi ndi ichi: "IF (mawu omveka; [mtengo ngati woona]; [mtengo ngati wonyenga])".
Chitsanzo chogwiritsa ntchito
Tsopano tiyeni tiyang'ane zitsanzo zeniyeni pamene chigwiritsirochi chikugwiritsidwa ntchito ndi woyendetsa "IF".
Tili ndi tebulo la malipiro. Amayi onse adalandira bonasi pa March 8 mpaka 1000 rubles. Gomeli liri ndi mzere umene umagwirira ntchito. Choncho, tifunikira kuzipanga kuti tipeze tanthauzo la "akazi". m'ndandanda "Gender" mu selo lofanana ndilo "Bonus pa March 8" mtengo "1000" unayikidwa, ndipo mu mizere ndi mtengo "mwamuna." muzitsamba "Premium pa March 8" chinali mtengo "0". Ntchito yathu idzawoneka ngati iyi: "IF (B6 =" mkazi ";" 1000 ";" 0 ")".
Lowetsani mawu awa mu selo yapamwamba kumene zotsatira ziyenera kuwonetsedwa. Asanalankhule chizindikiro "=".
Pambuyo pake, dinani pakani Lowani. Tsopano, kuti mawonekedwe awa awoneke m'maselo apansi, timangopita kumbali ya kumanja ya selo yodzazidwa, dinani pa batani, ndipo yesani pansi pa tebulo.
Kotero, ife tiri ndi tebulo ndi chingwe chodzazidwa ndi IF ntchito.
Chitsanzo cha ntchito ndi zinthu zingapo
Mu ntchito "IF" mungathenso kulowa muzinthu zingapo. Pachifukwa ichi, chidindo cha woyendetsa wina "IF" kwa wina chikugwiritsidwa ntchito. Pamene chikhalidwechi chikukwaniritsidwa, zotsatira zake ziwonetsedwa mu selo, ngati chikhalidwe sichinakwaniritsidwe, ndiye zotsatira zowonetsera zimadalira ochita opaleshoni yachiwiri.
Mwachitsanzo, tiyeni titenge tebulo lomwelo ndi malipiro apamwamba pa March 8. Koma, nthawi ino, malingana ndi zofunikira, kuchuluka kwa bonasi kumadalira gulu la wogwira ntchitoyo. Akazi omwe ali ndi udindo wa antchito apamtima amalandira ndalama zokwana 1000 rubles, ndipo antchito othandizira amalandira rubles 500 okha. Mwachibadwidwe, kwa amuna mtundu uwu wa malipiro sungaganizire nkomwe, mosasamala kanthu za gululo.
Choncho, vuto loyamba ndi lakuti ngati wogwira ntchitoyo ndi wamwamuna, ndiye kuti bonasiyo imalandira zero. Ngati mtengo umenewu ndi wabodza, ndipo wogwira ntchitoyo si mwamuna (mwachitsanzo, mkazi), ndiye kuti wachiwiri ndiyeso. Ngati mkaziyo ndi wa antchito oyambirira, ndiye kuti mtengowo udzawonetsedwa mu selo - "1000", ndipo mosiyana - "500". Ngati: "=" (= "" mwamuna ";" 0 "; IF (C6 =" Anthu oyambirira ";" 1000 ";" 500 "))".
Ikani mawu awa mu selo lapamwamba pa "Bonus for March 8".
Mofanana ndi nthawi yotsiriza, timakokera njirayi pansi.
Chitsanzo ndi zinthu ziwiri panthawi yomweyo
Mu ntchito "IF" mungagwiritsirenso ntchito woyendetsa "AND", zomwe zimakulolani kulingalira zoona zokhazokha zokwaniritsa zochitika ziwiri kapena zingapo nthawi imodzi.
Mwachitsanzo, pofika pa March 8, ndalama zokwanira 1000 za ruble zimaperekedwa kwa amayi okha omwe ali ogwira ntchito, ndipo amuna, ndi amayi omwe amawerengedwa ngati othandizira, salandira kalikonse. Choncho, kuti phindu mu maselo a pamphindi "Mphoto ya pa March 8" ikhale 1000, zikhalidwe ziwiri ziyenera kuchitidwa: azimayi - azimayi, ogwira ntchito - ogwira ntchito. Muzochitika zina zonse, phindu m'maselo awa lidzakhala loyambirira. Izi zidalembedwa ndi izi: "= IF (NDI (B6 =" mkazi "; C6 =" Ogwira ntchito yapamtima ");" 1000 ";" 0 ")". Ikani izo mu selo.
Mofanana ndi nthawi zammbuyo, timatsanzira ubwino wa mawonekedwe m'maselo omwe ali pansipa.
Chitsanzo chogwiritsa ntchito woyendetsa "OR"
Ntchito ya IF ingagwiritsenso ntchito OR OR. Zimatanthawuza kuti mtengo ndi woona ngati chimodzi mwazifukwa zambiri chikugwirizanitsidwa.
Choncho, tiyerekeze kuti pa March 8, pulogalamuyi ndi 100 rubles okha omwe ali pakati pa antchito ofunika. Pankhaniyi, ngati wogwira ntchitoyo ndi munthu, kapena akutanthauza othandizira, phindu la bonasi yake lidzakhala zero, ndipo mwina - ruble 1000. Mu mawonekedwe a mawonekedwe, zikuwoneka ngati izi: "= IF (OR (B6 =" mwamuna "; C6 =" Antchito othandizira ");" 0 ";" 1000 ")". Lembani mndandanda uwu mu selo yoyenera pa tebulo.
Kutenga zotsatira pansi.
Monga mukuonera, ntchito "IF" ingakhale mthandizi wabwino kwa wosuta pamene akugwira ntchito ndi data mu Microsoft Excel. Ikuthandizani kuti muwonetse zotsatira zomwe zikugwirizana ndi zikhalidwe zina. Palibe chovuta kwambiri pakuzindikira mfundo zoyenera kugwiritsa ntchito ntchitoyi.
