For example: Looking up the PE of a stock/ETF - ETF's do not have a PE and consequently show up as "#FIELD!" . This happens on several items and I would like to leave the cells with "#FIELD!" blank - is there anyway to do this. (I tried using conditional formatting but this did not work - >0 and <100)
(the obvious solution is to simply delete the =[@[MS Call]].[P/E] from the cells with "#FIELD! in them - but just checking to see if there is something a bit more sophisticated)
