Can someone help me with this.
as it stands the OR's are not working in the total formula correctly
ANY of the OR's must be TRUE
ALL of the AND's must be TRUE
as it stands the OR's are not working in the total formula correctly
ANY of the OR's must be TRUE
ALL of the AND's must be TRUE
Power Query:
if [Q1] = "A"
or [Q1] = "B"
or [Q1] = "C"
and [Q12] = "Replacement"
and [Q13] = "MyBrand"
and [Q14] = "Model x"
then "A replacement for x"
else "A replacement for y"