This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi Everyone
Can someone please explain to me why excel returns an #NUM! result for the following array formula?
=QUARTILE(IF(DATA!$B:$B=1,IF(DATA!$E:$E="bkbsa",IF(DATA!I:I>='MAF3,4,5'!M2,IF(DATA!I:I<='MAF3,4,5'!M3,IF(ISNUMBER(MATCH(DATA!$T:$T,{"maf3","maf4","maf5"},0)),DATA!$C:$C))))),1)
The workbook has 2 sheets, DATA and MAF3,4,5
On Sheet MAF3,4,5 I have included a minimum and maximum value in M2 and M3 respectively.
The formula was working fine until I added the underlined section. I myself can't seem to see the problem...
Example of data:
| A | B | C | E | F | I | T |
|---|---|---|---|---|---|---|
| SEASON | SALE | CLEAN PRICE | BROKER | NETKG | MICRON | TYPE |
| 16 | 1 | 9.37 | BKBSA | 1373.8 | 23.0 | MAF3 |
| 16 | 1 | 20.64 | BKBSA | 254.7 | 21.2 | MAS6 |
| 16 | 1 | 21.49 | BKBSA | 1922.8 | 23.0 | MAF4 |
| 16 | 1 | 18.63 | BKBSA | 223.2 | 30.3 | MAF6 |
Please help urgently
Thank you in advance
Kind regards
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Hello,
Excel shows this error when a formula or function contains numeric values that aren’t valid. To know more information on how to correct a #NUM! error when using formulas on Excel, please visit this link.
Kindly post back with the status of the issue and we will be glad to assist you further.