How to solve the problem of displaying value in excel

Excel displays Value! in one or more cells of a worksheetMistake.

There are several reasons: 1. When a numeric or logical value is required, text is entered.

2. When entering or array formulas, press the Enter key.

3. Input cell references, formulas, or functions as array constants.

4. For regions or functions that only require a single parameter, enter a region value.

The workaround is to keep the data types entered consistent.

Mastering this skill, the excel level instantly increases.

Friends who have used Excel must have seen "value!".This is due to some kind of error, and this kind of error is also very common, and it is even more frustrating that it is difficult to find the exact cause.

Today I'm going to share it: excel cells appear "value!"."Error FAQ and solutions.

Non-numerical values participate in the operation.

In the case of data in Excel cells, if the type is inconsistent, participating in the operation will cause the error to appear.

For example, if the data type in cells A1 and B1 is numerical, while the data in cell C1 is textual, if the three are summed, value!because text and values can't be added at all.

Solution] Check whether the data region in the formula contains cells with text in detail, and delete them to solve the problem.

The syntax and parameters of the function are incorrect.

Excel's function formulas have strict syntax and argument rules, and if you accidentally get the rules wrong while writing, even if it's a comma, the error will occur.

For example, if you want the sum of a2 and b2, if you write =sum(a1 b1), you violate its rules, of course, it is wrong, as shown in the figure below.

Solution] Check the grammar rules of the written function formula in detail, whether there are missing parameters, and see if you have written a formula that we think meets the thinking habits but does not conform to the excel writing standard.

When writing an array formula, I forgot to press CTRL+SHIFT+ENTER

In excel formulas, if a formula contains a result of returning a set of numbers, you need to use the array operation method, if you forget to press the three key combinations of Ctrl+Shift+Enter when you finish writing, this error will appear.

For example, the following ** asks each number in column A to be multiplied by the result of b1.

Think about it, is there a lot of data? This is where the array comes in, i.e. =a1:a10*b1, and the result is to return a set of multiplicative values respectively, which is displayed as an error value because the cell cannot display multiple results at the same time.

The parameter in the formula is incorrect.

Modify the formula.

If the value appears in Excel, it is caused by a format error, and the solution is as follows.

1. First of all, open an excel** in the computer, click to select a column of data containing value, as shown in the figure below.

2. Then press Ctrl+G to bring up the positioning dialog box, and select the error, as shown in the figure below.

3. Then click OK to select the value value, as shown in the following figure.

4. Finally, press the delete key, as shown in the figure below, the value value in ** has been canceled.

When the wrong parameter or operator type is used, or when the formula autocorrect function fails to correct the formula, an error value of value!

Excel version reference: 2010

There are three reasons why this can happen:

1. Text is entered when a number or logical value is required, and excel cannot convert the text to the correct data type.

Workaround: Confirm that the operator or argument required by the formula or function is correct and that the cell referenced by the formula contains valid numeric values. For example:

If cell A1 contains a number and cell A2 contains text, then the formula ="a1+a2"The error value value!, is returned. These two values can be added using the sum worksheet function (the sum function ignores the text): =sum(a1:

a2）。2. Input cell references, formulas, or functions as array constants.

Workaround: Confirm that the array constant is not a cell reference, formula, or function.

3. Give an area of values to operators or functions that require a single value.

Workaround: Change the numeric region to a single numeric value. Modify the numeric region to include the row or column of data in which the formula is located.

You're talking about value!Wrong value, right? There are many reasons for this, and you can use the iserror function to determine whether there is an error, and then use the if function to deal with it.

The problem of value value often occurs after entering a good function formula in excel, how to solve the problem of value value when entering a good formula? The next is the solution to the value of the excel function formula that I bring to you for your reference.

excel function formula appears value solution:

The value solution step 2: Next we enter ::in the cell to the right of the "Total" cell

sum(b2+b3+b4+b5+b6+b7+b8)

Value Solution Step 3: Press the Enter key to confirm the input after the input is completed, and find that the cell displays: "Value!". ”

This is an error prompt in excel.

Step 4 of the value solution: Are we using the wrong summation formula? Next, change the summation formula input method.

The value that appears in Step 5: Will just be in the formula"b2+b3+b4+b5+b6+b7+b8"Replace with cell range representation: b2:b8

The value appears in Step 6: You can also place the value in the formula"b2+b3+b4+b5+b6+b7+b8"Delete, and then drag the region involved in the calculation with the mouse to select, then the formula will automatically recognize the cell range and become b2:b8.

The formula in excel is correct, but the value pro appears! Hello, I'm glad to answer for you<> the formula in pro-excel is correct but the value is as follows: 1. The above error appears in excel exported from the software, which is very simple:

Select the blank box in **, press delete to equalize, when the wrong parameter or operator type is used in excel, or when the formula autocorrect function cannot correct the formula, the wrong value value!. Cause 1 of value error: The value error is displayed because the text type data is used in the formula, and excel cannot convert the text to the correct data type.

Workaround: Confirm that the operator or argument required for the formula or the remainder of the correspondence wheel is correct and that the cell referenced by the formula contains valid numeric values. For example:

If cell A1 contains a number and cell A2 contains the text "Student", then the formula "=A1+A2" can add the two letters with the number of the sum worksheet (the sum function rushes to start the text) will return the wrong value value!. sum(al:a2)value error cause 2:

Putting a cell reference, formula, or function as an array constant produces a value error. Workaround: Confirm that the array constant is not a cell reference, formula, or function.

When performing the array reed roll operation, there is no press"Ctrl+Shift+Enter" and press enter. Cause 3 of value error: Assign a numeric range to an operator or function that requires a single value.

Workaround: Change the numeric region to a single numeric value. Modify the numeric region to include the row or column of data in which the formula is located.

Do you have any other questions?

If the value appears in Excel, it is caused by a formatting error.

After entering good data in excel, statistical data is usually needed, and the most used function in the process of statistics is the function, if the function is accidentally wrong, there will be an error of value, and this error actually has a solution. Here's what I brought about the solution to excel** appear value, welcome to read!

excel** appears value workaround:

Solve the value errorStep 1: Modify the formula in the wrong cell, make sure that the formula or function has the correct necessary operands or parameters, and the cell referenced by the formula is a valid value.

Resolve the value errorStep 2: Change the region reference in the formula to reference a single value.

Solve the value errorStep 3: Modify the parameters in the matrix function to avoid invalid matrices.

Fix the value errorStep 4: Follow the steps below to enter the array formula.

Windows: After the array formula, press CTRL+Shift+Enter to confirm the input of the formula.

Solving the value errorStep 5: Array constants cannot contain cell references, formula functions, special dollar signs $, parentheses () and percent signs.

Reason 6: Use the plus operator to connect two disjoint cell regions.