Excel waa barnaamij faafin awood leh oo aan ka shakiyo in qof kastaa uu ogaan karo wax kasta oo uu samayn karo. Waxaa jira dhinacyo badan oo barnaamijka ah, waxaa cajiib ah in dhammaan lagu soo koobi karo interface fudud. Waxaan dhawaan u isticmaalayay Excel shaqada qaar ka mid ah guriga oo waxaan is arkay aniga oo isticmaalaya shaqada IF si aan u qoro dhowr qaacido.

Awood u leh inaad ku qorto bayaan fudud HADDII gudaha Excel waa lama huraan, gaar ahaan haddii aad wax ka qabato tiro badan mar kasta. Waa mid ka mid ah waxyaabaha aan aadka u dhibin sida macros, laakiin aan ahayn mid dareen leh sida soo koobidda tiir tirooyin.

HADDII Odhaahyada Excel

Maqaalkan, waxaan kugu dhex mari doonaa qormo gaaban oo ku saabsan qorista bayaan IFKA xaashida shaqada ee Excel . Si aad u bilawdo, waa in aad fahanto sal u ah dhammaan bayaannada HADDII:

IF condition THEN true ELSE false

Taasi waa wax aad u qurux badan. Xaaladdu badanaa waa isbarbardhigga shay. In shay caadi ahaan yahay lambaro ama qoraal. Waxaan ku bilaabi doonaa isbarbardhigga nambarada aasaasiga ah, ka dibna qoraal, ka dibna ku dar hawl wadeenada sida AND/OR , iwm. Haddaba waa kan tusaalaheena koowaad:

Waxaan halkan ku haynaa tusaale aad u fudud. Laba tiir oo leh laba lambar, 25 iyo 35. Haddii Column C , waxaan rabnaa in aan hubinno haddii tiirka A^{(Column A)} uu ka weyn yahay 10, waxaan soo saari doonaa qoraalka Haa^(Yes) , haddii kale qoraalka Maya^(No) . Waxyaabo dhowr ah oo ay tahay in la xuso:

1. Uma baahnid inaad ku dhejiso jaantuska isbarbardhigga dhabta ah, laakiin waa dhaqan aad u wanaagsan, gaar ahaan marka isbarbardhigga uu noqdo mid adag.

2. Si aad u soo saarto qoraalka qiimaha runta ah ama beenta ah, waa inaad isticmaashaa xigashooyin laba jibaaran. Haddii aadan samayn, waxay u malaynaysaa inaad isku dayayso inaad tixraacdo tiro magac leh oo Excel ah .

Hadda aan aragno waxyaabo kale oo aad sameyn karto. Qeybta isbarbardhigga, waxaad sidoo kale sameyn kartaa xisaab. Tusaale ahaan, waxaad samayn kartaa tan haddii aad jeceshahay:

Halkan waxaan ku nidhi haddii qiimaha A2 jeer 10 uu ka weyn yahay 10, ka dibna soo saari Haa^(Yes) , haddii kale wax soo saarka Maya. Pretty si toos ah-hore eh? Hadda aynu nidhaahno waxaan rabnay inaan soo saarno tirooyinka halkii qoraal ahaan. Waa kan hal tusaale:

Tusaalahan, haddii qiimaha A2 uu ka weyn yahay 10, waxay soo saari doontaa qiimaha waqtiyada 2, haddii kale waxay ku dhufan doontaa qiimaha 5. Wax^(Pretty) faa'iido leh, laakiin waxaad helaysaa barta. Waxa kale oo aad isticmaali kartaa qiimaha unugyada kale ee qaacidada.

Halkan waxaan ku sheegaynaa in haddii qiimaha A2 uu ka weyn yahay 10, ka dibna badiyaa B2 by 10, haddii kale B2 badan oo 5 ah oo soo saara qiimahaas unugyada C2. Hadda aynu ka dhigno mid aad u adag. Maxaa dhacaya haddii aan rabno inaan soo saarno Haa^(Yes) haddii labadaba A2 iyo B2 ay ka weyn yihiin 10?

Waar wax cusub! Haddii aan rabno A2 > 10 AND B2 > 10 , markaa waa inaan isticmaalnaa shaqada AND gudaha shaqada IF. Waxay u muuqataa mid adag, laakiin aad uma xun. Shaqada AND asal ahaan waxay qaadataa doodo isbarbardhig oo badan ( A2 > 10 ) waxayna ku sameeysaa iyo^(AND) iyaga. Dhammaantood waa inay run noqdaan si " Haa^(Yes) " loo soo bandhigo. Waxaad ku dari kartaa saddex ama afar ama in ka badan dood is barbar dhig haddii aad rabto. Haddii aad rabto inaad sameyso AMA, si fudud ku beddel iyo kan sare kelmadda AMA .^(AND)

