Formula using IF, AND and OR Arguements

[Guest]

I work in the mortgage lending industry and I use Excel 2003 to track
information about each of the loans I review. I want to write a formula that
says: IF the value in cell A1 = "Refi" AND IF the value in cell A2 = AAAA or
BBBB or CCCC, THEN return the value DDDD in cell A3, otherwise leave cell A3
blank.

My formula works if I have only one value for cell A2, but it fails when I
try to add the OR values.

Any suggestions would be most appreciated.

 

[Peo Sjoblom]

=IF(AND(A1="Refi",OR(A2=AAAA,A2=BBBB,A2=CCCC)),DDDD,"")

 

[Guest]

Peo, thank you, it works perfectly now!