#Spill! error in merged cell

[drom]

Hi and Thanks in advance!!


AZ8 =IF(CELL("width";AX6)>0;"YES";"")
AU8: AAZ8 are merged range of cells

I get #Spill! error

I go to other columns and I put eg in BE7:

BE7=IF(CELL("width";$AX$6)>0;"YES";"")​

I get YES on blank in BE7:BF7​

How can I avoid this ??

 

[myall_blues]

The "width" parameter of =CELL returns an array of 2 items. The first is the width of the cell defined by reference, and the second is a boolean TRUE or FALSE depending on whether the cell width is the default or not (see CELL function).
An array cannot spill into a merged cell - see #SPILL! error - Spill into merged cell. There is no way around it other than to put the formula somewhere else or unmerge the cells.

Edit: I just played around a bit and you can do it by changing your formula to

=IF(@CELL("width";AX6)>0;"YES";"")

which will return only the first element of the array.