IF AND Query?

[rfletcher35]

I have a formula in CELL AA8 - =IF(AND(T8>=$X$2,V8="YES"),"x","")

In CELL T8 is Nothing but CELL V8 has YES

My understanding of the formula is that AA8 should be blank as both cases are not true, what's going wrong??

Sorry about the bold type all the way through for some reason it would not turn off!


Thanks in advance

Fletch

 

[Matt Rogers]

For me it worked like this:
Insert and use the formula without "="
= Insert.
It works.

No guarantee!