Can anyone help with this excel formula?? I am stumped with this one...
AB1 and AG1 are both blank then return "No PPA"
AB1 has text but AG1 is blank then return "Framework"
AB1 is blank but AG1 has a date then the following formula needs to be used...
IF(AG1-TODAY()>90, "Live", IF(TODAY()-AG1>0, "Expired", "Expiring Soon"
I basically need to merge IF(AND(ISBLANK(AB1),ISBLANK(AG1)),"No PPA",IF(ISBLANK(AG1),"Framework" with IF(AG1-TODAY()>90, "Live", IF(TODAY()-AG1>0, "Expired", "Expiring Soon"
Is this possible?
Aucun commentaire:
Enregistrer un commentaire