I need the right formula

[zinah]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Questions
[/TD]
[TD]2016 Favorability
[/TD]
[TD]Standard Deviation
[/TD]
[TD]2017 Favorability
[/TD]
[TD]Standard Deviation
[/TD]
[TD]2018 Favorability
[/TD]
[TD]Standard Deviation
[/TD]
[TD]Result
[/TD]
[/TR]
[TR]
[TD]Q1
[/TD]
[TD]66.5%
[/TD]
[TD]1.15
[/TD]
[TD]45.2%
[/TD]
[TD]1.8
[/TD]
[TD]30.0%
[/TD]
[TD]0.9
[/TD]
[TD]if 2016 fav% less than 50% and Std. Dev. greater than 1, "Actionable", and if 2017 fav% less than 50%, std.dev. greater than 1, Actionable, if 2018 fav% less than 50% and std.dev. greater than 1,Actionable, if not "non actionable"
[/TD]
[/TR]
</tbody>[/TABLE]

Hi,

I have survey questions of 3 years and I need to take actions based on items/questions based on above mentioned result. Can you please help?


Thanks

 

[Marcelo Branco]

Welcome to Mr Excel forum

Maybe this
=IF(OR(AND(B2<0.5,C2>1),AND(D2<0.5,E2>1),AND(F2<0.5,G2>1)),"Actionable","Non Actionable")

Hope this helps

M.

 

[zinah]

Thanks a million Marcelo for your super prompt action! it's my first thread and I believe it won't be the last if I get such a prompt answer

 

[Marcelo Branco]

You're welcome. Glad to help.

M.