Xaashiyaha Google^{(Google Sheets)} waxaa loo yaqaanaa inay tahay meel dhexe oo lagu dejiyo xogtaada. Waa waxa ay dadku u isticmaalaan si ay ula socdaan dhaqaalahooda gaarka ah oo ay xitaa ku yimaadaan ujeedooyin dhowr ah oo xirfadeed. Qayb naadir ah oo la isticmaalo oo ka mid ah xaashida Google^{(Google Sheets)} -ka waa liiskeeda baaxadda leh ee shaqooyinka naga caawiya kala saaridda xogtayada oo aan ka soo saarno gabagabada, inta badan waxa lagu xalliyo barnaamijka. Mid ka mid ah sifooyinka ugu caansan ee lagu isticmaalo luuqad kasta oo barnaamij ah ayaa ah qoraalka IF, taasina waa wax lagu soo celin karo Google Sheets . Maqaalkan, waxaan ku tusi doonaa sida aad u isticmaali karto hawlwadeenada IF iyo Nsted IF^{(Nested IF)} ka shaqeeya Google Sheets.

Hawlwadeenka IF sidoo kale waxaa laga helaa MS Excel wuxuuna u shaqeeyaa si la mid ah; shaqada waxa aad gelisaa unug oo ku salaysan shuruudo gaar ah oo waxa aad helaysaa wax soo saar ku xidhan in shuruudahaas lagu qancay iyo in kale. Markaad buul ka dhigto bayaanka IF, waxaa laguu oggol yahay inaad samayso falanqayn aad u horumarsan oo kakan.

Waa kuwan soo koobid degdeg ah oo ku saabsan dhammaan waxa aan ku soo qaadan doono maqaalkan:

• Sida loo isticmaalo bayaanka IF ee ku jira Google Sheets ?
• Sida loo isticmaalo bayaanka buulka leh IF ee ku jira Google Sheets ?
• Sidee loo iftiimiyaa safka iyadoo la isticmaalayo habayn shuruudaysan?
• Sida loo dejiyo shuruuc badan oo qaabaynta shuruuda ku jira Google Sheets ?

Sida loo isticmaalo bayaanka IF ee ku jira Google Sheets ?

Kahor intaanan bilaabin habka, aan marka hore u sharaxo waxa ay tahay in bayaanka HADDII uu sameeyo. Ka soo qaad in unuggu leeyahay qiime = 200. Unugyada kale qaarkood, waxaan ku dabaqeynaa qoraalka IF halkaasoo qiimaha unuggaasi uu ku xiran yahay qiimaha unugga lagu qiimeeyo 200. Haddaba, haddii unugga lagu qiimeeyo 100, waxaa laga yaabaa inaan soo celinno qiimee 'HAA', iyo 'MAYA' haddii kale. Tani waa sida uu u eg yahay hawlwadeenka macquulka ah:

= HADDII (macnaha_expression, value_if_run, value_if_false)

1. Logical_expression - Tani waa xaaladdeena waxaana lagu matali karaa '=','<','>'
2. value_if_true - Tani waa qiimaha soo baxaya haddii macnaha macquulka ah uu run yahay
3. value_if_false - Tani waa qiimaha soo baxaya haddii macnaha macquulka ah uu been yahay

Haddaba, tusaalaheenna sare, eray-bixinteenu waxay noqonaysaa:

=IF(A1>100,"YES","NO")

Marka aad qorto qoraalka hawlgalka khuseeya, taabo Geli^(Enter) si aad u hesho qiimaha. Google Sheets' smart and dareen UI sidoo kale waxay ku siinaysaa adeeg Autofill ah si shaqadaada looga dhigo mid fudud.

Sida loo isticmaalo bayaanka buulka leh IF ee ku jira Google Sheets ?

Odhaahyada Nsted IF waxay u ekaan karaan kuwo dhib yar marka hore laakiin way fududahay in la fahmo maadaama ay raacaan mabda'a la mid ah sida hadalka caadiga ah ee HADDII. Sida magacu soo jeediyo, shaqada IF ee buul leh waa meesha ay ka jirto shaqada IF gudaha shaqada IF. Aan sharaxo sida kuwani u shaqeeyaan tusaale ahaan. Waxa aanu geli doonaa haddi tibaaxaha hela tirada ugu badan ee saddexda, gacanta ayaanu ku xisaabinay.

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

