I am using "" for the value_if_false in a formula, and as expected the cell appears empty when the logical test is false. However, in the case of the cell to the left of being true, the text in the that cell is truncated. It appears as if Excel is reading the false cell to have something in it. Any suggestions?
IF(logical_test,value_if_true,value_if_false)
Bookmarks