I am trying to construct a code which will give me two different returns, depending on the conditions.
If column "B" has a date, then column "A" should return "Pending"
But, if columns "B" and "R" have dates, then column "A" should return "Approved"
It's for a spreadsheet, for work, I am trying to construct, for easier use. If you have any idea on how I can do this, I would really appreciate the help.
Thank you in advance.