In this lesson, we will learn how to use the “if” function and everything related to it in Excel.
Suppose we have the following spreadsheet.
Suppose I want to test a specific condition, we assume that the condition is that Excel prints the word “True” if the profit is greater than 2000, and prints “False” if the profit is less than 2000.
To do this process, we have the following steps:
• First, we select the cell in which we will put the result.
• Second, we write the “=” sign in this cell.
• After that, we write the function for the condition operation “If”.
• Then we select the cell in which we will compare (in our example, it is the profit).
• After that, we open a bracket and write the condition (I7>=2000).
• We must also put a comma and what will appear if the condition is met (in our example, “true”).
• Then we must put a comma and what will appear if the condition is not met (in our example “False”) and close the bracket.
• We press Enter.
To apply the operation to all cells, we select the result cell and then drag it down.
Dear reader, if you liked the article, do not forget to subscribe to our YouTube channel, which provides all new in the field of technical and completely free training courses.
You can also browse our website to access the blog and read technical topics, or learn about the training courses offered by the site.
To access the full course “Excel Course” on YouTube, click here.
