I want to make cells have no value, so that a formula only applies to them when the cell has been typed into (0,1 ect)
The formula in question displays a zero value if cell x is greater than y, a 3 if y is greater than x, and a 1 if they are equal. Like this:
=IF(A1>B2,3,IF(A1=B2,1,0))
Currently, A1 and B2 are both blank, so I would like cell in question to also be blank. However, because A1 and B2 are equel, the cell is displaying a "1".
If A1 and B1 are both "0", then I would like a "1" displayed. However, I only want the cells to become active when a value is typed in (including typing the value 0)
Bookmarks