Is the cell the result of a calculation? If so, then you can use an IF function for that. For instance, if the cell is the result of A1+B1 then you could do IF(A1+B1<1, "ABC", A1+B1) so any value greater than 1 is shown, otherwise the text "ABC."
If not, another way to do it would be to keep the real value in a cell and put the "result" in another cell. So if D30 holds the value, then E30 could be IF(D30<1, "ABC", D30). Then maybe make E30 bold or with a border or background color to highlight it as your result.
Nathan B
5 years ago
I used column A as the display column and column B as actual results then hide column B.
Thanks!
Is the cell the result of a calculation? If so, then you can use an IF function for that. For instance, if the cell is the result of A1+B1 then you could do IF(A1+B1<1, "ABC", A1+B1) so any value greater than 1 is shown, otherwise the text "ABC."
If not, another way to do it would be to keep the real value in a cell and put the "result" in another cell. So if D30 holds the value, then E30 could be IF(D30<1, "ABC", D30). Then maybe make E30 bold or with a border or background color to highlight it as your result.
I used column A as the display column and column B as actual results then hide column B.
Thanks!