Hi Folks - I'm trying to create an IF/AND function something like this ....

=if(and(a1="RI", c1="Sold"),"Property Sold", "For Sale")

Basically, if State = RI AND Status = Sold, then display appropriate text.
However, it seems that the AND function does not handle text as a logical
test. Any workarounds? Thanks,

Michael