IF Statement help

[crhoftender]

I need some help with an IF statement. I am checking a code vs another code cell. The appears ###/####. What I want the formula to check if the referencing cell is <= to other, and then return one of the respective text strings I enter for true and false. I believe the issue I am having is the '/' that is part of the code. I need it to check both sides of the '/'.

Is this possible? The codes are dates so Jan, 2014 would be 001/2014.

To further complicate this - there will be a large portion that would a text string that would require a value to be returned

 

[AnAnalyst]

Hi, and welcome.

I'm not entirely clear exactly what you're after, but this could be a starting point for you:

Cells A1 and B1 contain strings formatted as ###/#### which are to be compared.

The following formula will convert the strings to datevalues for easy comparison:

=IF(DATEVALUE(RIGHT(A1,4)&"-"&MID(A1,2,2)&"-01")<=DATEVALUE(RIGHT(B1,4)&"-"&MID(B1,2,2)&"-01"),"A1<=B1","A1>B1")

 

[martindwilson]

slightly shorter
=IF(SIGN(RIGHT(A1,7)-RIGHT(B1,7))<=0,"a1<=b1","a1>b1")

 

[crhoftender]

Thanks, these were helpful. I was able to get a text string that I could compare with a simple formula.