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)**