Just tried again. I did have to amend the above formula to show as AC3 rather than just AC.
It did not show "#NAME?" this time. But showed "NC" which is strange as all the cells mentioned in the formula have the value of 0, so it should be showing "FC".
|