=IF(COUNTIF(A2:D2,"Yes")=4,123,"")

--
__________________________________
HTH

Bob

"JaneSmith" wrote in message
...
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".