multiple IF

[mbsalim]

Hi Geniuses!

so, multiple if statement, scenario;

Various formulas giving a yes or no or (any other specific value)

so i want the last column to be a if statement saying if the answer to any of the columns to the left is yes than be a yes if not then no. I got the below but it does not seem to work.


=IF(L2="Specific value","Yes",IF(L2="specific value2","Yes",IF(S2="specific value 3","Yes",IF(T2="specific value 4",IF(U2="Yes","Yes",IF(W2="Yes","Yes",IF(Y2="Yes","Yes","No")))))))

any help will be much appreciated

Thanks!!

 

[istiasztalos]

hi mbsalim,

it would be easier to count if there's any "yes" instead of adding separate formula part for each target cell...

for example if your questions are in column B from row 1 to 6, you would use:
=COUNTIF(B1:B6;"yes")

you can add one IF function around it, that if there are 0 'yes' it returns "no" otherwise "yes"
=IF(COUNTIF(B1:B6;"yes")=0;"no";"yes")

 

[Aladin Akyurek]

=IF(ISNUMBER(MATCH(L2,valuelist,0)),"yes","no")

where valuelist refers to a range housing the specific values of interest.

 

[BarryL]

ill throw in an array one just because

=IF(SUM(IF(L2:Z2="value",1,0))>0,"Yes","No")
(ctrl+shft+enter)

 

[mbsalim]

thanks guys!!!!!