What is Excel?
Microsoft Excel is a spreadsheet program available in the Microsoft Office Package. MS Excel is used to create Worksheets (spreadsheets) to store and organize data in a table format.
Microsoft Excel is one of the most used software application in the world. Excel have the Powerful Tools and Functions, using it for wide verity of applications across the global IT Companies. It is easy to enter the data, read and manipulate the data. Excel stores the data in a table format in Rows and Columns.
IF Function
The IF function can perform a logical test and return one value for a TRUE result, and another for a FALSE result. For example, to "pass" scores above 70: =IF(A1>70,"Pass","Fail"). More than one condition can be tested by nesting IF functions. The IF function can be combined with logical functions like AND and OR
Syntax:
=IF (Logical_test,value_If_True,vaule_If_False)
Arguments
-Logical_Test: A Value or logical expression that can be evaluated as true or false.
-value_if_true: [option] the value to return when logical_Test evaluates to true.
-value_if_false: [option] the value to return when logical_Test evaluates to false:
Example
=IF(10>20,10,20)
Output
20
Comparsion Operator
| Comparsion | Meaning | Example |
|---|---|---|
| = | Equal to | 4=4 |
| <= | Less than or Equal | 4<=10 |
| < | Less than | 4<10 |
| >= | Greater than or Equal | 20>=20 |
| > | Greater Than | 20>10 |
| <> | Not equal to | 20<>10 |
IF With AND,OR
The IF Function can be combined with the AND function and the or function
Example
=if(average <=5,"F",if(and(Average>5,Average<=6),"E", if(and(Average>6,Average<=7),"D",if(and(Average>7, Average <=8),"C",if(and(Average>8,Average<=9),"B",if(and(Average>9,Average<=10),"A"))))))
Please Watching My Video is Below