I have the following formula:
=IF(F2="",IF(G2="","MISSING BOTH","MISSING GCT"),IF(G2="","MISSING LOCAL","HAVE BOTH"))
I would like to add to this formula the followig:
=IF(H2=”Cancelled”) go to end
IF(A2=”Global Interfaces”, IF(F2="","MISSING GCT") go to enf
Please advise on how can I insert these IFs into the same formula
Thanks
Bookmarks