A Consider the following MS-EXCEL spreadsheet:

	A	B	C	D	E
1	Day	Weather	Temp	Play Tennis?	Go Running?
2	Monday	Sunny	High
3	Tuesday	Windy	High
4	Wednesday	Raining	Medium
5	Thursday	Sunny	Low
6	Friday	Sunny	Medium

Suppose the formula - IF (B2< > ''Raining", IF(C2 = "High" , "No" , "Yes"), "No") is entered into E2 and then the cell is copied and pasted to E3 : E6, On what days does Column E report "Yes"? 

Note: (The symbol <> represents "NOT EQUAL TO"). 

Key Points

IF Function in Excel:

The IF function is a logical function in Microsoft Excel that allows you to perform a logical test and return one value for a TRUE result and another value for a FALSE result.

The syntax of the IF function is:

=IF(logical_test, [value_if_true], [value_if_false])

• The logical_test argument is the condition that you want to test. It can be a comparison, such as equal to (=), not equal to (<>), greater than (>), less than (<), etc.
• The [value_if_true] argument is the value that Excel returns if the logical_test is TRUE.
• The [value_if_false] argument is the value that Excel returns if the logical_test is FALSE.

Important Points The formula given below is pasted in cell E2-

IF(B2< >''Raining",IF(C2 = "High","No","Yes"),"No")

This formula entered in cell E2 means that IF the value in Cell B2 is not "Raining" and IF the value is cell C2 is not "High", Then display Yes otherwise display No.

After Pasting the formula in Range E3 : E6

Hence, Thursday and Friday only in Column E report "Yes".