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

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


--

Regards,

Peo Sjoblom

"DaveG" wrote in message
...
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

Peo, thank you, it works perfectly now!
--
DaveG


"Peo Sjoblom" wrote:

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


--

Regards,

Peo Sjoblom

"DaveG" wrote in message
...
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