Forum Discussion
awd1963
Aug 28, 2023Copper Contributor
How to ignore inputs when looking for data in a table
Hi, I've never seen this before and can't work out why it is happening. The numbers in red text are incorrect based on 428 x £38.31 or 428 x £35.04. The error sorts itself out if the sum of B2*C2 is changed to a manual entry of the same value.
Does anyone have any ideas on why this could be happening? The number formats for the cells are correct.
2 Replies
Sort By