Kukhazikitsa NDI, OR, ndi IF Functions mu Excel

Pogwiritsira ntchito ntchito zomveka kuti ayese zinthu zambiri

Ntchito ndi, OR kapena IF ntchito ndi zina mwa ntchito zomveka bwino za Excel.

Zomwe OR ndi ntchito YAM'MBUYO YAM'MBUYO YOTSATIRA TUMIZANI LINKI SINDIKIZANI KOPERANI Magazini Mabuku Nyimbo Mavidiyo Zina ... DZIWANI ZA Mayankho a M'Baibulo Mboni za Yehova KOPERANI Magazini Mabuku Nyimbo Mavidiyo Zina ... NKHANI ZOTHANDIZA Anthu Apabanja Ndiponso Makolo Achinyamata Ana TIPEZENI Pemphani Munthu Woti Aziphunzira Nanu Baibulo Ngati ayi, ntchitoyo imabwerera FALSE ngati mtengo.

Mu fano ili m'munsimu, zinthu zitatu zimayesedwa ndi mayina awiri ndi atatu:

Kwa OR ntchito , ngati chimodzi mwazimenezo ndi zoona, ntchitoyo imabweretsanso mtengo wa TRUE mu selo B2.

Kwa Ntchito ndi NTCHITO, zinthu zonse zitatu ziyenera kukhala zowona pa ntchitoyo kubwezera mtengo wa CHOONA mu selo B3.

Kuphatikizana ndi OR ndi IF, kapena YES ndi ntchito IF Excel

© Ted French

Kotero muli ndi OR ndi ntchito. Tsopano chiyani?

Kuwonjezera pa Ntchito IF

Pamene chimodzi mwa ntchito ziwirizi chikuphatikizidwa ndi IF, ntchitoyi imakhala ndi mphamvu zambiri.

Kutsekera kumatenda ku Excel kumatanthauza kuyika ntchito imodzi mkati mwa wina. Ntchito yachisala ikugwira ntchito ngati imodzi mwa mfundo zazikuluzikulu za ntchito.

Mu chithunzi pamwambapa, mzere wachinayi mpaka asanu ndi awiri uli ndi mayendedwe kumene AND kapena ntchito OR imakhala mkati mwa ntchito IF.

Mu zitsanzo zonse, ntchito yachisala ikugwira ntchito ngati IF ntchito yoyamba kapena Logical_test kukangana.

= IF (OR (A2 <50, A3 <> 75, A4> = 100), "Data Olungama", "Cholakwika Cha Data")
= IF (NDI (A2 <50, A3 <> 75, A4> = 100), MASIKU (), 1000)

Kusintha Makhalidwe Othandizira

Mu njira zonse m'magawo anayi mpaka asanu ndi awiri, ntchito za AND ndi OR zili zofanananso ndi anzawo pa mizere iwiri ndi itatu kuti ayese deta m'maselo A2 mpaka A4 kuti awone ngati ikugwirizana ndi chikhalidwe chofunikira.

Ntchito ya IF imagwiritsidwa ntchito kuthetsa chigamulocho chokhudzana ndi zomwe zalembedwera pazitsulo chachiwiri ndi chachitatu.

Izi zikhoza kukhala:

Pankhani ya IF / AND formula mu selo B5, popeza kuti maselo onse atatu a A2 mpaka A4 ali oona-mtengo mu selo A4 siwoposa kapena wofanana ndi 100-ndi-ntchito amabwezeretsa mtengo Wachiwongola dzanja.

Ntchito ya IF imagwiritsira ntchito phindu ili ndikubwezeretsanso kufunika kwake_ku_kutsutsana ndemanga - tsiku lamakono lomwe limaperekedwa ndi ntchito ya MASIKU ano .

Kumbali ina, fomu ya IF / OR mu mzere wachinayi imabweretsanso mawu olembedwa Data Correct chifukwa:

  1. Kulemera kwa OR kunabweretsa mtengo weniweni - mtengo mu selo A3 suli ofanana 75.
  2. Ntchito ya IF inagwiritsira ntchito zotsatirazi kuti ibwezeretsedwe Kwake_ku_kukangana mkangano: Dongosolo lolondola .

Kulemba Excel IF / OR Mpangidwe

Masitepe omwe ali m'munsiyi akuthandizani momwe mungayankhire fomu ya IF / OR yomwe ili mu selo B4 mu chithunzi pamwambapa. Njira zomwezo zingagwiritsidwe ntchito polowera zina za IF IF mu chitsanzo.

Ngakhale kuti n'zotheka kungolemba njira yonseyo pamanja,

= IF (OR (A2 <50, A3 <> 75, A4> = 100), "Data Olungama", "Cholakwika Cha Data")

Anthu ambiri amavutika kuti agwiritse ntchito bokosi la ntchito la IF kuti afikitse ndondomeko ndi zokambirana pamene bokosi lamasewero limasamalira mawu omasulira monga osiyanitsa makina pakati pa zotsutsana ndi zolembedwera zomwe zili mkati mwazolemba.

Njira zomwe zimagwiritsidwa ntchito kulowa fomu ya IF / OR mu selo B4 ndi:

  1. Dinani pa selo B4 kuti mupange selo yogwira ntchito .
  2. Dinani pa Fomu tab ya riboni .
  3. Dinani chizindikiro cha Logical kuti mutsegule ntchito yotsitsa ndandanda.
  4. Dinani IF ngati mndandanda kuti mutsegule IF function function dialog box.
  5. Dinani Logical_test mzere mu bokosi la bokosi.
  6. Lowani zonse ndi NTCHITO: OR (A2 <50, A3 <> 75, A4> = 100) mu Logical_test line pogwiritsa ntchito mafotokozedwe a selo ngati mukufuna.
  7. Dinani ku Value_if_ndondomeko yowona mu bokosi la bokosi.
  8. Lembani mndandanda wa Data Correct (palibe ndondomeko zoyenera).
  9. Dinani pa Value_if_false mzere mu bokosi la bokosi.
  10. Sakani mndandandawo Cholakwika cha Deta.
  11. Dinani OK kuti mutseke bokosi la bokosi ndi kubwerera kuntchito.
  12. Monga tafotokozera pamwambapa, ndondomekoyi iyenera kuwonetsa Value_if_tsutso lenileni la Data Yolondola.
  13. Mukasindikiza pa selo B4 , ntchito yonse
    = IF (OR (A2 <50, A3 <> 75, A4> = 100), "Chidziwitso Chodziwika", "Cholakwika Cha Data") chikupezeka mu barra yazenera pamwamba pa tsamba.