Ntchito "ngati" ku Excel

Mwa ntchito zambiri zomwe Microsoft Excel imagwira ntchito, muyenera kusankha "ngati" ntchito. Ichi ndi chimodzi mwa omwe amagwiritsa ntchito omwe ogwiritsa ntchito amayambira nthawi zambiri akamagwira ntchito mu pulogalamuyi. Tiyeni tichitepo ndi zomwe ndi zomwe mungagwiritse ntchito nazo.

Tanthauzo la General ndi ntchito

"Ngati" ndi mawonekedwe a Microsoft Excel. Ntchito zake zimaphatikizanso kuyang'ana mkhalidwe weniweni. Makhalidwe akamachitidwa (chowonadi), ndiye mu khungu, komwe ntchitoyi imagwiritsidwa ntchito ndi mtengo umodzi, ndipo ngati sizikuchitika.

Kafukufukuyu wa izi ndi motere: "Ngati (mawu omveka; [Ntchito ngati chowonadi];

Chitsanzo Chogwiritsa Ntchito "Ngati"

Tsopano tiyeni tikambirane zitsanzo za anthu omwe gawo la "ngati" wogwiritsa ntchito amagwiritsidwa ntchito.

1. Tili ndi tebulo la malipiro. Amayi onse adayala ndalama mpaka 8 Marichi mu ma ruble 1000. Gome lili ndi khola lomwe pansi limafotokozedwa. Chifukwa chake, tiyenera kuwerengera akazi pamndandanda woperekedwa ndi mndandanda komanso m'mizere yolingana ya "mphothoyo mpaka pa Marichi 8" mzere wa "1000". Nthawi yomweyo, ngati pansi sikufanana ndi mkazi, mtengo wa zingwe zotere uyenera kufanana ndi zigawenga "0". Ntchitoyo itenga mtunduwu: "Ngati (B6 =" Akazi. ";" 1000 ";" 0 ")". Ndiye kuti, zikachitika kuti mayeso ndi "chowonadi" (ngati chikakhala kuti mkazi wokhala ndi mawu, ndiye kuti "ndi" mabodza "). Wina" kutanthauza, kupatula "akazi."), motero, komaliza - "0".
2. Timalowetsa mawu awa mu khungu lalikulu kwambiri, pomwe zotsatira zake ziyenera kuwonetsedwa. Musanawonekere, ikani chizindikirocho "=".



3. Pambuyo pake, kanikizani batani la Enter. Tsopano kuti formula iyi imapezeka mu maselo apansi, ingoikeni cholembera kumanzere kwa cell yodzaza, dinani batani lakumanzere ndipo, popanda kumasula, gwiritsani ntchito chotembereredwa pansi pa tebulo.



4. Chifukwa chake tili ndi tebulo lokhala ndi mzati wodzaza ndi "ngati" ntchito.

Chitsanzo cha ntchito ndi zinthu zingapo

Mu "ngati" ntchito, mutha kulowanso zingapo. Munthawi imeneyi, wogwirizira m'modzi "ngati" amagwiritsidwa ntchito kwa wina. Momwe mkhalidwe umachitikira mu khungu, zotsatira zotchulidwa zimawonetsedwa, ngati vutolo silinachitike, zotsatira zake zimatengera wothandizira wachiwiri.

1. Mwachitsanzo, tengani tebulo lonselo ndi zolipira za mphotho ya Marichi 8. Koma nthawi ino, malinga ndi momwe zinthu ziliri, kukula kwa mtengo kumatengera gulu la wogwira ntchito. Amayi omwe ali ndi udindo wa ogwira ntchito kwambiri amalandila bonasi ya 1000, ndipo ogwira ntchito ogwira ntchito amalandira ma ruble 500 okha. Mwachilengedwe, amuna sapeza ndalama zamtunduwu mosasamala kanthu za gululo.
2. Mkhalidwe woyamba ndikuti ngati wogwira ntchito ali bambo, ndiye kuti mtengo wa mtengo womwe walandila ndi zero. Ngati mtengo wake ndi wabodza, ndipo wogwira ntchito si bambo (ndiye mkazi), ndiye kuti mayeso a mkhalidwe wachiwiri uyamba. Ngati mkazi akunena za ogwira ntchito, mtengo wa "1000" udzawonetsedwa mu khungu, ndipo motsutsana - "500". Mu fomulayi, iwoneka motere: "= Ngati (B6 =" Mwamuna. "Ngati (1))))))))).
3. Timayika mawu awa ndi khungu lapamwamba la "mphotho ku March 8" mzati.



4. Ngati nthawi yotsiriza, "Tambasulani" njira.

Mwachitsanzo ndi kuphedwa kwa zinthu ziwiri nthawi imodzi

Mu "ngati" ntchito, mutha kugwiritsanso ntchito yogwiritsa ntchito "ndi" wothandizira, zomwe zimakupatsani mwayi woti muwerengere kuphedwa koona kwa zinthu ziwiri kapena zingapo nthawi imodzi.

1. Mwachitsanzo, muzochitika zathu, ndalama za March 8 mu ruble ruble 1000 zimaperekedwa kwa azimayi okha omwe ndi omwe ali ogwira ntchito kokha, ndipo amuna ndi akazi ndi akazi omwe adalembedwa ndi ochita opareshoni sanalandiridwe. Mwanjira imeneyi mtengo wake m'maselo a mphotho ya March 8 anali 1000, ndikofunikira kutsatira zinthu ziwiri: pansi ndi wamkazi, gulu la ogwira ntchito ndi antchito akulu. Nthawi zonse, kufunika m'maselo izi kumakhala zero. Izi zalembedwa ndi njira zotsatirazi: "= ngati (ndi (B6 =" Akazi. "; C6);" 0 ")". Ikani mu khungu.



2. Koperani mtengo wa mtundu wa maselo pansipa, chimodzimodzinso mu njira zomwe zili pamwambapa.

Chitsanzo cha kugwiritsa ntchito wothandizira "kapena"

"Ngati" ntchito "ikhoza kugwiritsanso ntchito" kapena "wothandizira. Zimatanthawuza kuti mtengo wake ndi wowona ngati chimodzi mwazinthu zingapo chimachitika.

1. Chifukwa chake, tiyerekeze kuti mtengowo pofika pa Marichi 8 ndi ma ruble a 1000 okha kwa akazi omwe ali m'gulu la antchito akuluakulu. Pankhaniyi, ngati wogwira ntchitoyo ali munthu kapena amangotanthauza a Aaxikulu, ndiye kukula kwa mphotho yake kumakhala zero, ndipo mwina - ma ruble 1000. Monga njira, zimawoneka ngati izi: "= Ngati (kapena (b6 =" Mwamuna. ";" 1000 ")". Lembani mu kanema woyenera.



2. "Ikulutsani" zotsatira.

Monga mukuwonera, "ngati" ntchitoyo ikhoza kukhala kuti wogwiritsa ntchito wabwino akamagwira ntchito ndi ma microsoft exroft. Zimakupatsani mwayi wowonetsa zotsatira zofanizira pamikhalidwe ina.