How to use Logical Function of Microsoft Excel Worksheets

MS-Excel
Microsoft Office Excel widely uses in our community. It is a common use as a simulation of spreadsheets paper. This is a part of automation in our office works as widely use in the calculation. There are hundreds of formulas built-in in this program to meet our needs in our worksheets of data, from simple to more complex application of a formula such as the logical. This is common to the programming platform of computer from basics to advance such as the coding of the database.


Logical function is a form of different conditions itself to meet an exact decision of data without changing its reference data in a worksheet. It can decides even it is hundreds of range of data in a single worksheet using the autofill. It can decides even nested in different logical operators both addition, subtraction, division, and multiplication.

Now this post will help you learn what is the IF function of the Microsoft Excel using even it is Excel 97, 2003, or 2007 buildup and even using the other Office Application such as Open Office and Star Office. Or else using the cloud application of both the Google Drive spreadsheets and the Skydrive application of the Microsoft Outlook.com of the MSN.

According of the Microsoft Office, IF means; “returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE. Use IF to conduct conditional tests on values and formulas.”

Syntax IF (logical_test, value_if_true, value_if_false) Logical_test is any value or expression that can be evaluated to TRUE or FALSE. For example, A10=100 is a logical expression; if the value in cell A10 is equal to 100, the expression evaluates to TRUE. Otherwise, the expression evaluates to FALSE. This argument can use any comparison calculation operator. Value_if_true is the value that is returned if logical_test is TRUE. For example, if this argument is the text string "Within budget" and the logical_test argument evaluates to TRUE, then the IF function displays the text "Within budget". If logical_test is TRUE and value_if_true is blank, this argument returns 0 (zero). To display the word TRUE, use the logical value TRUE for this argument. Value_if_true can be another formula.

Value_if_false   is the value that is returned if logical_test is FALSE. For example, if this argument is the text string "Over budget" and the logical_test argument evaluates to FALSE, then the IF function displays the text "Over budget". If logical_test is FALSE and value_if_false is omitted, (that is, after value_if_true, there is no comma), then the logical value FALSE is returned. If logical_test is FALSE and value_if_false is blank (that is, after value_if_true, there is a comma followed by the closing parenthesis), then the value 0 (zero) is returned. Value_if_false can be another formula. The above STATEMENT can be understood in the following example, using the IF function: The final grades of the students set as example table below:

A
B
C
D
E
1
Name of Students
Prelim
Midterm
Final Average
Remarks
2
Juan Juan 70 70 70 failed
3
Pedro C. Pedro 90 99 94.5 passed
 
The syntax above states that IF (logical_test, value_if_true, value_if_false), now basing the worksheet table the remarks are only passed or failed. Combining the logical as stated I use the logical by writing it in the worksheet as follows; =if (d2>75,”passed”,”failed”) now it is understood that =if is a logical function, d2 is a logical reference or reference data, greater than 75 is a logical test, and both using the double quotation the passed and failed is the logical condition that will base of the data reference and will depend of the logical test you provided.
See the image shown above.


A lot of examples will follow such as using the multiple IF function of the Microsoft Excel, it will help you to decide a hundreds of data using the remarks of your worksheets in different categories such as using the is greater than or equal to the principle. Just follow always this post, “End”

How to use Logical Function of Microsoft Excel Worksheets Arnel Cartoneros 5 of 5
Microsoft Office Excel widely uses in our community. It is a common use as a simulation of spreadsheets paper. This is a part of automa...
Share on Google Plus

About Arnel Cartoneros

Arnel is a Blog creator and writer, A founder and publisher of www.combinebasic.com and www.nuggetro.info. Part time Computer Instructor, Computer And Electronic Technician, And performing job as Biomedical Machine Specialist. I'm an avid fan of social media and very interested in Technical information and innovation.