ExcelBanter - mutilple column formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - mutilple column formula (https://www.excelbanter.com/excel-worksheet-functions/191649-mutilple-column-formula.html)

JaneSmith

mutilple column formula

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

Bob Phillips[_3_]

mutilple column formula

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

All times are GMT +1. The time now is 12:23 PM.