Looking for solutions to **Excel array formula **not **showing result**? Then this guide is the right place for you. We are going to show you the top **4** reasons with solutions to the problem “**Excel** **array formula **not **showing result**”.

**Table of Contents**hide

## Download Practice Workbook

## 4 Suitable Solutions to Excel Array Formula Not Showing Result

To demonstrate our solutions, we have taken a dataset with **4** columns: “**Car**”, “**Unit** **Sold**”, “**Unit** **Price**”, and “**Revenue**”. We are going to apply an array formula to find the revenues for each type of car sold by a particular company.

### 1. Turning Off Show Formulas Command in Excel to Solve Array Formula Not Showing Result

If the ** Show Formulas **command is turned on, then we will see the

**formula**instead of the

**result**in our

**Sheet**. Let us see what happens when we turn accidentally turn on the “

**” command in**

*Show Formulas***Excel**.

**Steps:**

- To begin with, type the following formula in cell
.*E5*

`=C5:C10*D5:D10`

**Formula Breakdown**

- Firstly, this
**array formula**multiplies a cell from the C andcolumns and returns the value in column*D*.*E* - In cell
, we will get the multiplication value for cell*E5*and cell*C5*. That means,*D5*=*E5*.*C5***D5* - Similarly,
=*E6*,*C6***D6*=*E7*, and so on.*C7***D7* - Thus, this
**array formula**works.

- Then, press
.*ENTER* - After that, instead of showing the
**Excel array formula result**, it will**show**us the**array formula**.

- Now, we will fix this issue.
- Firstly, from the
tab, deselect*Formulas*.*Show Formulas*

- Therefore, we can see that the
**Excel array formula**will**show**the**result**.

### 2. Solving #SPILL! Error in Excel Array Formula to Show Result

In **Excel 365**, the array **formulas **are dynamic. If we type the **formula **and hit ** ENTER**, the formula will auto-populate the cells. Now, if there is an existing value in the way, then we will get the

**error. To fix this, we need to remove that existing value from the cell.**

*#SPILL***Steps:**

- Firstly, type this formula in cell
.*E5*

`=C5:C10*D5:D10`

- Next, notice there is an existing value “
**s**” in cell.*E6*

- After that, press
.*ENTER* - Doing so, we will the
error and our*#SPILL***Excel array formula**is not**showing**the**result**.

- Now, to fix this, we just need to delete the value from cell
.*E6* - Lastly, press
.*ENTER* - So, our
**array formula**will**show**the**result**.

**Similar Readings**

**How to Refresh Formulas in Excel (2 Easy Methods)****[Fixed!] Formula Result Showing 0 in Excel (3 Solutions)****[Fixed]: Excel Formula Not Showing Correct Result (8 Methods)****[Fixed!] Excel SUM Formula Is Not Working and Returns 0 (3 Solutions)**

### 3. Changing Cell Format in Excel to Fix Array Formula Not Showing Result

For the third reason, if our cell is formatted as ** Text **then we will see the

**formula**rather than the result. We need to rectify that

**to**

*Number Format***show**the

**result**of the

**array formula**.

**Steps:**

- First, type the formula in cell
.*E5*

`=C5:C10*D5:D10`

- Next, press
.*ENTER* - Then, we will notice that the
**formula**is not**showing**any**result**. Moreover, we are seeing the**formula**only. - Additionally, the
is set to*Number Format*.*Text*

- Now, we need to change that
format to any other format.*Text* - So, we have selected the
format from the dropdown list.*Currency* - Then, active the formula by double-clicking on cell
.*E5* - Lastly, press
.*ENTER*

- Thus, the
**Excel array formula**will return the desired output.

**Read More: [Fixed!] Formula Not Working and Showing as Text in Excel**

### 4. Showing Result by Pressing Only ENTER in Excel Array Formula

**Microsoft **has changed how **array formulas **work in the version of **Excel 365**. On older versions, we needed to press ** CTRL+SHIFT+ENTER** to calculate an array formula. However, now we need to press just

**. Therefore, if anyone presses the previous**

*ENTER***Keyboard**shortcut, the

**array formula**may not work.

**Steps:**

- To begin with, type the following formula in cell
.*E5*

`=C5:C10*D5:D10`

- Now, instead of pressing just
, we have pressed*ENTER*.*CTRL+SHIFT+ENTER* - So, we will only see the first value, which means the
part only from our array formula.*C5*D5*

- To fix this, activate cell
by double-clicking on it.*E5* - Then, press
.*ENTER* - Thus, it will
**show**the**result**as expected.

## Things to Remember

- This article is based on the
**Excel 365**version. Therefore, if you are using an older than**Excel 2019**version, then you must pressto use the array formula. If you just press*CTRL+SHIFT+ENTER*, then your array formula will not work except for some functions such as the*ENTER***AGGREGATE**and**SUMPRODUCT**.

## Practice Section

We have added a practice dataset for each method in the **Excel** file. Therefore, you can follow along with our methods easily.

## Conclusion

We have shown you the top **4** reasons with solutions to the issue of the **Excel array formula **not **showing **a **result**. If you face any problems regarding these methods or have any feedback for me, feel free to comment below. Moreover, you can visit our site **ExcelDemy** for more **Excel-related** articles. Thanks for reading, keep excelling!

## Related Articles

**[Solved:] Excel Formula Not Working unless Double Click Cell (5 Solutions)****[Solved]: Excel Formulas Not Updating Until Save (6 Possible Solutions)****[Fixed!] Why Formula Is Not Working in Excel (15 Reasons with Solutions)****[Fixed!] Excel Formulas Not Working on Another Computer (5 Solutions)****[Fixed!] SUM Formula Not Working in Excel (8 Reasons with Solutions)**

Hi. I was using the “mode.mult” function but for set of numbers with more than 1 mode, the function shows only 1 mode instead of 2 or more. I tried using the “ctrl+shift+enter” but it still only shows 1 mode. How do I fix this? Thank you.

Hello Cielo. Thank you for your question. I have tested the function on Excel

365,2021, and2013versions. On first two version, you simply pressENTERand the formula will be spilled. However, in Excel2013if you press that, it will only show the first value.Here, we have typed the formula in cell

.C5Then, pressed

CTRL+SHIFT+ENTER. But, only the first value is seen.To solve this, you need to follow these steps:

1. Select the cell ranges

C5:C8first.2. Type the formula

=MODE.MULT(B5:B11)3. Press

CTRL+SHIFT+ENTER. So, it will show all the mode values. Additionally, we have selected four cells, but there are only three outputs. Therefore, there is a “#N/A” for that reason.