After input formula in the Excel, and cannot be correctly calculated results, and display an error message within the cell, the production of these errors, have a plenty of because of the formula itself, some not,
Input to the data in a cell is too long or the effects of the cell formula is too large, the result is shown in the cell, or the date and time format cells do subtraction, appeared a negative value, how to deal with?

CodePudding user response:

Decimal digits after too much or cell format is wrong, according to the requirement and the actual situation to set down a try,

CodePudding user response:

The cell format is wrong, adjust the cell format

CodePudding user response:

May be the format of the cell is not allowed according to the results

CodePudding user response:

Outside of the calculation results, then use the excel function to handle, the filter is invalid data