Ka warran haddii aad rabto inaad soo celiso qiime aan ahayn qoraal ama lambar la xisaabiyay. Maxaa dhacaya haddii aad rabto inaad ku soo celiso qiimaha unugga xaashi kale? Hagaag, waxaad samayn kartaa wax sidan oo kale ah:

Qiimaha dhabta ah, waxaan ku soo celin doonaa qiimaha unugga A1 xaashida 2^{(Sheet 2)} . Taasi aad bay u fududahay! Markaa waxaad si fudud uga tixraaci kartaa qiyamka xaashiyaha kale haddii aad rabto. Isla iftiinka, waxaad sidoo kale isticmaali kartaa qiimaha xaashi kale marka la barbardhigo macquulka ah sidoo kale, tusaale ahaan Sheet2!A1 > 10. Aynu eegno waxyaabo badan oo aad sameyn karto! Aynu sheegno inaad rabtay inaad samayso bayaan IF ah oo ku salaysan nooca qiimaha lagu kaydiyay unugga (lambar, qoraal, ama bannaan). Waxaad samayn kartaa wax sidan oo kale ah:

Waxaad u isticmaali kartaa ISTEXT iyo ISNUMBER labada nooc ee kale ee xogta. Hawlahani waxay noqon karaan kuwo ku habboon marka la qorayo hababka IF. Ogsoonow inaad asal ahaan u adeegsan karto inta badan shaqooyinka Excel gudaha bayaan IF, markaa waxaad xor u tahay inaad furto. Tusaale ahaan, waxaad isticmaali kartaa hawlaha sida SUM , MAX , MIN , iwm.

Ilaa hadda waxa aanu ku shaqaynaynay hal qiimo marka la barbardhigo isbarbardhigga macquulka ah, laakiin aynu nidhaahno waxa aanu rabnaa in aanu la shaqayno koox unugyo ah. Tusaale ahaan, haddii dhammaan tirooyinka ku jira kala duwan ee unugyadu ay ka badan yihiin 10, soo saarida Run^(True) , haddii kale Been^(False) .

Way fududahay sida loo isticmaalo xiidanka sida kor ku cad, A2: A4. Xaaladdan oo kale, qiime kasta oo ka bilaabma A2 ilaa A4 waa la tijaabin doonaa si loo eego inay ka weyn tahay 10. Haddii ay dhammaantood yihiin, markaa qiimaha runta ah ayaa la soo bandhigi doonaa. Maxaa ku saabsan bayaannada buulka leh ee HADDII?

Halkan, waxaan sheegayaa in haddii A2 uu ka weyn yahay 10, soo saaro qiime, laakiin haddii kale, ka dibna samee isbarbardhigga IF kale. HADDII B2^{(IF B2)} uu ka weyn yahay 10, markaas soo saar qiime kale. Waxaad buul ku dari kartaa HADDII warbixinada 64 heer qoto dheer, taas oo macnaheedu yahay inaad samayn karto waxyaabo aad u adag. Waxaa laga yaabaa inaadan waligaa u baahnayn inaad fogaato, laakiin mararka qaarkood waxay faa'iido u leedahay heerar yar oo qoto dheer.

Kani waa hordhac aasaasi ah oo keliya ee bayaanka HADDII, laakiin waxaan rajaynaynaa inay ku bilaabi doonto. Ma waxaad isku deyeysaa inaad qorto qoraal IF si aad wax ugu sameyso Excel oo aadan garan karin? Halkan ku dheji faallo dhibaatada oo waxaan isku dayi doonaa inaan kaa caawiyo inaad qorto qaabka saxda ah ee HADDII. Ku raaxayso!

How to Write an IF Formula/Statement in Excel

Excеl is such a powerful spreadsheet program that I doubt anyone can possibly know eνerything that it can do. There are so many aspects to the program, it’s amazing that it can all be encapsulatеd in such a simple interface. I was recently υsіng Excel for some work at home and found myself υsing the IF function to write a fеw formulas.

Being able to write a simple IF statement in Excel is essential, especially if you deal with a lot of numbers all the time. It’s one of those things that’s not too complicated like macros, but not necessarily intuitive like summing up a column of numbers.

IF Statements in Excel

In this article, I’ll walk you through a short primer on writing a IF statement in an Excel worksheet. To get started, you should understand the basis of all IF statements:

IF condition THEN true ELSE false

That’s pretty much it. The condition is usually a comparison of something. That something is normally numbers or text. We’ll start off with some basic number comparisons, then text, then include operators like AND/OR, etc. So here’s our first example:

