Hi, I am currently using the following working formula
=IF(AND(ISBLANK(G59),AND(ISBLANK(B59))),"Need Concurrence or Signature",IF(ISBLANK(G59),"","Paid"))
Now I'd like to add another argument, but nothing I have tried has worked.
I would like to add
IF(ISBLANK(E59),"Unassigned", NOT SURE HOW TO FINISH
So basically, it should do this:
First look at E59. If it's blank then "Unassigned"
If it is not blank then it should look at my original formula which says
If G59 and B59 are both blank then "Need Concurrence or Signature"
If G59 is blank then the cell should be blank
If G59 is not blank then "Paid"
Can someone help me integrate that line into my existing formula?
=IF(AND(ISBLANK(G59),AND(ISBLANK(B59))),"Need Concurrence or Signature",IF(ISBLANK(G59),"","Paid"))
Now I'd like to add another argument, but nothing I have tried has worked.
I would like to add
IF(ISBLANK(E59),"Unassigned", NOT SURE HOW TO FINISH
So basically, it should do this:
First look at E59. If it's blank then "Unassigned"
If it is not blank then it should look at my original formula which says
If G59 and B59 are both blank then "Need Concurrence or Signature"
If G59 is blank then the cell should be blank
If G59 is not blank then "Paid"
Can someone help me integrate that line into my existing formula?