Needing help with this. What i have is not working, obviously. Below are 4 scenarios and I need results for all 4.

I have this =IF(ISNUMBER(SEARCH("*",AN32)),IF(AO32>0,"Yes","Pending"),"") from my spreadsheet but I don't know how to change it for what i now need below. What i have below in the "D (Results)" column is the answer i want the formula to give me.

Any help would be appreciated.

Thanks

<tbody> </tbody> <colgroup><col><col span="4"></colgroup><tbody></tbody> |

<colgroup><col><col span="4"></colgroup><tbody>

</tbody><colgroup><col><col span="4"></colgroup><tbody>

</tbody>