Mid ka mid ah odhaahyada inta badan la isticmaalo ee ku dhawaad ​​​​af kasta oo barnaamij-waxbarasheed ah waa bayaanka IF. Markaa waa inayna la yaab noqon in isticmaalka IF iyo bayaannada IFKA ee Google-ka ee xaashida^{(Google Sheets)} ah ay aad caan u yihiin oo faa'iido badan u leeyihiin.

Bayaanka IF ee xaashiyaha Google^{(Google Sheets)} wuxuu kuu ogolaanayaa inaad geliso hawlo kala duwan unug ku salaysan xaaladaha unugyo kale. Markaad buul ka dhigto hadallada IF, waxaad abuuri kartaa falanqayn aad u horumarsan oo ku salaysan xogta. Maqaalkan, waxaad ku baran doontaa sida tan loo sameeyo iyo sidoo kale waxaad arki doontaa dhowr tusaale.

Isticmaalka Qoraalka IF^{(IF Statement)} ee Google Sheets

Kahor intaadan helin qurux badan oo aadan bilaabin buul-ku-galka HADDII, waxaad u baahan tahay inaad fahanto sida qoraalka fudud ee HADDII uu marka hore uga shaqeeyo Google Sheets .

Sida ugu fudud ee tan lagu fahmi karo waa tusaale. Tusaalahayaga ugu horreeya, qiyaas inaad soo jiidatay liiska buuraha aad ku fikirayso inaad ka lugayso intarneedka, oo ay la socoto jooggooda.

Waxa kaliya oo aad xiisaynaysaa in aad ku socoto buuro ka sarreeya 3000 cagood. Markaa waxaad abuurtaa tiir kale oo la yiraahdo "In ka badan 3000 Feet". Qoraalka HADDII waa habka ugu fudud ee lagu buuxin karo goobtan.

Waa kan sida bayaanka IF u shaqeeyo:

HADDII (macnaha_muuska, qiimaha_if_run, value_if_false)^{(IF(logical_expression, value_if_true, value_if_false))}

Halbeegyada ku jira bayaan IF waxay u shaqeeyaan sida soo socota:

• Logical_expression : Kani waa bayaan shuruudaysan iyadoo la isticmaalayo hawlwadeenada sida <,>, ama =.
• Value_if_true : Geli waxa aad rabto qolka dhexdiisa haddii hadalka macquulka ah uu yahay RUN^(TRUE) .
• Value_if_false : Geli waxa aad rabto qolka dhexdiisa haddii hadalka macquulka ah uu yahay BEEN^(FALSE) .

Tusaalahan, ku bilow safka kowaad oo dhig calaamada unugga C2. Kadibna, ku qor qaacidada soo socota:

=IF(B2>3000,”YES”,”NO”)

Hadalkan HADDII micnihiisu waa haddii joogga buurta unugga B2 uu ka weyn yahay 3000, dabadeed ku muuji HAA^(YES) gudaha unugga C2, haddii kale muuji MAYA.

Riix Geli^(Enter) oo waxaad ku arki doontaa natiijada saxda ah ( HA^(YES) ) gudaha unugga C2.

Waxa kale oo aad arki kartaa soo jeedinta Xaashiyaha Google^{(Google Sheets)} si aad si otomaatig ah ugu buuxiso inta hadhay ee unugyada ka hooseeya kan. Dooro calaamadda haddii aad rabto inaad hore u socoto oo si otomaatig ah u buuxi unugyada intiisa kale oo leh isla shaqadan. Tixraacyadu waxay si toos ah u cusbooneysiin doonaan unugyada saxda ah ee buurahaas dhaadheer.

Haddii aadan arkin taladan, waxaad ku hayn kartaa furaha Shift ee kumbuyuutarkaaga oo laba jeer guji afargeeska yar ee ku yaal geeska midig ee hoose ee unugga halkaasoo aad ka gashay qaacidada koowaad.

Isticmaalka Nsted IF Oraahyada Google ^(Statements)-^(Google) ka

Hadda aan eegno tusaale abuurista qoraal IFTIIN ah oo ku jira Google Sheets .

Adigoo isticmaalaya tusaale la mid ah kan sare, aan nidhaahno waxaad doonaysaa inaad hesho buurta ugu horreysa liiska oo aan ka badnayn 3,000 cagood xagga sare si aad u doorato socodkaaga "fudud" ee xiga. Si aad kor ilaa hoos uga raadiso tiir shayga xiga ee shardiga ku habboon waxa uu u baahan yahay bayaan HADDII.

