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.
--
DaveG