View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
momma2all momma2all is offline
external usenet poster
 
Posts: 2
Default 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.