Forum Discussion

MDawson2025's avatar
MDawson2025
Copper Contributor
Sep 28, 2023
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,...
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Sep 28, 2023

    MDawson2025 

    =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.

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Sep 28, 2023

MDawson2025 

As variant

=IF( COUNTIFS(L6:W6, "") = 12, "", IF( COUNTIFS(L6:W6, 2) = 12, 2, 1 ) )
  • MDawson2025's avatar
    MDawson2025
    Copper Contributor
    Sep 28, 2023
    Sergei,

    2 problems, you have a solution to both. Thank you.

Resources