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".