2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Simple Formula Spilling into an Array

While trying to set up a simple IF statement with an AVERAGE function, I am getting results spilling out into an array over a number of cells below the formula. Specifically, I get a set of cells starting with the one with the formula and going down a coulumn to equal the number of cells I specified in the formula, surrou ded by a light blue border along the outside. An example of my formula is below:

=IF(C14:C17<>"",AVERAGE(C14:C17),"")

As this is being used as part of a form I am making, there are no values in any cell surrounding the formula except the cell to its left being a row label (just says "Average"). And AVERAGE function should also only provide one solution as well. I cannot figure out what Excel is trying to do or how to correct it.

Does anyone have a similar issue with this happening? I am curious if this is a new example of an update breaking something in Excel it shouldn't have. Also, is there a solution I can try? I tried the "@" addition, but that didn't work as intended.

Any help would be most helpful.

submitted by /u/Charliefoxkit
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#AI formula generation techniques
#financial modeling with spreadsheets
#Excel compatibility
#Excel alternatives for data analysis
#rows.com
#row zero
#Excel
#AVERAGE function
#IF statement
#array
#formula
#spilling
#cells
#column
#solution
#row label
#blank cells
#border
#form
#results