Help with IF statement
I am trying create the following statement - however I want the value of the
cell to appear not the cell position:
IF(S5U6,"S5", IF(S5<U6, "U6"))
the values in in the cells are dates; hoever, when I enter the statement the
cell populates as S5 or U6 not the date that is formatted in the appropriate
cell.
|