Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1214
  • Last Modified:

remove #NUM! error

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.
0
Seamus2626
Asked:
Seamus2626
2 Solutions
 
Rob HensonIT & Database AssistantCommented:
Wrap it all in an IFERROR statement.

=IFERROR(YourFormula,0)

Thanks
Rob H
0
 
Rgonzo1971Commented:
Hi
In XL2007 and further

=IFERROR(PERCENTILE.EXC(IF(ISNUMBER(MATCH(InputRange,{1,3,4,5,6},0)),IF(InputRange<>"",CashFormula)),'S7 - Product Risk Scenario'!D28),0)

Regards
0
 
Seamus2626Author Commented:
Perfect guys,

Many thanks
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now