Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account


The magical use of the minus sign of arithmetic in Excel

2024-03-04 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > IT Information >


Shulou( Report--

Hello everyone, I am trying to use the most simple language to introduce Excel knowledge satellite sauce!

The operator minus sign (-) should be familiar to everyone, right?

In Excel, it has many magical uses besides subtraction.

Curious friends, come and see!

1. Text format digital summation Text type numbers cannot participate in the calculation. What can I do?

Alas, all blame oneself at the beginning for record convenience, all use text format, how can be good now?

Look at this piece of green hat, it's really a headache…

It's time for double minus!

As long as you add a double minus sign "--" before the selection, as shown in the figure below, you can operate normally.

(Except for Office 365, remember to press Ctrl+Shift+Enter to end the other versions!)

2, logical value conversion to the following table, to count the number of "qualified" assessment, in addition to COUNTIF count, what other way?

You can use a double minus sign with SUMPRODUCT or SUM function!

Here we use product function to do demonstration!

Input formula:

=SUMPRODUCT (--(C2:C21="Pass"))

Amazing, so we get more flexible counting formulas, and one step closer to becoming an Excel master ~

If you want to have a solid grasp of Excel knowledge, you still have to attend classes and systematically understand tables!

After all, only when you know the principle can you use it flexibly ~

Hmm... So what's the counting principle here?

Well, no suspense ~ In fact, the double minus sign converts the logical value into 0 and 1, which can be calculated naturally when it becomes a numerical value.

We know that the TEXT function can convert numbers to text format.

Although this is visually more beautiful, the resulting results cannot participate in the calculation.

But just add "--" to the formula, like this:

Then set the cell format to date, you can both read and calculate it!

4. VLOOKUP looks for the same principle. When the search value is in text format, it will return an error value:

Then use the double minus sign to turn it into a numerical value and look it up again!

5. In the end, it seems that the double minus sign and many functions are in tacit agreement!

SUM Text Sum


TEXT Text to Value

VLOOKUP text-based numeric lookup

The ability to convert text and logical values into numerical values helped a lot.

Well, if you think this article is helpful, click on it and watch it. Support Wei!

However, is there a small partner who sums up the rule of adding double minus positions?

When do I add it to the front of the function and when do I add it to the middle of the formula?

Then again, at first it was said to introduce the use of minus signs, but this article only talked about double minus signs ~

In fact, a minus sign alone has wonderful uses other than subtraction. Does anyone want to know?

This article comes from Weixin Official Accounts: Autumn Leaf Excel (ID: excel100), Author: Satellite Sauce

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

IT Information


© 2024 SLNews company. All rights reserved.