|I am assuming that there will only be a value in I5 if there is also a value in H5.|
What this says is:
1 - If H5 is empty, return Pending
2 - If H5 is not empty and I5 is empty, return Collected
3 - If both 1 and 2 are False, return Transferred
Note: As written, if H5 is empty and I5 is not empty, the formula will return Pending. Let me know if that is going to be a problem.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.