I am using the same formula format in 64 cells, they all return the correct
results except for one. The format is identical, refferanced cells are
correct in ID and contents.

There is no explination why the results are different in this one instance,
I would like to see which of the eight "IF" formulas in the cell is coming up
true and therefore displaying this result so I can further trace possible
causes, but I can not find a way for the active formula it to show itself by
becoming highlighted (or something).