Scribd
Upload
35 views2 pages

Using the IF Function in Excel

The document provides a step-by-step guide on how to insert and use the IF function in Microsoft Excel. It outlines the necessary steps to access the function, input logical test arguments, and the expected outcomes based on the evaluation. The IF function is used to return specific values based on whether a logical condition is true or false.

Uploaded by

ما قلّ ودلّ
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
35 views2 pages

Using the IF Function in Excel

The document provides a step-by-step guide on how to insert and use the IF function in Microsoft Excel. It outlines the necessary steps to access the function, input logical test arguments, and the expected outcomes based on the evaluation. The IF function is used to return specific values based on whether a logical condition is true or false.

Uploaded by

ما قلّ ودلّ
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Name: Ethar Tarek Saad EL-Hag

How to use the IF Function in Microsoft Excel

Insert an IF Function
1. Click where you want to add the function.

2. Click the Formula tab.


3. Click the Logical button.
4. Select IF.

5. Enter the IF function arguments:

• Logical Test: Any value or expression that can be


evaluated to TRUE or FALSE.
• Value If True: The value that is returned if Logical_test
is TRUE. If omitted, TRUE is returned.
• Value If False: The value that is returned if Logical_test
is FALSE. If omitted, FALSE is returned.
6. Click OK when you're finished.

The IF function calculates and returns a value based on the


evaluation of the logical test.

You might also like