In Excel, value!Errors usually appear in formulas and mainly contain the following three aspects:
, non-numeric cells are used in the operation
If the formula references one or more cells that contain text instead of numbers, and you use the standard number operators (+, and ) to perform addition, subtraction, multiplication, and division operations on different data types, value! is also displayedMistake.
, the formula does not conform to the function syntax
For example, if we want to calculate a1+b1-c1-d1, enter the formula =sum (a1:b1-c1-d1) to get the wrong value value!This is because a1:b1 is a continuous region reference, and when calculating with disjoint cells, you need to add a comma to separate them, and when the formula syntax is incorrect, it will lead to an error value value!At this point, changing it to =sum (a1:b1,-c1-d1) will do the trick.
Don't forget to press the shortcut key when using curly bracesctrl+shift+enter
If you're using an earlier version of Excel, you'll need to cancel the automatic formula calculation and then enter the curly braces manually.
In order to solve the value!Question, you can try the following:
1. Use the if function to determine whether the content in the reference cell is a numeric value, if not, do not calculate.
2. Use the iferror function to shield the error, such as: =iferror(The operation formula,"There is an incorrect input")。In this way, if there is an error, it will show "Input Error".