If I don't have a the correct value in D32:D45 using formula =IF(AND(A25="2020D",F25+INDEX($C$32:$C$45,MATCH(A25,$D$32:$D$45,0))>=6),6-2,F25) it comes back #N/A.
How do I fix the #N/A
I'm thinking I need to have it return 0 if no value and then it can add to cell F25.
Thanks!
How do I fix the #N/A
I'm thinking I need to have it return 0 if no value and then it can add to cell F25.
Thanks!
Test.xlsx | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
23 | Part No. | Description | Code | Retail | Cost | Order Qty | Ship Qty | ||
24 | 2020D | Airplane | AZ | $2,000.00 | $850.00 | 5 | 4 | ||
25 | 2020Z | Airplane | AZ | $2,000.00 | $850.00 | 2 | #N/A | ||
26 | |||||||||
27 | |||||||||
28 | |||||||||
29 | |||||||||
30 | |||||||||
31 | QTY | Part# | |||||||
32 | 2 | 2020D | |||||||
33 | 2 | ||||||||
34 | |||||||||
35 | |||||||||
36 | |||||||||
37 | |||||||||
38 | |||||||||
39 | |||||||||
40 | |||||||||
41 | |||||||||
42 | |||||||||
43 | |||||||||
44 | |||||||||
45 | |||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
G24:G25 | G24 | =IF(AND(A24="2020D",F24+INDEX($C$32:$C$45,MATCH(A24,$D$32:$D$45,0))>=6),6-2,F24) |