Hi guys,
I have a graph line that shows zero's for future quarters, I want to remove them for the green line. Formatting the cell in any way doesn't fix the issue, it's sees the cell as a value zero.
The only way is to make the future values #N/A, that fixes the issue. But the formula is very long and I would like to avoid repeating the IF statement, is there any way I can let the formula evaluate itself without repeating the IF statement and without using a helper cell?
I have a graph line that shows zero's for future quarters, I want to remove them for the green line. Formatting the cell in any way doesn't fix the issue, it's sees the cell as a value zero.
The only way is to make the future values #N/A, that fixes the issue. But the formula is very long and I would like to avoid repeating the IF statement, is there any way I can let the formula evaluate itself without repeating the IF statement and without using a helper cell?