According to your description, I can provide the following suggestions: First, you should check whether the auto complete function is set in Excel.If the auto complete function is enabled, the formula may not display normally.In addition, you can try refreshing the cell or re opening the Excel file to solve the problem.If none of the above methods works, you can also consider contacting the official technical support of Excel for help.They will provide more professional guidance and solutions.
It is possible that your formula is copied, and the original cell setting is text format Also, you have not turned on automatic recalculation in the option ->formula
After looking at other methods, my situation is not "[Data - Sorting - Completion]" as mentioned in the above comment. I set it like this in "Tools" (in WPS, it is "File") - "Options" - "Recalculate" - "Auto Recalculate"..