This is (part of) my formula:
But if a cell included in the formula have cell value = blank (or even "0") , it won't calculate the difference between cells correct (I'm trying to show development in turnaround up/down) .
Is there a way to change this formula to calculate correct on cell value = blank or "0"?
And by the way; when I try to paste the complete formula into the thread message, with all my 4 statements, part of the formula disappear, even when it's wrapped in code-tags. What is that all about?
Code:
=IF(data1!J310>data1!J311,"J")
But if a cell included in the formula have cell value = blank (or even "0") , it won't calculate the difference between cells correct (I'm trying to show development in turnaround up/down) .
Is there a way to change this formula to calculate correct on cell value = blank or "0"?
And by the way; when I try to paste the complete formula into the thread message, with all my 4 statements, part of the formula disappear, even when it's wrapped in code-tags. What is that all about?