IF - AND Function

M

Michael

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
 
P

Peo Sjoblom

Your formula is correct except that you want to add something if both cells
are empty, so I suspect that you might have hidden spaces. Does this work?

=IF(AND(TRIM(A1)="RI", TRIM(C1)="Sold"),"Property Sold", "For Sale")


if so you have extra spaces, if it still doesn't work you might have hidden
html characters or there is a typo somewhere
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need assistance with how or even if this is possible (function) 8
How do I perform calculation within IF statement? 3
Can UDF return a customized hyperlink? 3
Excel IF Formulas 2
Conditional Calculations with Calculated Results 1
Formatting a Sentence With TEXT Function 2
Problem with IF function 3
an IF function that can take no action? 5

Top