J
JaneSmith
how do i create a formula that looks at mutiple column and gives a value
ie, if column "a, b, c, d" has "Yes" value, then "e" should display "123".
ie, if column "a, b, c, d" has "Yes" value, then "e" should display "123".
2,"Yes")=4,123,"")