Less Than symbol causing me problems.

DavidCoop

Board Regular
Joined
Sep 17, 2013
Messages
226
Greetings!

I have just had considerable difficulty posting a formula which contained the LESS THAN symbol. Everything after the symbol was ignored, so the formula was only half complete.

Any idea why, and how to resolve? (I ended up posting LT and told the OP to change it).

Regards, David:confused:
 
Hi,
the less than symbol is part of the html markup language. Simplest is when using these symbols to enclose in the php tags. There are other workarounds but that's my goto.

example:
PHP:
my post with < and > signs
 
Last edited:
Thanks for your reply, but I don't know what a php tag is or how to apply is (or turn it off for that matter).

Would you please give a little bit more detail?
 
[PHP ]Your formula here![/PHP ]
If you remove spaces just before square brackets in above line then you get following result.
PHP:
Your formula here!

When you reply using Quick Reply option, there is a button "Go Advanced" [Next "Post Quick Reply"]. Here you'd get more options and one of them is php code posting which does it with click of button.

Or you can ask OP to remove space:
=MATCH(C2,$E$7:$E$15,0) <MATCH(B2,$E$7:$E$15,0)
 
Just surround the < symbol with spaces

=A1 < B1
 
Just surround the < symbol with spaces

=A1 < B1

This is the other "goto" :)

check your settings, under general settings, what is your message editor interface setting?
 

Forum statistics

Threads
1,221,545
Messages
6,160,446
Members
451,646
Latest member
mmix803

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top