| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IFERROR Inconsistent Formula because of Bloomberg Link?
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, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW TO CATCH A DIFFERENT/INCONSISTENT FORMULA | Excel Discussion (Misc queries) | |||
| Inconsistent Formula? | Excel Discussion (Misc queries) | |||
| How do I round up the answer an iferror formula? | Excel Discussion (Misc queries) | |||
| Formula results inconsistent. | Excel Worksheet Functions | |||
| Help! ISO formula for inconsistent monthly dates | Excel Discussion (Misc queries) | |||
Threaded Mode
