Not all formulas in a new inserted row (Table) are automatically copied

[reyearthnexus]

Hi guys,

A had a several rows with data and I needed excel to automatically copy all the formulas already typed in the other rows every time I inserted a NEW row.
As suggested in the forum, I made a TABLE from that array because it seemed to be the logical solution,
But, bizarre, it works except ONE formula and I cant understand why...

could you please tell me what mistake I make?

In case it might help, this is the formula it doesnt copy

=IF((ISBLANK(F28)=TRUE),"NO NAME",IF(ISBLANK(A28)=FALSE,COUNTIF(F28,MAP),"NO CO."))

nothing really complicated indeed

Any help is really appreciated
Many thanks

[reyearthnexus]

Solved guys no worries

(I added that formula AFTER having made the array become a TABLE. I just undid the table, insert the formula, and set it as a table again. I works )

thanks anyway

[martindwilson]

that formula doesnt make sense
COUNTIF(F28,MAP)
doesnt look right!
do you mean f28="map"
any way you dont need true/false
=IF(ISBLANK(F28),"NO NAME",IF(ISBLANK(A28),"NO CO.",COUNTIF(F28,MAP)))

nad changing the last bit
=IF(ISBLANK(F28),"NO NAME",IF(ISBLANK(A28),"NO CO.",(f28="map")+0))