IF,AND Formula

S

Shinka

Trying to get a cell to show a 1 (so I can add it), IF cell A1 is blank and
A2 thru A6 has an "f" in any of them.

If/AND formulas are killing me! Your help is appreaciated.
 
C

Cutter

Try this:

=IF(AND(A1="",COUNTIF(A2:A6,"f")>0),1,"")

You didn't say what value you wanted if the 2 conditions are not met so
I assumed you wanted a blank cell. Change the "" before the last
bracket to something else if a blank cell is not what you want.
 
S

Shinka

Thank You! I wrestled with this for 2 days. Nestled functions are kinda
tough. Nice clean solution...thanks again.
 
S

Shinka

That is what I had but couldn't figure out how to nest the AND with the
COUNTIF.

Thanks - both will work.
 
Top