AND Function

  • Hey all!!

    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.


  • In a Module, use in cell as formula as commented:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!