Excel doesn t show either numbers or formulas after entering the formula

If you are entering a conditional formula, e.g. =if(a1="","",2) When A1 is empty, the cell where the formula is located is empty, neither the formula nor the number is displayed.

The if conditional formula avoids unwanted results because of a need.

See attached drawings for details. <>

There are several possible scenarios that come to mind:

1.You are looking for the sum of decimals, and it is less than 1, at this time, you need to see if the cell where the formula is located is set to the number format, if so, adjust to the numeric format, or the default format;

2.Formula cells may have used a custom format, that is, if your sum poem is 340, but you set the formatting, such as "0," it will still show as 0, because the format requires that it be carried to the thousands, that is, even if it is 12300, it will only show 12, and 9900 will show 10, and 4900 will show 5, and 450 will show 0

3.As for what you said about formatting the text, it may also exist, but basically excel will default to the text input numbers can still be calculated as numbers, if not for the first two reasons, it is recommended that you test it in another cell, whether there is still a problem.

The other reason is that it's not that the font of your cell is set to white, so you can't see it.

Have you solved this problem? How was it solved?

Is it in the wrong format, or incomplete?

You can try to brush the abnormal cell format with the correct display of cells, and then recalculate it.

The result of the formula calculation is empty, so it is not displayed.

You can take a look at the formula.

What does that show? You can set up the cell format and try it.

Excel does not display the calculation result and only displays the formula, the solution is as follows.

1. First open Excel**, enter the data in ** and multiply the calculation, you can see that the calculation formula is displayed at this time, and the calculation result is not displayed.

2. Select the cell of the displayed calculation formula.

3. Then click on the "Formula" option in the toolbar at the top of the page.

4. Find the "Show Formula" option in the "Formula" option box, and you can see that "Show Formula" is selected at this time.

5. Finally, click "Show Formula" once, and you can restore the selected cells to the style displayed by the calculation result.

When you do formula calculation in Excel, sometimes the formula returns "value!"."Wrong value. There are several reasons for this:

1. In the formula, the information of the text type is involved in the numerical operation. Solved: Text was deleted or formatted modified.

2. The functions used in the formula refer to arguments and are inconsistent with the syntax. Solve: Modify the formula.

3. When entering an array formula, forget to press shift+ctrl+enterSolved: Press the key combination to end.

Let's find out why. Good luck!

Tools - Options - View, put the formula options inside

It may be hidden, if the upstairs says that the color does not work, try to enter the custom format in the cell format ";; to delete. This format will prevent the information of the cell from being displayed.

It's your **big enough, the formula is enough, so every time you make some small changes, there are too many formulas, and there are too many ** that need to be recalculated, so there will be regional data updates out of sync, especially those formulas that are more complex in the mutual reference relationship**, and at the same time** in use for a long time, too many modifications will also make the file become inflated, make a new table, selectively paste the content of the original table and copy the formula to the new table, build a new file may be much better, and in addition** will carry out some excellent goods, Reducing complexity can also go a long way.

The emoji of the international standard universal code uses the [Segoe UI Symbol] font file, and if you don't set this font file, it can't be displayed.

Then your cells are formatted as text.

Format a cell as regular, and convert it to a formula automatically after double-clicking the cell.

1.See if the cell is textual. Change to a regular one.

2.Tools-Options-View, Put"Formula"The front hook is removed.

It's out of battery, try replacing the battery.

Check that the battery, transformer, charger are not good, if none of these are available, it is a problem with the motherboard.

There are two reasons why after entering a formula inside an excel cell, only the formula is displayed instead of the result:

1. The cell format is wrong, and the formula must be in regular cell format.

The workaround is:

1) Click on the cell where the formula is located to view the cell format;

2) Change the cell format, change the cell format to regular;

3) Click on the input bar and hit enter;

4) The change is complete.

2. If there is no "=" sign in front of the formula in the cell, the formula is incomplete if the equal sign is not written in front of the formula. The results are also not displayed.

The workaround is:

1) You can see that there is no equal sign.

