我试图在具有3个条件的特定人群上运行STDEV.P。我使用AVERAGEIFS做到了这一点,并且效果很好。
这是我的等式:
{=STDEV.P(IF((Adjusted_Player_Data!A:A=Sim_FG!A3,Adjusted_Player_Data!AK:AK=SImulated_Outcome!H3),Adjusted_Player_Data!K:K,""))}
Adjusted_Player_Data!A:A is a player name list
Sim_FG!A3 is the player I'm looking up
Player_Data!AK:AK is the scale names (Low, Med, High)
Simluated_Outcome!H3 is the scale I am trying to match.
Adjusted!K:K is the range I am running the STDEV.P against.
基本上,我需要匹配玩家并从大名单中进行扩展。我的averageifs函数可以完美运行,它是这样的:=IF(SImulated_Outcome!M2="Y",AVERAGEIFS(Adjusted_Player_Data!K:K,Adjusted_Player_Data!A:A,Sim_FG!A3,Adjusted_Player_Data!AK:AK,SImulated_Outcome!H3),"")
我在下面找到了关于嵌套的答案,但是现在我想添加另一个条件。如果M2 = Y,则运行类似的STDEV。
=IF(SImulated_Outcome!M2="Y",STDEV.P(IF(Adjusted_Player_Data!A:A=Sim_FG!A3,IF(Adjusted_Player_Data!AK:AK=SImulated_Outcome!H3,IF(Adjusted_Player_Data!AP:AP=1,Adjusted_Player_Data!K:K),STDEV.P(IF(Adjusted_Player_Data!A:A=Sim_FG!A3,IF(Adjusted_Player_Data!AK:AK=SImulated_Outcome!H3,IF(Adjusted_Player_Data!AP:AP=0,Adjusted_Player_Data!K:K))))))))
您需要使用嵌套IF
以s STDEV.P
:
=STDEV.P(IF(Adjusted_Player_Data!A:A=Sim_FG!A3,IF(Adjusted_Player_Data!AK:AK=SImulated_Outcome!H3,Adjusted_Player_Data!K:K,""),""))
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句