Tips for using double quotes in Excel

Tips for using double quotes in Excel

If there is nothing in the cell, the operation can not be no matter without asking, you need to use "" to represent "empty" to participate in the operation. For example, the first column in the following table contains spaces in the original data, and the second column evaluates to 5 times times the number of the first column, which is required to be considered in bulk automatic calculation. Enter the following formula in cell B2:

=if (a2= "", "" ", a2*5)

After the Drop-down B2 fills the B column, the value of the space is naturally computed as a null value. However, if null values are not judged, the automatic calculation process can be faulted.

Formula Explanation: If the value of the A1 is blank, the blank is displayed or the a2*5 is returned

Text needs to be quoted

If the contents of the cell being manipulated in the operation are text, you need to represent the text with a "string", and double quotes are required on both sides of the text in the formula. For example, to count the number of "ABC" in column A in the following table, you need to use the following formula:

=countif (a:a, "ABC")

The ABC, if not quoted, will make an error.

Quote for statistic Date

Use date to indicate text-type dates, and to count the number of dates to appear, you also need to enclose quotes. For example, to count the number of 2016-11-25 this date in column A of the following table, use the following formula:

=countif (a:a, "2016-11-25")

If you do not use double quotes, the result will be 0, it is a big mistake!

The use of quotation marks will not be a problem, but should not be used, but also to the problem. Take a look at the following two examples.

Cell references cannot be quoted

The following table counts the number of columns in column B that are greater than A2 cell values. The following formula is needed:

=countif (b:b, ">" &A2)

Here we see that A2 cell references do not use double quotes, but the greater-than > double quotes are added. What happens if you add double quotes to A2, or remove double quotes from the greater-than number? You can try it yourself! The result must be wrong!

Reference name cannot be double quotes

If we define the name "WANG" for a range of cells (such as B2 to the B14 region), the reference to the area in the calculation cannot be quoted, and an error is added. For example: Count the number of occurrences of 131 in this area. Use the formula:

=countif (WANG, "131")

If you use the following formula instead:

=countif ("WANG", "131")

It feels like it should be right, but it turns out to be wrong.