Ujeedada shaqada IF ee ^(IF)Microsoft Excel waa in la tijaabiyo xaalad haddii ay run^(TRUE) tahay iyo qiime kale haddii xaaladdu tahay BEEN^(FALSE) . Shaqada IF waa mid ka mid ah shaqooyinka ^(IF)Excel ee ugu caansan waxayna bixisaa feker macquul ah oo ku jira heer sare.

Shaqada IF Syntax:^{(The IF function Syntax:)}

• imtixaan macquul ah:^{(logical test: )} Xaaladda aad rabto inaad tijaabiso. Waa loo baahan yahay.
• value_if_true: Soo celi qiimaha aad rabto; haddii natiijada logical_test ay tahay RUN^(TRUE) , waa loo baahan yahay.
• value_if_false : Soo celi qiimaha aad rabto haddii natiijada imtixaanka macquulka ah ay been^(False) tahay . Waa ikhtiyaari.

Maqaalkan, waxaan ku sharxi doonaa shaqada IF^{(IF Function)} ee Excel .

Isticmaalka shaqada IF ee Excel

Tusaalahan, waxaan u adeegsan doonaa miis ay ku jiraan calaamadaha imtixaanada ardayda. Waxaan rabnaa inaan isticmaalno bayaanka IF si aan u go'aamino cidda gudubta iyo kan ku guuldareysta.

Waxaan dooneynaa inaan riixno unugga meesha aan rabno natiijada. Tusaalahan, waxaanu gujin doonaa unugga ka hooseeya tiirka baska oo aan guuldarraysano.

Unugga dhexdiisa, ku qor =IF(B5>50,” Fail”, “Pass”) kaas oo B5>50 uu yahay imtixaan macquul ah^{(logical­_ test)} , " Fail" waa ^{(Fail” is)} value_if_true iyo " Gudub"^(Pass”) waa qiimo_If_false^{(value_If_false)} . Riix

Riix Gelida^{(Press Enter)} waxaad arki doontaa natiijadaada.

Uma baahnid inaad ku celiso qiimihii unugyo kale si aad natiijo u hesho. Waxaad riixi kartaa unugga natiijada, halkaas oo aad ku aragto sanduuq yar oo ku yaal dhamaadka unugga, qaado calaamaddaada oo jiid hoos. Waxaad arki doontaa natiijada unugyada kale.

Xulashada kale waa inaad gujiso tab Formulas .

Kooxda Maktabada Function^{(Function Library)} , dhagsii aaladda macquulka^{(Logical )} ah. Qalabka macquulka^(Logical) ah wuxuu ku darayaa Function macquul ah maktabadaada. Liiska hoos-u-dhaca, dooro shaqada IF . Sanduuqa wada hadalka doodda Function^{(Function Argument)} ayaa soo bixi doona.

In sanduuqa doodda shaqada ee shaqada ,^{(Argument Dialog Box)} ku qor B5<54 ee sanduuqa gelida log_test^{(logical_test)} , ka dibna ku qor " Fail" ee value_if_true sanduuqa gelitaanka iyo Nooca "Pass" ee qiimaha_If_false^{(value_If_false)} sanduuqa gelitaanka. Kadib taabo OK.

Waxaad arki doontaa natiijada.

How to use the IF Function in Excel

The IF function purpose in Microsoft Excel is to test for a condition if TRUE and another value if the condition is FALSE. The IF function is one of the most popular Excel functions and provides logical thinking in excel.

The IF function Syntax:

• logical test: The condition you want to test. It is required.
• value_if_true: Return the value you want; if the result of logical_test is TRUE, it is required.
• value_if_false: Return the value that you want if the result of logical_test is False. It is optional.

In this article, we will explain the IF Function in Excel.

Using the IF Function in Excel

In this example, we are going to use a table containing the test marks of students. We want to use the IF statement to determine who passes and who fails.

We are going to click the cell where we want the result. In this example, we are going to click the cell under the pass and fail column.

In the cell, type =IF(B5>50,” Fail”, “Pass”) in which B5>50 is a logical­_ test, “Fail” is value_if_true and “Pass” is value_If_false. Press

Press Enter you will see your result.

You do not have to retype the value into other cells to get a result. You can click on the cell with the result, where you see a small box at the end of the cell, take your cursor and drag it down. You will see the result of the other cells.

The other option is to click on the Formulas tab.

In the Function Library group, click the Logical tool. The Logical tool adds a Logical Function to your library. In the drop-down menu, select the IF function. A Function Argument dialog box will appear.

In the function Argument Dialog Box, type B5<54 in the logical_test entry box, then type “Fail” in the value_if_true entry box and Type “Pass” in the value_If_false entry box. Then press OK.

You will see the result.

Related posts

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Sida loo isticmaalo Rept Function gudaha Excel

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel

• Sida loo isticmaalo RANDBETWEEN Function gudaha Excel

• Sida loo isticmaalo shaqada TYPE ee Excel

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Sida loo isticmaalo shaqada COOSE ee Excel

• Sida loo beddelo qaabka faylka caadiga ah ee lagu kaydiyo Word, Excel, PowerPoint

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

• Sida Loo Isticmaalo Shaqada PMT ee Excel

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel

• Sida waqti loogu daro ama loogu daro Microsoft Excel

• Sida loo isticmaalo shaqada DISC gudaha Excel

• Sida loo isticmaalo shaqada DGET gudaha Excel

• 2 siyaabood oo loo Isticmaalo Shaqada Transpose ee Excel

• Sida loo qaybiyo hal tiir oo loo kala qaybiyo tiirar badan oo Excel ah

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Sida loo isticmaalo INT iyo Functions LCM gudaha Excel

• Sida loo beddelo midabka warqadda shaqada ee Excel

• Sida loo isticmaalo Percentile.Exc function gudaha Excel