Shulou(Shulou.com)11/24 Report--

The original title: "take notes!" This is how the IF function in Excel is used. That's great! "

Hello, everyone, Hi~. I'm here to share the practical knowledge of Excel with you.

It's time for the first phase of [0 basic Excel function] again.

Today we learn a very useful logic function-the IF function.

1. The main function of knowing the IF function is to help you make logical judgments.

To make good use of it, you only need to remember three tips:

What are the conditions for judgment?

What does the result of meeting the condition show?

What does the result that does not meet the condition show?

Let's take a look at the use of the IF function:

= IF (judgment condition, the value returned when the judgment condition is satisfied, and the value returned by the judgment condition is not satisfied)

2. For the judgment of single condition, let's first look at case 1.

Here is a report card. A score less than 60 indicates failure, and a score greater than or equal to 60 indicates qualification. What should I do if I want to use the IF function to automatically calculate the judgment?

❶ input = IF function, with parentheses "()".

❷ recalls 3 sentences of formula and completes the corresponding operation according to the formula.

What are the conditions for judgment? Judge [result] according to [score].

Directly select the [B2 cell] of the score column with the mouse, and then enter [

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.