2 statements for one if

  • Thread starter Thread starter dwojtowi
  • Start date Start date
D

dwojtowi

I need to join two statements in an if and check if they are both tru
to continue (this is in a cell, not VBA)

=IF(COUNT(F9)=1 & COUNT(BK9)=1,"A","B")

I know i can do this:
=IF(COUNT(F9)=1,IF(COUNT(BK9)=1,"A","B"),"B")

But that doesnt apply here because I have to do this many times in
cell, and I will reach my limit on number of embedded if
 
I found it:::
Sorry I posted before exhausting my search of help...
=IF(AND(COUNT(F9)=1,COUNT(BK9)=1),"A","B")
Thanks though!!
 
Forget the syntax for a minute and tell us in words the gist of what it is you
are trying to achieve. Also - are your COUNT statements simply to determine if
the cell is empty or not?
 
One way of shortening that for a set of non-contiguous cells:-

=IF(COUNT(F11,H11,J11,F13,H13,J13,F15,H15,J15,F17,H17,J17)=12,"A","B")

and you can also have ranges in there if that helps:-

=IF(COUNT(F11:H11,J11,F17,H17,J17:J22)=12,"A","B")
 
Back
Top