AND Function

demekore · Dec 3rd 2018

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.

~Heidi

**Kenneth Hobson** · Dec 3rd 2018

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

Code

'=dstat(ROW())
Function dStat(rn As Long) As String
  Dim s$
  Application.Volatile (True)
  Select Case True
    Case IsDate(Cells(rn, "B")) And IsDate(Cells(rn, "R"))
      s = "Approved"
    Case IsDate(Cells(rn, "B"))
      s = "Pending"
    Case Else
      s = ""
  End Select
  dStat = s
End Function

Display More

AND Function

Participate now!

Share