qlong 发表于 2023-12-1 17:29:06

AIAG & VDA FMEA中AP的公式

很多人经常问我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-4 10:28:52

感谢分享··学习学习··

chri.mpeg 发表于 2024-1-16 11:51:24

Thank you for sharing!

chri.mpeg 发表于 2023-12-2 21:26:10

Thank you for sharing!

TBD16888 发表于 2023-12-2 05:16:03

谢谢分享

583516113 发表于 2023-12-2 06:28:55

感谢分享！！

neil0404 发表于 2023-12-2 06:50:27

谢谢分享

xiang129 发表于 2023-12-2 07:36:47

{:1_180:}

2017yuan 发表于 2023-12-2 08:03:50

感谢分享！

dqs123 发表于 2023-12-2 08:37:19

学习的榜样！

samtang 发表于 2023-12-2 08:46:53

{:1_180:}

yxp8012 发表于 2023-12-2 08:48:54


感谢分享！！

saber11 发表于 2023-12-2 08:55:47

谢谢分享{:1_180:}{:1_180:}
页: [1] 2 3 4
查看完整版本: AIAG & VDA FMEA中AP的公式