Hi,
I'm looking for a formula to compare differences between two columns (A & B), so that it returns a comment - "No change" or "Difference" - in column C. But I would like the formula to return a blank (or a statement to say "Fine") if the value in column A is also blank. Essentially, I need to be able to ignore any data entries where a value was not previously held and so I don't need to consider these. At the moment, my formula in column C is =IF(EXACT(A2,B2), "No change", "Difference"), so it returns a value in column column regardless of what is in column A. I've tried wrapping IF statements, ISBLANK and even ISNUMBER around the formula but unable to get it to work.
The values in column A and B will always be numerical values, and limited to integers 1 to 10.
Many thanks !
I'm looking for a formula to compare differences between two columns (A & B), so that it returns a comment - "No change" or "Difference" - in column C. But I would like the formula to return a blank (or a statement to say "Fine") if the value in column A is also blank. Essentially, I need to be able to ignore any data entries where a value was not previously held and so I don't need to consider these. At the moment, my formula in column C is =IF(EXACT(A2,B2), "No change", "Difference"), so it returns a value in column column regardless of what is in column A. I've tried wrapping IF statements, ISBLANK and even ISNUMBER around the formula but unable to get it to work.
The values in column A and B will always be numerical values, and limited to integers 1 to 10.
Many thanks !
