IF Function

[Natalie18]

Hi everyone,

I am creating a Project management sheet. In Column B I will have a drop down menu saying either
- Need Quote
- Quote Sent
- PO received
- In Progress
- Complete
I would like to have a Cell on the top of the sheet that says Project Open, and for it to say yes or no automatically when the status says specific items. For example, if anywhere in the status column it says "Need Quote" "Quote Sent" "PO Received" "In Progress", than the top cell will says "yes" project open.

When I use the If function it gives me a spill error.
=If($B$5:$B$25="Need Quote""Quote Sent""PO Received""In Progress","Yes","No"

I don't want the whole column to say yes or no, which is what happens when I fix the spill error. Please advise.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(sum(COUNTIFS(b:b,{"Need Quote","Quote Sent","PO Received","In Progress"})),"Yes","No")