2) Click the mouse to enter the column and enter "=".

Excel does not display the result after entering the formula, and the direct 0 is caused by the setting error, and the solution is:

1. Open Excel**.

2. After entering the formula in the excel cell, only the formula is displayed but the result is not displayed.

3. Select the cell and right-click.

4. In the pop-up menu, click Format Cells.

5. In the pop-up dialog box, if the cell is classified as text, select the classification as the numeric value and then point to determine.

6. Then after double-clicking on the cell, the result will be displayed.

Summary. Hello dear, happy to answer your <>

There can be several reasons why the results are not showing up after entering the formula in excel, here are some possible solutions:1Check if the formula is entered correctly.

When entering a formula, you may enter the wrong function name, cell reference, operator, etc. Please check that the formula is entered correctly and make sure that it is spelled correctly. 2.

Check the formatting of the cells. If the cells are formatted incorrectly, it may affect the display of the calculation results. Please check if the cell is set to "Text" format, if so, please change it to "General" or "Number" format.

<> why doesn't the result show after Excel input formula?

Hello dear, happy to answer your <>

There can be several reasons why the results are not displayed after entering the formula in excel, and here are some possible solutions for the mountain clan:1Check if the formula is entered correctly.

When entering a formula, you may enter the wrong function name, cell reference, operator, etc. Please check that the formula is entered correctly and make sure that it is spelled correctly. 2.

Check the formatting of the cells. If the cells are formatted incorrectly, the first rise may affect the display of the calculation results. Please check if the cell is set to "Text" format, if so, please change it to "General" or "Number" format.

<> kiss <>

And then there's Oh <>

Flower Limb Picking] 3.Check if the cell is empty. If the cells referenced in the formula are empty, the calculation result will also be empty.

Please confirm whether there is any data or formula in the cell, and try to re-enter the formula. 4.Enable auto-calculate.

In some cases, Excel may turn off the auto-calculate feature, resulting in the formula not calculating the result immediately. Make sure that the auto calculation function is enabled, and try pressing the F9 key to manually refresh the calculation result. 5.

Check if the cell is locked. If the cell is locked, the result will not be displayed when entering the formula. Please open the Format Cells dialog box, uncheck the Protect Cells option, and re-enter the formula.

<> hello dear<>

Sorry <>

Because this is the side of the ** to my side will be compressed, I can't see your ** clearly, so you still have to work hard to explain the situation, so that I can better solve the problem <>of asking the scum Lu for you

<> if you bring a bottle, it won't show the results?

Kiss Zhengmin <>

Not necessarily, bringing a "bottle" may just be a type of cell formatting, regardless of whether the result is displayed or not. If the cell formatting is set to "Text", the calculation result will not be displayed even if the formula is entered. At this point, you can try to change the cell format to "General" or "Number" and then calculate.

If the results are still not displayed, you need to check other possible reasons (such as whether the formula is correct, whether the cell is empty, whether AutoCalculate is enabled, etc.). <

excel display results do not show formulas Hello dear, excel does not display formulas Solution 1: We enter the "number" column of "Start", select "General Options", and then put the cursor in the formula bar shown in the figure, and then press Enter, you can see the calculation resultsExcel** does not display formulas in the second case, excel does not display formulas Solution 2: Enter the "Formula Review" column of "Formula", if "Show Formula" is selected, then uncheck it, If you can't solve it yet, please see the third way excel** does not show the formula third and the case, excel does not show the formula solution 3:

Uncheck "Lock Cell" in "Format" in "Cell" in "Start", or right-click the cell, open "Format Cell", and remove the checkmark before "Protect" and "Hide" in the "Protect" menu.

1. Find the Excel document location on your computer and double-click to open it.

2. Then, in the excel program, I see that the display formula does not display the value, and the selected cell fiber shouts burning.

3. Click the "Text" option at the top of the excel program and click to open.

4. Click "Number" in the drop-down vegetable infiltration car list, and click to open.

5. Finally, you can see the cell display value, the problem is solved.