ItalianPlatinum
Well-known Member
- Joined
- Mar 23, 2017
- Messages
- 870
- Office Version
- 365
- 2019
- Platform
- Windows
Hello - I am 100% there is a better way to do this but I couldnt seem to do it without yielding the results i didnt expect. Is there way quicker cleaner way to do the below?
=AND(A4=TRUE,B4=TRUE,D4=TRUE,E4=TRUE,F4=TRUE,G4=TRUE,H4=TRUE,I4=TRUE,J4=TRUE,K4=TRUE,L4=TRUE,M4=TRUE,N4=TRUE,O4=TRUE,P4=TRUE,Q4=TRUE,R4=TRUE,S4=TRUE,T4=TRUE,U4=TRUE,X4=TRUE,Y4=TRUE,Z4=TRUE,AA4=TRUE,AD4=TRUE,AK4=TRUE,AZ4=TRUE,BB4=TRUE,BC4=TRUE)
=AND(A4=TRUE,B4=TRUE,D4=TRUE,E4=TRUE,F4=TRUE,G4=TRUE,H4=TRUE,I4=TRUE,J4=TRUE,K4=TRUE,L4=TRUE,M4=TRUE,N4=TRUE,O4=TRUE,P4=TRUE,Q4=TRUE,R4=TRUE,S4=TRUE,T4=TRUE,U4=TRUE,X4=TRUE,Y4=TRUE,Z4=TRUE,AA4=TRUE,AD4=TRUE,AK4=TRUE,AZ4=TRUE,BB4=TRUE,BC4=TRUE)