Aan kuu kala jebiyo ( way ku caawin lahayd haddii aad ka fikiri karto adiga oo maskaxda ku haya qaabka shaqada IF). Marka hore^(First) waa tibaaxda macquulka ah, haddii B2>B3, waxay hubisaa inay ka weyn tahay B4 sidoo kale. Haddii ay tahay, way daabacdaa taas. Haddi B2<B4, waxaanu eegnaa in B4 ka weyn yahay B3 oo aanu daabacno haddi ay taasi run tahay. Haddii B2 aanu ka weynayn B3, bilawga, waxaanu daabacnaa B3.

Si la mid ah, waxaad buul u buuxin kartaa inta ugu badan ee shaqada IF midba midka kale sidaad rabto, in kastoo ay taasi ka dhigi karto bayaan shaqadaada mid aan loo dulqaadan karin. Odhaahyada Nsted HADDII looma baahna haddii aad rabto inaad hesho qiimaha ugu sarreeya maadaama ay jiraan hawlo MAX iyo MIN ah taas, laakiin waxaa jira dhowr ujeeddooyin xirfadeed oo kale oo ay fuliso.

Sidee loo iftiimiyaa safka iyadoo la isticmaalayo habayn shuruudaysan?

Waxaad isticmaali kartaa habayn shuruudaysan si aad u muujiso saf gaar ah oo saf ah oo aad ka dhigto kuwo kala duwan. Waa kan sida:

• Fur Google Sheets oo dooro safafka aad rabto inaad iftiimiso
• Laga soo bilaabo tabs doorasho ee sare, guji Format oo dheeraad ah ka dooro Qaabaynta Shuruuda ah^{(Conditional Formatting)}
• Laga bilaabo hoos-hoos ee oranaya ' Format cells if,' dooro 'Qaabka gaarka ah waa'
• Tiirka 'Value or Formula', u geli qaacidada si waafaqsan oo dhagsii Done

Sida loo dejiyo shuruuc qaabaynta shuruudaha ku jira Google Sheets ?

Qaabeynta^(Formatting) Shuruudaha ah waxay ka caawisaa isticmaalayaasha inay qayb ka mid ah xogtoodu u ekaato mid ka duwan. Xaashiyaha ^(Sheets)Google wuxuu kuu oggolaanayaa inaad wax yar ka sii qaadato heerarka habaynta maadaama aad halkan ku abuuri karto xeerar kuu gaar ah.

• Guji ^(Click)Format > Conditional Formatting ah
• Laga soo bilaabo sanduuqa wada-hadalka ee midigta, dhagsii Xeer kale ku dar^(Add)
• Geli^(Enter) agabka ie, unugyada uu xeerkan cusubi ku dhaqmayo iyo shuruudaha
• Riix La Sameeyay.

Waxaan rajeyneynaa in maqaalkani uu awooday inuu ka dhigo khibradaada xaashiyaha ^(Sheets)Google wax yar fudud!

How to use IF and Nested IF functions in Google Sheets

Google Sheets is known to be a medium for housing your data. It’s what people use to track their personal finances and even comes in handy for several professional purposes. A rarely used portion of Google Sheets is its extensive list of functions that help us assort our data and derive conclusions from it, much of what is solved by programming. One of the most common features used in every programming language is the IF statement, and that is something that can be replicated with Google Sheets. In this article, we will demonstrate how you can use the IF and Nested IF operators on Google Sheets.

The IF operator is also found in MS Excel and works similarly; you enter the function in a cell and based on certain conditions and receive an output depending on whether or not those conditions are satisfied. When you nest an IF statement, you’re allowed to make more advanced and complex analyses.

Here’s a quick summary of all that we will be covering in this article:

• How to use the IF statement in Google Sheets?
• How to use the nested IF statement in Google Sheets?
• How to highlight a row using conditional formatting?
• How to set up multiple conditional formatting rules in Google Sheets?

How to use the IF statement in Google Sheets?

