CWhite1990
New Member
- Joined
- Aug 20, 2013
- Messages
- 4
Is there a way on excel to produce a nested IF that says when 3 cells out of a row of 26 cell exceeds 100, then 'issue' is shown? So far I have the worksheet set up using: '=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")' which is each single cell in the row, but I'd like to go a step further for it to be if any 3 of these calls exceeds 100, then nuisance or no issue is shown and not just if one single cell exceeds it. Does that make any sense? Haha.