Shulou(Shulou.com)06/02 Report--

This article introduces you how to say that you want to judge more than one interval in Excel. The content is very detailed. Interested friends can use it for reference. I hope it will be helpful to you.

= 100, grade "A".

Let's briefly summarize the common solutions and ideas.

1. IF function = IF (A1 > = 100, "A", IF (A1 > = 90, "B", IF (A1 > = 80, "C", IF (A1 > = 70, "D", IF (A1 > = 60, "E", "F"))

Through the nesting of IF functions, the interval of A1 values is judged layer by layer like peeling onions, and the corresponding results are returned.

Greater than or equal to 100, return "A", greater than or equal to 90, return "B", greater than or equal to 80, return "C" …...

The advantage of this formula is that it is easy to understand, but the disadvantage is that if there are multiple judgment conditions, the formula will become longer and longer.

There is another problem. When using the IF function to judge multiple intervals, friends can remember a trick, that is, they can start from the highest part of the rule and judge down step by step. You can also start with the lowest part of the rule and judge up step by step. Just now this formula can be written as follows:

= IF (A1

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.