When you edit a table in Excel, when you enter a value, some cells appear "#VALUE!" Error prompts.
This situation may be caused by one of the following 4 reasons.
1. The parameter is not set correctly.
2. The operator is not used correctly.
3. After you perform the AutoCorrect command, you cannot correct the error.
4. When you need to enter numbers and logical values in Excel, you enter text. This hint can also occur because Excel cannot convert text to the correct data type. You should confirm that the formula or function requires an operation or a parameter value that is correct, and that a valid number is included in the cell that the formula refers to.