If condition in Google sheet

Hi All,

I really need some help to make formula in Google sheet with the following conditions below:

Images	Inventory	Product Information	Expected return
Yes	Yes	Yes	Product Listed with no error
No	No	No	Product Listed with pending Images, Inventory and Product information
Yes	Yes	No	Product Listed with pending Product information
Yes	No	Yes	Product Listed with pending Inventory

So basically just telling what i am missing. Here is my formula =if(A2="Yes", if(B2="Yes",if(C2="Yes","Product listed with NO error","Product Listed with Error"))) but obviously it is not working properly

Capture.PNG

Welcome to the forum.

I have removed the urgency note from the thread title. Don't tell us that it is URGENT, please. To you it may be, but to us it isn’t. If it’s urgent, you should be calling on a consultant, not a volunteer who is giving their free time. If you want help here, you will need to wait patiently until someone comes along who is prepared to help you in their own time. Thanks.

Apologies. Thank you for flagging me

There are instructions at the top of the page explaining how to attach your sample workbook.

The use of if is not necessary

PHP Code: 

="product listed with " & if(countif(A1:C1,"yes")=3,"No", "")& " error"