<div>
Perfect guys,<br />
<br />
Many thanks
</div>


<div>
<div class="content wysiwyg-content">
Hi, i have a formula<br />
<br />
=PERCENTILE.EXC(IF(ISNUMBE<wbr />R(MATCH(In<wbr />putRange,{<wbr />1,3,4,5,6}<wbr />,0)),IF(In<wbr />putRange&lt;&gt;<wbr />&quot;&quot;,CashFor<wbr />mula)),'S7<wbr /> - Product Risk Scenario'!D28)<br />
<br />
<br />
If there is no data there it creates a #NUM! error and makes the data that has returned difficult to read, can anyone add to the formula to return zero when no data is present in the ranges<br />
<br />
Many thanks<br />
Seamus.
</div>
</div>


Hi, i have a formula

=PERCENTILE.EXC(IF(ISNUMBER(MATCH(InputRange,{1,3,4,5,6},0)),IF(InputRange<>"",CashFormula)),'S7 - Product Risk Scenario'!D28)


If there is no data there it creates a #NUM! error and makes the data that has returned difficult to read, can anyone add to the formula to return zero when no data is present in the ranges

Many thanks
Seamus.

remove #NUM! error

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.