Displaying "<" in HTML

[Jerry Sullivan]

Hello,

I just noticed that a formula I posted displayed incorrectly because the "is less than" symbol is interpreted as a special character.

The code below should read ...B7 is less than symbol TODAY()....

=IF(AND(E7<>"Completed",B7<TODAY()),"Overdue","")

When I posted inside Code Tags, it read as:

=IF(AND(E7<>"Completed",B7),"Overdue","")

I'm puzzled why it seems to display as intended in this post, but not in the Excel Question Thread.

I've checked the BB Codes FAQ and wasn't able to find a reason.

Thanks!

 

[shg]

Put a space after it.

 

[Jerry Sullivan]

That works. Thanks shg.

 

[shg]

You're welcome. Dunno enough about HTML to know why the closing tag causes a problem.

 

[Peter_SSs]

I'm puzzled why it seems to display as intended in this post, but not in the Excel Question Thread.

It is (sometimes) interpreted as HTML code. However, that should never be a problem in this forum - have a look at the very bottom-left of this page to see the HTML setting for this forum.

 

[Jerry Sullivan]

Thanks Peter,
I was incorrect when I assumed this was an HTML code based forum.

The tip from shg to add a space works, but I'm still a little puzzled why the BB code interpreted my < as intended in this post above, but when I tried to post in my other thread it resolved this by removing the next expression.

Any idea why that would happen?

 

[Norie]

Surely the simplest way would be to use the HTML entity for less than.

<

Which I can't post the HTML for here because it converts it to <.

Maybe not then.

 

[Peter_SSs]

... but I'm still a little puzzled why the BB code interpreted my < as intended in this post above, but when I tried to post in my other thread it resolved this by removing the next expression.

Any idea why that would happen?

I already answered that ..

have a look at the very bottom-left of this page to see the HTML setting for this forum.

.. if you look there you will see that HTML is set to "Off" in this particular forum so it cannot be interpreted as HTML here.

Surely the simplest way would be to use the HTML entity for less than.

I disagree. If I am copying a formula from my sheet to a post the simplest thing to me is to enter a space.

 

[Jerry Sullivan]

Norie, I'll keep that as an option. I found a list of HTML entities to get around that dilemna.

http://www.w3schools.com/html/html_entities.asp

My post that originally had the problem use MrExcel's HTML Maker to capture a range and its formula.
Interestingly, when I did subsquent posts in code tags (without HTML Maker) it continued to use the HTML interpretation.

I'll use the space when applicable and the entity code if necessary.

Thank you all!

 

[Peter_SSs]

Interestingly, when I did subsquent posts in code tags (without HTML Maker) it continued to use the HTML interpretation.

The issue seems intermittent ..

It is (sometimes) interpreted as HTML code.