Mwa zina zambiri zomwe Microsoft Excel imagwira nawo, ntchito ya IF iyenera kufotokozedwa. Ichi ndi chimodzi mwazochita zomwe ogwiritsa ntchito amagwiritsa ntchito nthawi zambiri akamagwiritsa ntchito ntchito. Tiyeni tiwone ntchito ya IF, ndi momwe angagwirire nayo.
Matanthauzidwe ndi cholinga chambiri
IF ngati gawo limodzi la Microsoft Excel. Ntchito zake zimaphatikizapo kutsimikizira kukwaniritsidwa kwa vuto linalake. Pomwe mkhalidwe ukakwaniritsidwa (zowona), ndiye kuti mtengo umodzi umabwezedwa mu khungu momwe ntchito iyi imagwiritsidwa ntchito, ndipo ngati sikukwaniritsidwa (zabodza) - ina.
Matchulidwe a ntchitoyi ali motere: "NGATI (mawu omveka; [mtengo ngati uli wowona]; [mtengo ngati wabodza])."
Chitsanzo chogwiritsa ntchito
Tsopano tiyeni tiwone zitsanzo mwapadera momwe kakhazikitsidwe ka mawu a IF kamagwiritsidwira ntchito.
Tili ndi tebulo lamalipiro. Amayi onse adalandira bonasi pa Marichi 8 pam ruble 1,000. Gome ili ndi mzere womwe umawonetsa jenda ya ogwira ntchito. Chifukwa chake, tifunika kuwonetsetsa kuti mu mzere wokhala ndi "akazi" ofunika. pamzere "Gender", mtengo wa "1000" udawonetsedwa mu foni yotsogola "Premium pofika pa Marichi 8", komanso mzere wokhala ndi "mamuna." m'mizati "Mphoto ya Marichi 8" idayima "0". Ntchito yathu idzatenga mawonekedwe: "IF (B6 =" fem. ";" 1000 ";" 0 ")."
Lowani mawuwa mu chipinda chapamwamba kwambiri chomwe zotsatira zake ziyenera kuwonetsedwa. Asananene mawuwo, ikani chikwangwani "=".
Pambuyo pake, dinani batani la Enter. Tsopano, kuti mawonekedwe awa akuwonekera m'maselo am'munsi, tingoimirira pakona yakumunsi kwa cholembera chodzaza, ndikudina batani la mbewa, ndikusuntha chotembezera pansi pomwe tebulo.
Chifukwa chake, tidapeza tebulo lokhala ndi mzere wokhala ndi ntchito "IF".
Ntchito Yokhala Ndi Zochita Zambiri
Mutha kuyikanso magawo angapo mu ntchito ya IF. Pankhaniyi, kuphatikiza kwa chiganizo chimodzi cha IFE kumachitika. Vutolo likakwaniritsidwa, zotsatira zake zidawonetsedwa m'selo; ngati sizikwaniritsidwa, zotsatira zowonekera zimatengera wothandizira wachiwiriyo.
Mwachitsanzo, tiyeni titenge tebulo lomwelo ndi malipiro a premium pofika pa Marichi 8. Koma, nthawi ino, malinga ndi momwe zinthu ziliri, kukula kwa bonasi kutengera gulu la antchito. Amayi omwe ali ndi maudindo antchito akuluakulu amalandira ma ruble 1,000, pomwe ogwira ntchito amalandira ma ruble 500 okha. Mwachilengedwe, kwa abambo mtundu uwu wa malipiro nthawi zambiri saloledwa, mosasamala mtundu.
Chifukwa chake, chikhalidwe choyamba ndikuti ngati wogwira ntchito ndi wamwamuna, ndiye kuti ndalama zomwe amalandila ndi zero. Ngati mtengo wake ndi wabodza, ndipo wogwira ntchitoyo si wamwamuna (mwachitsanzo mkazi), ndiye kuti wachiwiri amayendera. Ngati mzimayiyo ndi wogwira ntchito, ndiye kuti "1000" yiwonetsedwa mu cell, ndi "500". Mwanjira yamawonekedwe, ziziwoneka motere: "= IF (B6 =" amuna. ";" 0 "; IF (C6 =" Basic staff ";" 1000 ";" 500 ")).
Ikani mawuwa mgulu lalikulu kwambiri pamzere wapa mphoto ya "March 8th".
Monga nthawi yathayi, "timakoka" chilinganizo.
Chitsanzo pakukwaniritsa zinthu ziwiri nthawi imodzi
Mutha kugwiritsanso ntchito ntchito ya NDI pantchito ya IF, yomwe imakupatsani mwayi woganiza zowona pokhapokha ngati zinthu ziwiri kapena zingapo zakwaniritsidwa nthawi imodzi.
Mwachitsanzo, m'malo mwathu, mwayi woperekedwa ndi Marichi 8 mu kuchuluka kwa ma ruble 1000 umaperekedwa kwa akazi okha omwe ndi ogwira ntchito, ndipo abambo ndi amayi oimira omwe amalembetsa ngati othandizira samalandira chilichonse. Chifukwa chake, kuti phindu mu maselo a "Ndalama Pofika pa Marichi 8" likhale 1000, pali zinthu ziwiri zofunika kukwaniritsidwa: jenda - akazi, gulu la ogwiritsira ntchito. Muzochitika zina zonse, mtengo wopezeka m'maselo awa ndizoyambira zero. Izi zalembedwa ndi kachitidwe kotsatila: "= IF (NDI (B6 =" mkazi. "; C6 =" Oyang'anira nduna ");" 1000 ";" 0 ")." Ikani mu cell.
Monga kale, koperani mtengo wa formula ku maselo pansipa.
Chitsanzo chogwiritsa ntchito wothandizira wa OR
Ntchito ya IF ingagwiritsenso ntchito wothandizira wa OR. Zimatanthawuza kuti mtengo wake ndiowona ngati chimodzi mwazinthu zingapo zakhutitsidwa.
Chifukwa chake, tingoyerekeza kuti pofika pa Marichi 8, mphotho idakhazikitsidwa pa ruble 100 kokha kwa amayi omwe ali m'gulu la ogwira ntchito. Pankhaniyi, ngati wogwira ntchitoyo ndi wamwamuna, kapena wogwira ntchito yothandizira, ndiye kuti phindu la bonasi yake lidzakhala zero, mwinanso ma ruble 1000. Mwanjira yamawonekedwe, zikuwoneka ngati izi: "= IF (OR (B6 =" amuna. "; C6 =" Othandizira ");" 0 ";" 1000 ")." Timalemba formula iyi mu foni yofananira.
"Kokani" zotsatira pansi.
Monga mukuwonera, ntchito ya "IF" ikhoza kukhala yothandizira bwino wogwiritsa ntchito ndi data mu Microsoft Excel. Zimakuthandizani kuti muwonetse zotsatira zomwe zimakwaniritsa zinthu zina. Palibe chilichonse chovuta kudziwa bwino momwe mungagwiritsire ntchito ntchito imeneyi.
