IF formula using OR

**Jiptastic** · 03-14-2013, 12:47 PM

I feel like I've asked this question on here several times. I want to embed an OR statement within an IF statement. Here's what I have:

=if(OR(D2="Offer Received",D2="Offer Approved",D2="Closing"),C2,B2)

**martindwilson** · 03-14-2013, 12:58 PM

nothing wrong with that but you can use
=if(OR(D2={"Offer Received","Offer Approved","Closing"}),C2,B2)

**Jakobshavn** · 03-14-2013, 01:00 PM

Your equation is correct.

**Jiptastic** · 03-14-2013, 01:11 PM

That works. Thanks amigo!

**Jiptastic** · 03-14-2013, 01:12 PM

Actually, I think what I was doing was fine, but the cell was formatted to text. It's nice to know another solution though.

Re: IF formula using OR