Excel Common Formula error code "#VALUE"

Common Cause: If the formula returns an error value of "#VALUE", this is often due to a number of reasons: text-type data is involved in numeric operations, the value type of the function parameter is incorrect; the function argument should be a single value, but it provides an area as an argument; forget to press CTRL + When you enter an array formula Shift+enter key.

How to: Correct the relevant data type or parameter types, provide the correct parameters, and remember to use the Ctrl+shift+enter key to determine when you enter an array formula.

Concrete Example: as shown in Figure 15, the "A2" in cell is a type of text, if the formula "=a2*2" is entered in the B2, the text is involved in the numerical operation, so the error occurs. The correct method is to change the text to a numeric value.

In Figure 16, the formula "=sqrt (A5:A7)" is entered in A8, and for function SQRT, its arguments must be a single argument and cannot be an area, so an error occurs. The correct method is to modify the parameter to a single parameter.

As shown in Figure 17, if you want to use an array formula to find the total value directly, you can enter the formula "{=sum (C3:c7*d3:d7)}" in cell E8, noting that the curly braces are not entered manually, but when the Ctrl+shift+enter key is pressed when the input is complete, automatically added by Excel. If you enter and then use the ENTER key to determine, a "#VALUE" error occurs.

The modified method is: When the E8 cell is selected to activate the formula bar, press the Ctrl+shift+enter key, and you can see that Excel automatically adds curly braces (Figure 18).