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.

Help with IF statement
 

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(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.

Hi there,

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

Or even
IF(S5U6,S5,U6)

Or perhaps
MAX(S5,U6)

Help with IF statement
 

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

To answer your question:

Remove the quotes:

IF(S5U6,S5,IF(S5<U6,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(A1<10,"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(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.

Help with IF statement
 

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(S5<U6, "U6"))

To answer your question:

Remove the quotes:

IF(S5U6,S5,IF(S5<U6,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(A1<10,"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(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.

Help with IF statement
 

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(S5<U6, "U6"))

To answer your question:

Remove the quotes:

IF(S5U6,S5,IF(S5<U6,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(A1<10,"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(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.