Before we begin with the process, let me first explain exactly what it is that an IF statement does. Suppose a cell has a value = 200. In some other cells, we apply the IF statement where the value of that cell is dependent upon the value of the cell valued 200. So, if the cell is valued above 100, we may return the value ‘YES’, and ‘NO’ if not. This is what the logical operator looks like:

=IF(logical_expression, value_if_true, value_if_false)

1. Logical_expression – This is our condition and can be represented by ‘=’,’<’,’>’
2. value_if_true – This is the value that comes out if the logical_expression is true
3. value_if_false – This is the value that comes out if the logical_expression is false

So, in our example above, our syntax would be:

=IF(A1>100,"YES","NO")

Once you’ve typed out the relevant operation statement, press Enter to get the value. Google Sheets’ smart and intuitive UI also provides an Autofill service to make your work easier.

How to use the nested IF statement in Google Sheets?

Nested IF statements may seem a little complicated at first but they’re easy to comprehend since they follow the same principle as an ordinary IF statement. As the name suggests, a nested IF function is where there is an IF function inside an IF function. Let me explain how these work with an example. We’ll enter a nested IF expression that finds the biggest number out of the three, we have manually imputed.

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

Let me break it down for you (it would be helpful if you could think of it while keeping the IF function template in mind). First is the logical expression, if B2>B3, it checks if it is greater than B4 as well. If it is, it prints that. If B2<B4, we check if B4 is bigger than B3 and print it if that’s true. If B2 isn’t greater than B3, to begin with, we print B3.

Similarly, you can nest as many IF functions into one another as you want, though that would make your function statement unbearably large. Nested IF statements are needless if you want to find the highest value since there are MAX and MIN functions for that, but there are several other professional purposes that it fulfills.

How to highlight a row using conditional formatting?

You can use conditional formatting to highlight a particular set of selected rows and make them distinctive. Here’s how:

• Open Google Sheets and select the rows you want to highlight
• From the option tabs on top, click on Format and further select Conditional Formatting
• From the drop-down that says ‘Format cells if,’ select ‘Custom Formula is’
• In the ‘Value or Formula’ column, enter the formula accordingly and click on Done

How to set up conditional formatting rules in Google Sheets?

Conditional Formatting helps users make a part of their data look different. Google Sheets allows you to take the levels of customization a bit further as you can create your own formatting rules here.

• Click on Format > Conditional Formatting
• From the dialog box to your right, click on Add another rule
• Enter the inputs i.e., cells on which this new rule would apply and the conditions
• Press Done.

We hope that this article was able to make your Google Sheets experience a little easier!

Related posts

• Sida qoraalka loogu beddelo abka shabakadda Google Sheets

• Sida loo sameeyo Koofida Dhibcaha ee Google Docs dhowr daqiiqo gudahood

• Hagaaji Google Docs Spellcheck oo aan si sax ah u shaqayn

• Sida loo geliyo sanduuqa qoraalka gudaha Google Docs

• Sida loo sameeyo Google Slides loop iyada oo aan la daabicin

• Sida loo geliyo Shaxda Tusmada Google Docs

• Sida loo soo dejiyo oo loo kaydiyo Sawirrada Google Docs

• Sida loo abuuro Indent Hang ee Microsoft Word iyo Google Docs

• Wax-ku-darka Google Docs-ka ugu fiican ee qorayaasha madax-bannaan

• Sida looga saaro Gridlines dukumeenti xaashida Google

• Sida had iyo jeer loogu muujiyo tirinta kelmadda Google Docs

• Sida Loo Isticmaalo Qaabka Bilaashka Ah ee Kala-reebista ee Google Docs iyo Google Slides

• Sida loogu daro Caption Sawirada Google Docs

• Sida loogu daro tixraacyada iyo tixraacyada Google Docs

• Sida lakabka iyo kooxaynta Sawirada Google Docs

• Cilad browserka ayaa ka dhacday fariin - Google Docs on Chrome

• Sida loo sameeyo tiirar Google Docs ah

• Sida Font loogu daro Google Docs

• Sida loogu daro Google Keep Notes Google Docs

• Sida PDF loogu tafatiro Google Docs ee shabakada