AIAG & VDA FMEA中AP的公式

qlong

很多人经常问我AIAG & VDA FMEA中的AP如何在Excel中通过公式自动确定，我曾经写过3个公式，其中一个是穷举法的公式，公式现在写在下面，有兴趣的自己去FMEA表格中录入。

=IFERROR(IF(AND(B6>=9,B6<=10,C6>=6,C6<=10,D6>=1,D6<=10),"H",IF(AND(B6>=9,B6<=10,C6>=4,C6<=5,D6>=2,D6<=10),"H",IF(AND(B6>=9,B6<=10,C6>=4,C6<=5,D6>=1,D6<=1),"M",IF(AND(B6>=9,B6<=10,C6>=2,C6<=3,D6>=7,D6<=10),"H",IF(AND(B6>=9,B6<=10,C6>=2,C6<=3,D6>=5,D6<=6),"M",IF(AND(B6>=9,B6<=10,C6>=2,C6<=3,D6>=1,D6<=4),"L",IF(AND(B6>=9,B6<=10,C6>=1,C6<=1,D6>=1,D6<=10),"L",IF(AND(B6>=7,B6<=8,C6>=8,C6<=10,D6>=1,D6<=10),"H",IF(AND(B6>=7,B6<=8,C6>=6,C6<=7,D6>=2,D6<=10),"H",IF(AND(B6>=7,B6<=8,C6>=6,C6<=7,D6>=1,D6<=1),"M",IF(AND(B6>=7,B6<=8,C6>=4,C6<=5,D6>=7,D6<=10),"H",IF(AND(B6>=7,B6<=8,C6>=4,C6<=5,D6>=1,D6<=6),"M",IF(AND(B6>=7,B6<=8,C6>=2,C6<=3,D6>=5,D6<=10),"M",IF(AND(B6>=7,B6<=8,C6>=2,C6<=3,D6>=1,D6<=4),"L",IF(AND(B6>=7,B6<=8,C6>=1,C6<=1,D6>=1,D6<=10),"L",IF(AND(B6>=4,B6<=6,C6>=8,C6<=10,D6>=5,D6<=10),"H",IF(AND(B6>=4,B6<=6,C6>=8,C6<=10,D6>=1,D6<=4),"M",IF(AND(B6>=4,B6<=6,C6>=6,C6<=7,D6>=2,D6<=10),"M",IF(AND(B6>=4,B6<=6,C6>=6,C6<=7,D6>=1,D6<=1),"L",IF(AND(B6>=4,B6<=6,C6>=1,C6<=3,D6>=1,D6<=10),"L",IF(AND(B6>=2,B6<=3,C6>=8,C6<=10,D6>=5,D6<=10),"M",IF(AND(B6>=2,B6<=3,C6>=8,C6<=10,D6>=1,D6<=4),"L",IF(AND(B6>=2,B6<=3,C6>=1,C6<=7,D6>=1,D6<=10),"L",IF(AND(B6>=1,B6<=1,C6>=1,C6<=10,D6>=1,D6<=10),"L",IF(AND(B6>=4,B6<=6,C6>=4,C6<=5,D6>=7,D6<=10),"M",IF(AND(B6>=4,B6<=6,C6>=4,C6<=5,D6>=1,D6<=6),"L","")))))))))))))))))))))))))),"")

TBD16888

谢谢分享

583516113

感谢分享！！

neil0404

谢谢分享

xiang129

2017yuan

感谢分享！

dqs123

学习的榜样！

samtang

yxp8012

感谢分享！！

saber11

谢谢分享