Scribd
Upload
59 views2 pages

Using the IF Function in Excel

Uploaded by

Warren Smith
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
59 views2 pages

Using the IF Function in Excel

Uploaded by

Warren Smith
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

IF - Excel Page 1 of 2

IF

Try it!
Use IF to return a value based on a condition.

For example, =IF(C2=”Yes”,1,2) says IF(C2 = Yes, then return a 1, otherwise return a 2).

IF

1. Select a cell.

2. Type =IF and a left parenthesis (.

3. Add the condition you want to test, and type a comma.

[Link] 11/24/2024
IF - Excel Page 2 of 2

4. Add the value to return if the condition is true, and type a comma.

5. Add the value to return if the condition is false, and type a right parenthesis ).

6. Press Enter.

7. If needed, drag the handle to apply the IF function to other rows.

Want more?
IF function

[Link] 11/24/2024

You might also like