I need a formula that returns the value on column C as "yes" if column A has any text(name) and Column B has "Approved",
also if column B has any other answer, Column C returns as "No"
and if Column B is empty, Column C returns as blank.
here's what I have which doesnt work, this might have a really different formula than what I have:
=IF(ISBLANK(AND(A2,B2)),IF(AND(istext=A2,B2=Approved), "Yes","No"))
any thoughts?
Bookmarks