Summarizing User Input (If and And Statements)

[jsiutra]

I have a worksheet, which I send out to different users to update with either a
"Y" "N" and "C" in three separate columns and looking for a result in the fourth
column.

Example:

Work to be done 10 yr Plan Restart Current Status

Y Y N Legit
N N N Write-Off
N Y N Legit
N N Y Legit
C Complete

I'm looking for a formula, If/and statements, to be able to derive the current status based on the Y, N, and C inputs from the users.

Thanks in Advance
John

 

[ranman256]

Build your own function in the macros area:

In col D, use: getResult(A1,B1,C1)

Function getResult(pA, pB, pC) As String
'Y Y N Legit
'N N N Write-Off
'N Y N Legit
'N N Y Legit
'C Complete
Select Case True
  Case pA = "Y" And pB = "Y" And pC = "N"
    getResult = "Legit"
  
  Case pA = "N" And pB = "N" And pC = "N"
    getResult = "Write-Off"
  
  Case pA = "N" And pB = "Y" And pC = "N"
    getResult = "Legit"
  
  Case pA = "N" And pB = "N" And pC = "Y"
    getResult = "Legit"
  
  Case pA = "C"
    getResult = "Complete"
End Select
End Function