Geli calaamadeeyaha qolka halka aad jeclaan lahayd in natiijadu tagto. Kadibna, ku qor qaacidada soo socota:

=IF(B2<3000,A2,IF(B3<3000,A3,IF(B4<3000,A4,IF(B5<3000,A5,IF(B6<3000,A6,IF(B7<3000,A7,IF(B8<3000,A8,IF(B9<3000,A9,IF(B10<3000,A10,IF(B11<3000,A11,IF(B12<3000,A12,IF(B13<3000,A13,IF(B14<3000,A14,IF(B15<3000,A15,”None”))))))))))))))

Waxay u egtahay xoogaa waalan, saw maaha? Haa, HADDII odhaahyada buulku way adkaan karaan. Aan kala jebinno kan si ay macno badan u yeelato.

Qaybta hore ee bayaanka ( =IF(B2<3000 ) waxay hubinaysaa haddii unugga ugu horreeya ee tiirarka uu ka yar yahay 3000. Haddii ay tahay, markaa taasi waa buurta ugu horreysa ee liiska ka hooseeya 3000 oo markaa waxay soo celin doontaa A2 ( , A2 ). ) mar haddii ay taasi run tahay. 

Haddii ay been tahay, markaas waxaad u baahan tahay inaad buul kale dhigto HADDII warbixin si aad u hubiso tiirka soo socda ( ,IF(B3<3000 )) Haddii ay tani run tahay, soo celi A3 ( , A3 )

Waxaad ku celisaa buulkan weedhaha HADDII ilaa aad ka gaadhayso ilaa A15 , ka dibna xidhid dhammaan bayaannada leh jilaha soo noqnoqda ee ")".

Waxaad ogaan doontaa cabbirka "beenta" ee u dambeeya ee buulka ku jira HADDII uu bayaanku yahay "Maya"^(“None”) . Tani waa sababta oo ah haddii A15 aanu ka hoosayn 3000 cagood midkoodna, markaa midna buuruhu kama hoos jiraan 3000 cagood.

Tusaalahan, waa kan sida ay natiijadu u ekaan doonto unugga D2.

^(Pro-tip)Talo^{(VLOOKUP functions)} bixin: Habka ugu fudud ee tan loo sameeyo waa in la isticmaalo INDEX , MATCH , iyo VLOOKUP .

Ku Nool HADDII Bayaan^{(IF Statement)} Lagu Helo Nambarka Ugu Sareeya^{(Highest Number)}

Tusaalaha hore, HADDII bayaannada waxaa lagu dhejiyay sidii cabbirro been^(FALSE) abuur ah oo ku dhex jira bayaan IF ka hor. Tusaalaha lidka ku ah buul-ku-galka HADDII bayaannada ayaa buulkooda u dhigaya cabbirro RUN^(TRUE) ah.

Waxaad isticmaali kartaa habkan si aad u hesho lambarka ugu sarreeya ee liiska. Tusaale ahaan, aan dhahno waxaad haysaa liiska ardayda iyo buundooyinka imtixaankooda. Waxaad dooneysaa inaad isticmaasho bayaannada IFKA si aad u heshid darajada ugu sareysa.

Geli calaamadeeyaha qolka aad rabto inaad natiijada ku dhejiso oo ku qor caanaha soo socda:

=IF(B2>B3,IF(B2>B4,B2,IF(B4>B3,B4,B3)),B3)

