Row nested if with multiple cells?

[CWhite1990]

Is there a way to create/use a nested if function that enables you to show that if 3 cells exceed the value of X, then 'nusiance' is shown, but if only 2 cells exceed that value (100) 'no issue' is shown?

I have the worksheet set up currently using the longwinded

'=IF(OR(C5=$C$2,D5=$D$2,E5=$E$2,F5=$F$2,G5=$G$2, H5=$H$2,I5=$I$2,J5=$J$2,K5=$K$2,L5=$L$2,M5=$M$2,N5=$N$2, O5=$O$2,P5=$P$2,Q5=$Q$2,R5=$R$2,S5=$S$2,T5=$T$2,U5=$U$2, V5=$V$2,W5=$W$2,X5=$X$2,Y5=$Y$2,Z5=$Z$2 ),"Nusiance","No Issue")'

for each individual cell, but I can't find/work out how to make it so that nuisance only shows if 3 cells exceed 100 and not each individual cell.

Does that make any sense to anyone? Haha,

 

[Jubjab]

=IF(COUNTIF(C5:Z5,">=100")>=3,"Nusiance","No issue")

 

[CWhite1990]

=IF(COUNTIF(C5:Z5,">=100")>=3,"Nusiance","No issue")

Legend, thank you!!