Hi Guys, I am trying to use an IFERROR formula around a Bloomberg-linked cell
for live pricing, but I am getting an Inconsistent Formula tag and I still
get "#N/A Sec" error. I know the Bloomberg formula is fine, but I can't get
it to return "0" if the "#N/A Sec" error comes through. An example of my
formula is below:

=IFERROR(blp(LEFT($D192,LEN($D192)-3)&" HK EQUITY",$Y$1),0)

Is this an issue with bloomberg-linked formulae or am I being an idiot?

Thanks,