Alternative to IFS formula

[Bravo2003]

Excel 2016
I have 12 columns with values in (example row - FU3:GF3)
I want cell FT3 to check if 'any' cell in the row of 12 has a negative value then result with "Minus"

Instead of having to type 12 IF conditions, is there a simpler option?


Thanks

 

[AlanY]

tey this in FT3 and copy down

=IF(COUNTIF(FU3:GF3,"<0")>0,"Minus","")

 

[PCL]

Try

=IF(SUMPRODUCT(--(FU3:GF3<0))>0;"Minus";"")

 

[Bravo2003]

tey this in FT3 and copy down

=IF(COUNTIF(FU3:GF3,"<0")>0,"Minus","")

Gone with this, thanks, works fine.

Cheers

 

[AlanY]

you're welcome