IF Question

[Calibre16]

Hi All,

I need assistance witht he following formula:
In cell O2 I am trying to display a "yes" if the number 3 populates any cell in colums M:M and N:N & a "no" for every other number and blanks


Thanks

Michael

 

[JoeMo]

In O2:
=IF(COUNTIF(M:N,3)>0,"yes","no")

 

[jarjarbingie]

O2 = IF(COUNTIF(M:N,3)>0,"yes","no")

Hi All,

I need assistance witht he following formula:
In cell O2 I am trying to display a "yes" if the number 3 populates any cell in colums M:M and N:N & a "no" for every other number and blanks


Thanks

Michael

 

[Calibre16]

Thanks Joe. I tried this, however, any cells thad do not have the 3 are still displaying a yes. how do i get the formula to display a no

Michael

 

[JoeMo]

Thanks Joe. I tried this, however, any cells thad do not have the 3 are still displaying a yes. how do i get the formula to display a no

Michael

I don't understand. You said the 3 might be in col M and/or N and you wanted a formula for cell O2. The formula I posted puts a "yes" in O2 if there is at least one cell in cols M:N with a 3 in it, otherwise it returns a "no" to O2. If that's not what you want, perhaps you can provide a clear description of what you do want.

 

[Calibre16]

I probably wasnt clear enough, however, i have taken your formula and changed the M:N to specific M/N cells. From here dragged this down the O cells replicating the formula for the respective cells.
= IF(COUNTIF(M2:N2,3)>0,"yes","no")

Thanks for your help Joe

 

[JoeMo]

I probably wasnt clear enough, however, i have taken your formula and changed the M:N to specific M/N cells. From here dragged this down the O cells replicating the formula for the respective cells.
= IF(COUNTIF(M2:N2,3)>0,"yes","no")

Thanks for your help Joe

You are welcome - thanks for the reply.