Remove False from Array

[kspikes]

I am attempting to remove a FALSE response in the following formula. It gives a blank cell if goal is equal and provides the correct response if the goal is meet, but if the goal is not meet it provides FALSE. I have attempted ,""),""),"") etc. at the end, but it provides a warning of "You've entered too many arguments for this function".

=IF($A4=Goals!B$1,IF($T4>=Goals!B$4,'FCI Teller SSA'!$U$3),IF($A4=Goals!C$1,IF($T4>=Goals!C$4,$U$3),IF($A4=Goals!D$1,IF($T4>=Goals!D$4,$U$3),IF($A4=Goals!E$1,IF($T4>=Goals!E$4,$U$3),IF($A4=Goals!F$1,IF($T4>=Goals!F$4,$U$3),IF($A4=Goals!G$1,IF($T4>=Goals!G$4,$U$3),IF($A4=Goals!H$1,IF($T4>=Goals!H$4,$U$3),IF($A4=Goals!I$1,IF($T4>=Goals!I$4,$U$3),IF($A4=Goals!J$1,IF($T4>=Goals!J$4,$U$3),IF($A4=Goals!K$1,IF($T4>=Goals!K$4,$U$3),IF($A4=Goals!L$1,IF($T4>=Goals!L$4,$U$3),IF($A4=Goals!M$1,IF($T4>=Goals!M$4,$U$3),IF($A4=Goals!N$1,IF($T4>=Goals!N$4,$U$3),IF($A4=Goals!O$1,IF($T4>=Goals!O$4,$U$3),IF($A4=Goals!P$1,IF($T4>=Goals!P$4,$U$3),IF($A4=Goals!Q$1,IF($T4>=Goals!Q$4,$U$3),IF($A4=Goals!R$1,IF($T4>=Goals!R$4,$U$3,""),"")))))))))))))))))

 

[Fluff]

Hi & welcome to MrExcel.
You need to do it like

=IF($A4=Goals!B$1,IF($T4>=Goals!B$4,$U$3,""),IF($A4=Goals!C$1,IF($T4>=Goals!C$4,$U$3,""),IF($A4=Goals!D$1,IF($T4>=Goals!D$4,$U$3,""),

However you could probably simplify that formula to

=IF(T4>=SUMIFS(Goals!B4:R4,Goals!$B$1:$R$1,A4),$U$3)