Forum formula problem

[Matt Rogers]

Hi all.

Why is the formula cut off?

Original:
1. Formula is
= AND (A4 = "Trump", B3 < B4 )

Forum without spaces:
1. Formula is
=AND(A4="Trump",B3

Look here #14
http://www.mrexcel.com/forum/excel-...-first-match-2-values-different-ranges-2.html

Or here #7
http://www.mrexcel.com/forum/excel-questions/975126-help-conditional-formatting.html

 

[gaz_chops]

The forum does not like < can't remember the reason! You just need a space either side of " < "

 

[Peter_SSs]

I've moved your question to the About This Board forum, since it wasn't an excel question. There is a sticky at the top of this forum re that issue or See here, particularly post #5 for more details.

 

[MARK858]

The reason is the forum reads a < followed by a letter as an HTML tag and the forum does have a sticky about it at the top of this board.

http://www.mrexcel.com/forum/about-board/680917-formulas-not-appearing-completely-read.html

Oops, sorry Peter has covered this... going blind

 

[Matt Rogers]

Many thanks, it's ok.
I was too stupid.