Kunyorera AND, OR, uye IF Imabasa mu Excel

Kushandisa mabasa anonzwisisika kuedza mamiriro ezvinhu mazhinji

IYI,, uye IF uye IF mabasa ndeimwe yemabasa anonyatsozivikanwa eExpcel .

Izvo zvinoitwa neAU uye NOMUSORO, sezvinoratidzwa mumitsara miviri nehatu mumufananidzo uri pasi apa ndiyo miedzo yakawanda mitemo uye, zvichienderana nebasa ripi rinoshandiswa, rimwechete kana kuti yese mitemo inofanirwa kuva yechokwadi nokuda kwebasa kudzorera mhinduro dzechokwadi. Kana zvisina kudaro, basa rinodzoka FALSE sechikosha.

Mumufananidzo uri pasi apa, mitemo mitatu inoedzwa nemazano mumitsara mbiri nehatu:

• Iko kukosha muchitokisi A2 pasi pe50;
• Iko kukosha muchitokisi A3 isingaenzani 75;
• Iko kukosha muchitokisi A4 chikuru kupfuura kana chakaenzana ne100.

Nokuda kweOO basa , kana imwe yemamiriro aya ichokwadi, basa rinodzorera kukosha kwe TRUE muchitokisi B2.

Nokuda kweKO uye Kushanda, zvinhu zvitatu zvinofanira kuva zvechokwadi nokuda kwebasa rinodzorera kukosha kwechokwadi muchenge B3.

Kubatanidza OR ne IF, kana ye AND AND uye IF Functions mu Excel

Saka iwe une OR uye EYE mabasa. Zvino chii?

Kuwedzera mune IF Function

Kana rimwe remabasa maviri aya rakabatanidzwa neAIP basa, iyo inogadzirwa yakakura ine simba guru.

Nesting mabasa mu Excel inoreva kuisa rimwe basa mukati meumwe. Nzvimbo yakasikwa inoshanda seimwe yezvakakosha zvemashoko .

Mumufananidzo wepamusoro, mitsetse mana kusvika kune yechinomwe ine mazamu ayo AND AND kana OR basa iri mudendere mukati memutambo we IF.

Mune mienzaniso yose, basa rakasvibiswa rinoshanda seCIP basa rokutanga kana Logical_test nharo.

= IF (OR (A2 <50, A3 <> 75, A4> = 100), "Data Yakarurama", "Dambudziko Risiri")

= IF (uye (A2 <50, A3 <> 75, A4> = 100), Nhasi (), 1000)

Kushandura Mutemo Output

Muzvinyorwa zvose mumitsara mana kusvika kune yechinomwe, yeA AND neOO mabasa inofanana nevamwe vavo mumitsara mbiri neyatu pakuti vanoedza dhesi mumasero A2 kusvika kuA4 kuti vaone kana inosangana nemamiriro aidiwa.

Iko IF inoshanda inoshandiswa kudzora mararamiro acho kubva pane izvo zvakapindirwa kwemashoko echipiri uye chechitatu.

Izvi zvinogona kuva:

• Nyora - mutsara mana;
• Mutsara wezvikamu mashanu;
• Izvo zvinobva kune rimwe basa kana rondedzero - mutsara wechishanu (TODAY basa) uye mutsara wechitanhatu;
• Bhokisi risina chinhu-mutsara wechinomwe (sero B7).

Munyaya ye IF / INYAYA iri muchitsi B5, sezvo isiri dzose masero matatu ari mukati maA2 kusvika A4 ndeyechokwadi-kukosha muchitokisi A4 haisi chikuru kupfuura kana chakaenzana ne100-uye iyo basa rinodzorera kukosha kweFALSE.

Iko IF iyo inoshandisa ichi kukosha uye inodzorera kukosha kwayo_if_false argument - zuva razvino raipiwa nebasa reTODAY .

Kune rumwe rutivi, iyo IF / OR mazano mumutsara wechina inodzorera zvinyorwa zvemashoko Data Correct nokuti:

1. IO OR kukosha yakadzorera kukosha kweTUE - kukosha muchitokisi A3 haikwanisi 75.
2. Iyo IF IF basa yakashandisa chigumisiro ichi kuti idzoke kukosha kwayo_if_false argument: Data Yakarurama .

Kunyora Excel IF / OR Formula

Matanho ari pasi apa anokwanisa kuisa iyo IF / OR formula iri muchitokisi B4 mumufananidzo uri pamusoro. Matanho mamwechete anogona kushandiswa pakupinda chero ipi zvayo yeFI mazano mumuenzaniso.

Kunyange zvazvo zvichikwanisika kungonyora fomu yakakwana iri noruoko,

= IF (OR (A2 <50, A3 <> 75, A4> = 100), "Data Yakarurama", "Dambudziko Risiri")

vanhu vazhinji vanozviona zviri nyore kushandisa iyo IF function's dialog box kuisa mazano uye nharo sezvo bhokisi rekukurukurirana rinotarisira mazwi ekutsanangurira akadai sevheparator vatengesi pakati pezvakakwikwidzana uye zvinyorwa zvakapoteredza zvinyorwa muzvinyorwa zvinyorwa.

Nhanho dzinoshandiswa kupinda IN IF / OR formula mumutsara B4 nde:

1. Dzvanya pane sero B4 kuti riite sero rinoshanda .
2. Dzvanya maTramulas tab yebhoni .
3. Dzvanya Logical icon kuti uzarure basa rinoyerera pasi.
4. Dzvanya IF kana iri mune urongwa kuti uzarure iyo IF function dialog box.
5. Dzvanya Logical_test line mubhokisi rebhokisi.
6. Pinda zvakakwana NEZVO: OR (A2 <50, A3 <> 75, A4> = 100) muLogical_test line uchishandisa mazita ekutsvaga masero kana zvichidiwa.
7. Dzvanya muKukosha_if_kona mutsara mubhokisi rebhokisi.
8. Nyora mundima Data Correct (hapana nhamba inotsvakwa).
9. Dzvanya pane Value_if_false mutsara mubhokisi rebhokisi.
10. Nyora mumusoro Data Error.
11. Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda.
12. Sezvakambotaurwa pamusoro apa, chirevo chinofanira kuratidza Value_if_kakavhiringidza kweData Yakarurama.
13. Paunenge uchinyora pa cell B4 , basa rakakwana
    = IF (OR (A2 <50, A3 <> 75, A4> = 100), "Data Yakarurama", "Data Error") inowanikwa mubhairi yepamusoro pane pepa rekushanda.