Qaybta hore ee bayaanka ( =IF(B2>B3 ) waxay hubinaysaa haddii unugga kowaad ee tiirka uu ka weyn yahay kan labaad, haddii uu yahay, markaa unuggaas (B2) ayaa laga yaabaa inuu yahay kan ugu weyn, laakiin waxaad weli u baahan tahay inaad hubiso naso.Sidaas darteed meeshii aad ka geli lahayd cabbirka RUNTA^(TRUE) ah, waxaad buul kale ku dhejin doontaa HADDII bayaan ka hubinaya B2 ka dhanka ah B4. 

• Haddii B2 uu weli ka weyn yahay B4, waa lambarka ugu weyn oo waxaad ku soo celin kartaa B2 oo ah cabbirka RUNTA^(TRUE) ee xiga . 
• Haddii aysan taasi ahayn, B4 waxa ay noqon kartaa tirada ugu badan. Markaa halbeegga beenta^(FALSE) ah wuxuu u baahan yahay inuu B4 ka eego B3. Haddii ay ka weyn tahay, markaas waa lambarka ugu weyn iyo kan kama dambaysta ah HADDII bayaanku wuxuu ku soo celin doonaa B4 cabbirka RUNTA^(TRUE) ah. 
• Haddii aysan taasi ahayn, markaa B3 waa kan ugu weyn waana in lagu soo celiyaa sidii qiyaasta BEENTA^(FALSE) ugu dambeysa . 
• Ugu dambeyntii, haddii jeegga labaad (B2>B4) uu been yahay, markaa B3 ayaa ah kan ugu weyn sababtoo ah qoraalka IF ee ugu horreeya (B2>B3) waa horeba been, markaa B3 waxaa lagu soo celin karaa qiyaastan BEENTA ah.^(FALSE)

Waa kan sida ay natiijadu u egtahay:

Wali ma wareertay?

Keligaa ma tihid Isticmaalka bayaannada buulka leh ee HADDII shay sidan oo kale ah aad bay u dhib badan tahay. Oo mar haddii aad tiro badan ku darto liiska, way sii adkaanaysaa.

Taasi waa sababta Google Sheets ay dhab ahaantii u leedahay shaqada MAX halkaasoo aad si fudud ugu gudbiso tirada unugyada (kiiskan tiirka), oo waxay soo celin doontaa tirada ugu badan. Waxa kale oo jira shaqo MIN ah oo soo celin doonta qiimaha ugu yar.

Buul Xaqiiqda Dhabta Ah Haddii Tusaalaha Xaashiyaha Google -ka^{(Realistic Nested IF Google Sheets Example)}

Labada tusaale ee hore waxaa loogu talagalay inay ku tusaan sida ay u fududahay in lagu galo qas haddii aad isticmaasho odhaahyo buul leh HADDII run ahaantii aadan ahayn. Taasi waa dabin sahlan oo lagu galo. Had iyo jeer raadi mid ka fudud, hal shaqo Google Sheets si aad u gaadho waxa aad isku dayayso inaad samayso.

Tusaale ahaan, aan nidhaahno waxaad leedahay shirkad oo waxaad heshay jawaab celin ku saabsan afar shaqaale. Iyada oo ku saleysan afarta astaamood ee aad ka heshay jawaab celin, waxaad u baahan tahay inaad go'aamiso haddii shaqaale kasta uu yahay agab dalacsiin ah.

Waxaad qori kartaa bayaanka buulka leh ee HADDII kaas oo baari doona jawaabta sifa kasta ka dibna go'aan ka bixi doona tiirka natiijada.

Haddii shaqaaluhu uusan ahayn:

• Waqtigeyga^(Punctual) : Aad ugama welwelsanid, laakiin waxaa laga yaabaa inaadan dallacsiin (laga yaabee inaadan ahayn).
• Waxtarka leh^(Efficient) : Aad ugama werwerin, waxaana laga yaabaa in aad wali kor u qaaddo (laga yaabee).
• Tayada Hogaaminta^{(Leadership Quality)} : Waxaa laga yaabaa inaadan dalacsiinin haddii aad ku raacsan tahay jawaab celinta (laga yaabee inaadan ahayn).
• Lagu kalsoonaan^{(Trustworthy)} karo: Xaqiiqdi ma rabtid inaad kor u qaaddo (ma hubo).

Waxaad u habayn kartaa go'aamadan bayaanka IFKA. Geli cursorka qolka aad rabto natiijada oo ku qor qaacidada soo socota:

=IF(B2=”YES”,IF(C2=”YES”,IF(D2=”YES”,IF(E2=”YES”,”Definitely”,”Maybe Not”),”Maybe”),”Maybe Not”),”Definitely Not”)

Kani waa bayaan fudud oo buul ah HADDII oo soo noqda "Xaqiiqdii" haddii dhammaan jawaabaha ay "HAA" yihiin, laakiin haddana soo celisa jawaabo kala duwan iyada oo ku xidhan haddii mid ka mid ah unugyada shakhsigu yahay "MAYA".

Tani waa mid ka mid ah tusaalooyinka dhawrka ah ee ay ku dhawaaqitaan HADDII ay noqon lahayd doorasho wanaagsan. Laakiin sidaan kor ku soo sheegnay, haddii aad u baahan tahay inaad samayso wax aad uga adag, aad baad u wanaagsan tahay inaad raadiso hawl Google Sheets oo jirta oo fulinaysa yool la mid ah si fudud. 

Tusaalooyinka qaarkood ee shaqooyinka "IF" horumarsan waxaa ka mid ah SUMIF , COUNTIFS, SUMIFS, iyo AVERAGEIFS^{(COUNTIFS, SUMIFS, and AVERAGEIFS)} .

How to Use If and Nested If in Google Sheets

One of the most commonly used statements in nearly every programming language is the IF statemеnt. So it should come as no surprise that using IF and nested IF statemеnts in Google Sheets is very popular аnd very useful.

The IF statement in Google Sheets lets you insert different functions into a cell-based on conditions from other cells. When you nest IF statements, you can create more advanced analytics based on data. In this article, you’ll learn how to do this as well as see a few examples.

Using the IF Statement in Google Sheets

Before you can get fancy and start nesting IF statements, you need to understand how a simple IF statement works in Google Sheets first.

The easiest way to understand this is with an example. For our first example, imagine you pulled a list of mountains you’re thinking of hiking from the internet, along with their altitude.

You’re only interested in hiking mountains that are higher than 3000 feet in altitude. So you create another column called “Over 3000 Feet”. An IF statement is the easiest way to fill out this field.

Here’s how an IF statement works:

IF(logical_expression, value_if_true, value_if_false)

The parameters in the IF statement work as follows:

• Logical_expression: This is a conditional statement using operators like <, >, or =.
• Value_if_true: Enter what you want in the cell if the logical expression is TRUE.
• Value_if_false: Enter what you want in the cell if the logical expression is FALSE.

In this example, start with the first row and place the cursor in cell C2. Then, type the following formula:

=IF(B2>3000,”YES”,”NO”)

This IF statement means if the height of the mountain in cell B2 is greater than 3000, then display YES in cell C2, otherwise display NO.

Press Enter and you’ll see the correct result (YES) in cell C2.

You may also see a Google Sheets suggestion to autofill the rest of the cells below this one. Select the checkmark if you’d like to go ahead and autofill the rest of the cells with this same function. The references will automatically update to the correct cells for those mountain heights.

If you don’t see this suggestion, you can hold the Shift key on your keyboard and double-click the small square at the lower right corner of the cell where you entered the first formula.

Using Nested IF Statements in Google Sheets

Now let’s look at an example of creating a nested IF statement in Google Sheets.

Using the same example as above, let’s say you want to find the first mountain in the list that isn’t over 3,000 feet in altitude so you choose it as your next “easy” hike. To search from top to bottom in a column for the next item that matches a condition requires a nested IF statement.

Place the cursor in the cell where you’d like the result to go. Then, type the following formula:

=IF(B2<3000,A2,IF(B3<3000,A3,IF(B4<3000,A4,IF(B5<3000,A5,IF(B6<3000,A6,IF(B7<3000,A7,IF(B8<3000,A8,IF(B9<3000,A9,IF(B10<3000,A10,IF(B11<3000,A11,IF(B12<3000,A12,IF(B13<3000,A13,IF(B14<3000,A14,IF(B15<3000,A15,”None”))))))))))))))

Looks a bit crazy, doesn’t it? Yes, nested IF statements can get complicated. Let’s break this one down so it makes more sense.

The first part of the statement (=IF(B2<3000) checks if the first cell in the column is less than 3000. If it is, then that’s the first mountain on the list under 3000 and so it will return A2 (,A2) since that IF statement is true. 

If it’s false, then you need to nest another IF statement to check the next column (,IF(B3<3000). If this is true, return A3 (,A3)

You repeat this nesting of IF statements until you get all the way down to A15, and then close out all of the if statements with the repeated “)” character.

You’ll notice the last “false” parameter in the nested IF statement is “None”. This is because if A15 isn’t under 3000 feet either, then none of the mountains are under 3000 feet.

In this example, here’s what the result will look like in cell D2.

Pro-tip: A simpler way to do this is to use the INDEX, MATCH, and VLOOKUP functions.

Nested IF Statement to Find the Highest Number

In the previous example, the IF statements were nested as FALSE parameters inside the IF statement before it. An opposite example of nesting IF statements is nesting them as TRUE parameters.

You may use this approach to find the highest number in a list. For example, let’s say you have a list of students and their test grades. You want to use nested IF statements to find the highest grade.

Place the cursor in the cell where you want to place the result and type the following formula:

=IF(B2>B3,IF(B2>B4,B2,IF(B4>B3,B4,B3)),B3)

The first part of the statement (=IF(B2>B3) checks if the first cell in the column is greater than the second. If it is, then that cell (B2) may be the largest, but you still need to check the rest. So in place of the TRUE parameter, you’ll nest another IF statement checking B2 against B4. 

• If B2 is still larger than B4, it’s the largest number and you can return B2 as the next TRUE parameter. 
• If it isn’t, B4 could be the largest number. So the FALSE parameter needs to check B4 against B3. If it is larger, then it’s the largest number and this final IF statement will return B4 in the TRUE parameter. 
• If it isn’t, then B3 is the largest and should be returned as the final FALSE parameter. 
• Finally, if the second check (B2>B4) is false, then B3 is the largest because the first IF statement (B2>B3) is already false, so B3 can be returned as this FALSE parameter.

Here’s what the result looks like:

Confused yet?

You’re not alone. Using nested IF statements for something like this is pretty complicated. And once you add even more numbers to the list, it gets even more complex.

That’s why Google Sheets actually has a MAX function where you simply pass it the range of cells (in this case the column), and it’ll return the maximum number. There’s also a MIN function that will return the minimum value.

A Realistic Nested IF Google Sheets Example

The previous two examples were intended to show you how easy it is to get into a mess if you use nested IF statements when you really shouldn’t. That’s an easy trap to get into. Always look for a simpler, single Google Sheets function to accomplish what you’re trying to do.

For example, let’s say you own a company and you’ve received feedback about four employees. Based on the four characteristics that you received feedback on, you need to determine if each employee is promotion material.

You can write a nested IF statement that’ll examine the answer for each characteristic and then provide a decision in the result column.

If the employee wasn’t:

• Punctual: You’re not too concerned, but you may not promote (maybe not).
• Efficient: You’re not too concerned, and may still promote (maybe).
• Leadership Quality: You may not promote if you agree with the feedback (maybe not).
• Trustworthy: You definitely don’t want to promote (definitely not).

You can program these decisions into the nested IF statement. Place the cursor into the cell where you want the results and type the following formula:

=IF(B2=”YES”,IF(C2=”YES”,IF(D2=”YES”,IF(E2=”YES”,”Definitely”,”Maybe Not”),”Maybe”),”Maybe Not”),”Definitely Not”)

This is a simple nested IF statement that returns “Definitely” if all responses are “YES”, but then returns different answers depending on whether any of the individual cells are “NO”.

This is one of the few examples where a nested IF statement would be a good choice. But as mentioned above, if you need to do anything much more complex, you’re much better off looking for an existing Google Sheets function that accomplishes the same goal much easier. 

Some examples of great advanced “IF” functions include SUMIF, COUNTIFS, SUMIFS, and AVERAGEIFS.

Related posts

• Sida loo soo dejiyo Google Chrome Offline (Standalone) Rakibaye

• Sida Muusiga loogu daro Google Slides

• Sida Loo Sameeyo Foomka Dukumentiga Google-ka La Buuxin Karo

• Sida loo beddelo midabka asalka ah ee Google Docs

• Sida loo habeeyo oo loo maamulo xasuusiyayaasha Google

• Sida loo furo HTML File Google Chrome

• Sida loo hagaajiyo Discover Google oo aan ku shaqayn Android

• 5 siyaabood oo aad Google Calendar ugu heli karto Desktop-kaaga

• Sida Loo Damiyo OK Google-ka Aaladaada Android

• Sida WhatsApp Loo Soo Celiyo Google Drive

• Sida loo isticmaalo Google Jamboard App-ka

• Sida Fiidiyowga Loogu Geli karo Slides Google

• U kala qaybso dukumeenti ku jira Google Docs

• Sida Loo Hawl-geliyo Maareeyaha Xisaabaadka Google-ka ee aan Firfircoonayn

• Sida Loo Isticmaalo Aaladaha Raadinta Sawirka ee Awoodda leh ee laga Heli karo Sawirrada Google-ka

• Sida Loo Isticmaalo Kaabaynta Google Iyo Isku-xidhka Si Aad Hard Drive-kaaga U Samayso

• Sida loo tirtiro Taariikhdaada Raadinta Google - Hagaha Casriga ah

• Sida loo beddelo Margins gudaha Google Docs

• Sida loo hagaajiyo Google Drive-ka "soo dejinta kootada waa la dhaafey" Khalad

• Sida loogu daro faylalka GPX Khariidadaha Google-ka