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(S5U6, "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.

momma2all wrote:
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(S5U6, "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.

Hi there,

Try removing the quotes:
IF(S5U6,S5,IF(S5U6,U6))

Or even
IF(S5U6,S5,U6)

Or perhaps
MAX(S5,U6)

IF(S5U6,"S5", IF(S5U6, "U6"))

To answer your question:

Remove the quotes:

IF(S5U6,S5,IF(S5U6,U6))

The only time you need quotes is when you have hardcoded text:

=IF(A1="Yes","A1 equals Yes","A1 does not equal Yes")

=IF(A110,"A1 is less than 10","A1 is not less than 10")

Now, there'a "black hole" in your logic! What if S5=U6? You haven't
accounted for that possibility. If S5=U6 then your formula would return
FALSE.

Maybe this is what you want:

=MAX(S5,U6)

--
Biff
Microsoft Excel MVP


"momma2all" wrote in message
...
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(S5U6, "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.

It never donned on me to use a MAX statement - I guess I have been working
ont his thing too long today! Thanks for all your help!!

"T. Valko" wrote:

IF(S5U6,"S5", IF(S5U6, "U6"))

To answer your question:

Remove the quotes:

IF(S5U6,S5,IF(S5U6,U6))

The only time you need quotes is when you have hardcoded text:

=IF(A1="Yes","A1 equals Yes","A1 does not equal Yes")

=IF(A110,"A1 is less than 10","A1 is not less than 10")

Now, there'a "black hole" in your logic! What if S5=U6? You haven't
accounted for that possibility. If S5=U6 then your formula would return
FALSE.

Maybe this is what you want:

=MAX(S5,U6)

--
Biff
Microsoft Excel MVP


"momma2all" wrote in message
...
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(S5U6, "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.

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"momma2all" wrote in message
...
It never donned on me to use a MAX statement - I guess I have been working
ont his thing too long today! Thanks for all your help!!

"T. Valko" wrote:

IF(S5U6,"S5", IF(S5U6, "U6"))

To answer your question:

Remove the quotes:

IF(S5U6,S5,IF(S5U6,U6))

The only time you need quotes is when you have hardcoded text:

=IF(A1="Yes","A1 equals Yes","A1 does not equal Yes")

=IF(A110,"A1 is less than 10","A1 is not less than 10")

Now, there'a "black hole" in your logic! What if S5=U6? You haven't
accounted for that possibility. If S5=U6 then your formula would return
FALSE.

Maybe this is what you want:

=MAX(S5,U6)

--
Biff
Microsoft Excel MVP


"momma2all" wrote in message
...
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(S5U6, "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.