Forum Discussion
Solved
IF AND statement need to omit blanks
I currently have a document that looks like the above. Basically, if certain cells are a 2, then the column AC will turn into a 2 should certain criteria be met. If the criteria are not met,...
=IF(COUNTBLANK(L4:W4)=12,"",IF(AND(L4=2,M4=2,N4=2,O4=2,P4=2,Q4=2,R4=2,S4=2,T4=2,U4=2,V4=2,W4=2),2,1))This returns the intended output in my example if i correctly understand what you want to do.
Sergei,
2 problems, you have a solution to both. Thank you.
2 problems, you have a solution to both. Thank you.
MDawson2025 , you are welcome