很多人经常问我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","")))))))))))))))))))))))))),"")
|
发表于 2023-12-1 17:29:06
发表于 2023-12-2 05:16:03
发表于 2023-12-2 06:28:55
