ELSE IF from 2 Values Hi all I am stuck and all i find in a search is help for u

ID: 3561345 • Letter: E

Question

ELSE IF from 2 Values

Hi all

I am stuck and all i find in a search is help for using multiple IF, which is kind of there, but not quite.

so here is my data

TRUE

The "IN SERVICE LIVE" col. is auto generated from a bunch of dates, it works fine.

The "SHOULD BE LIVE" col. is user input (Validation Rule Applied)

Its the last Col. that i want to be auto generated from a Formula, logic would be something like,

IF (A1=TRUE) & (B1=NO) THEN "YES"

ELSEIF

(A1=TRUE) & (B1=YES) THEN "NO"

ELSEIF

(A1=FALSE) & (B1=NO) THEN "NO"

ELSEIF

(A1=FALSE) & (B1=YES) THEN "YES"

END

But i have no idea on how to drop that into Excel?

my current attempt is:

=IF(A1="TRUE",B1="NO","YES",IF(A1="FALSE",B1="YES"),"YES","NO")

Please help...

IS SERVICE LIVE SHOULD SERVICE BE LIVE IS THERE AN ISSUE

TRUE

NO YES TRUE YES NO FALSE NO NO FALSE YES YES

$@#Hi>?/,

You refer to A1, B1 but I guess you have headers, so referring to A2 & B2...

=IF(A2,IF(B2="NO","Yes","No"),IF(B2="Yes","Yes","No"))

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.