We have a very simple example here. Two columns with two numbers, 25 and 35. If Column C, we want to check if Column A is greater than 10, we will output the text Yes, otherwise the text No. A few things to note:

1. You don’t have to put a set of parenthesis around the actual comparison, but it’s very good practice, especially when the comparison becomes more complicated.

2. To output text for the true or false value, you have to use double quotes. If you don’t, it will think you are trying to refer to a named range in Excel.

Now let’s see some more stuff you can do. In the comparison section, you can also do math too. For example, you can do this if you like:

Here we are saying that if the value of A2 times 10 is greater than 10, then output Yes, otherwise output No. Pretty straight-forward eh? Now let’s say we wanted to output numbers instead of text. Here’s one example:

In this example, if the value in A2 is greater than 10, it will output the value times 2, otherwise it will multiply the value by 5. Pretty useless, but you get the point. You can also use the value of other cells too in the formula.

Here we are saying that if the value of A2 is greater than 10, then multiple B2 by 10, otherwise multiple B2 by 5 and output that value into cell C2. Now let’s make it more complicated. What if we wanted to output Yes if both A2 and B2 are greater than 10?

Here’s something new! If we want A2 > 10 AND B2 > 10, then we have to use the AND function inside the IF function. Sounds tricky, but not too bad. The AND function basically takes multiple comparison arguments (A2 > 10) and does an AND on them. They all have to be true in order for “Yes” to be displayed. You can add three or four or more comparison arguments if you like. If you want to do an OR, simply replace the AND above with the word OR.

What about if you want to return a value other than text or a calculated number. What if you want to return the value of a cell on a different sheet? Well, you can do something like this:

For the true value, I am going to return the value of cell A1 on Sheet 2. That’s pretty easy! So you can easily reference values from other sheets if you like. In the same light, you can also use a value from another sheet in the logical comparison too, i.e. Sheet2!A1 > 10. Let’s look at more stuff you can do! Let’s say you wanted to do an IF statement based on the type of value stored in a cell (number, text, or blank). You can do something like this:

You can use ISTEXT and ISNUMBER for the other two types of data. These functions can be really convenient when writing IF formulas. Note that you can basically use most functions in Excel inside of a IF statement, so feel free to run loose. For example, you can use functions like SUM, MAX, MIN, etc.

So far we’ve only been working with one value in the logical comparison, but let’s say we want to work with a group of cells. For example, if all the numbers in a range of cells is greater than 10, output True, otherwise False.

It’s as simple as using the colon like shown above, A2:A4. In this case, each value from A2 to A4 will be tested to see if it’s greater than 10. If all of them are, then the true value will be displayed. What about nested IF statements?

Here, I am saying that if A2 is greater than 10, output a value, but if not, then perform another IF comparison. IF B2 is greater than 10, then output a different value. You can nest IF statements 64 levels deep, which means you can do some pretty complicated stuff. You’ll probably never need to go that far, but sometimes it’s useful a few levels deep.

This is only a basic introduction to the IF statement, but hopefully it’ll get you started. Are you trying to write an IF statement to do something in Excel and can’t figure it out? Post a comment here with the problem and I’ll try to help you write the proper IF formula. Enjoy!

Related posts

• Sida loo tirtiro khadadka banaan ee Excel

• Sida loo Isticmaalo Tilmaamaha Unugyada Hadalka ee Excel

• Sida loo Geliyo Xaashida Shaqada ee Excel Word Doc

• Sida loo isticmaalo Excel's What-If Analysis

• Sida Loo Hagaajiyo Safka gudaha Excel

• Sida Loo Sameeyo Liisaska Hoos-u-dhaca ee Isku Xirka Badan ee Excel

• Hagaha VBA Sare ee MS Excel

• Sida loo xisaabiyo Z-Score gudaha Excel

• Adeegsiga Qalab Raadinta Hadafka ee Excel Maxaa-Haddii Falanqaynta

• U isticmaal Magacyada Range Dynamic ee Excel si aad u Dejiso Dabcida

• Sida Loo Raadiyo Excel

• Farqiga u dhexeeya Microsoft Excel Online iyo Excel ee Desktop

• Sida Loo Abuuro VBA Macro Ama Script gudaha Excel

• 4 siyaabood oo loo isticmaalo calaamadda jeeg ee Excel

• Sida Loo Isticmaalo Shaqada PMT ee Excel

• Sida Looga Saaro Safka Kooban Ee Excel

• Safka Kooxda iyo Tiirarka ku jira xaashida shaqada ee Excel

• 10 Talooyin iyo Tabaha Excel ee 2019

• Sida loo Isticmaalo Tixraacyada Absolute ee Excel

• Sida loo Furo Word iyo Excel si Badbaado ah