'Less Than' symbol problems - Solved

[pbornemeier]

I was attempting to answer a post with a formula that contained a less than symbol and my formula was truncated. I originally posted with code tags then tried code and noparse tags then noparse alone and got the same result each time:

=IF(H3=YEAR(NOW()),"OK",IF(DATE(YEAR(F3)+3,MONTH(F3)-3,DAY(F3))<NOW(),"DUE","NOT DUE"))

=IF(H3=YEAR(NOW()),"OK",IF(DATE(YEAR(F3)+3,MONTH(F3)-3,DAY(F3)) LT NOW(),"DUE","NOT DUE"))

Replace LT with the less than symbol

It worked for this post, but when I tried it here: http://www.mrexcel.com/forum/newreply.php?do=postreply&t=434154 the formula was truncated at the <

Just got the answer - leave a space at the open end of the < and > symbol - Otherwise it is sometimes interpreted as an html item.

 

[Jon von der Heyden]

or use the php tag

<hello>

But I have had to edit something and when you go back I think with the php tags it is truncated when editing, but can't remember exactly.

lets see...

 

[schielrn]

or use the php tag

<hello>

But I have had to edit something and when you go back I think with the php tags it is truncated when editing, but can't remember exactly.

But of course you can't replicate it in here, since html is disabled.

 

[Jon von der Heyden]

But of course you can't replicate it in here, since html is disabled.

oh I see...

 

[schielrn]

To the test forum I go...

See issue here:

http://www.mrexcel.com/forum/showthread.php?t=436606

 

[SydneyGeek]

Another option is to use the HTML code for less than. It's & lt ; (but without any spaces)

Denis