Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions |