Posting problem?

[Domski]

Is there a problem with the board at the moment?

I had to edit my last post a few times until it would display the formula correctly.

I've noticed a couple of other posts that don't seem to be displaying correctly.

Dom

 

[BrianB]

I have never had any real probs with this forum.
suggest your computer or local inernet is faulty (?)

This line is an edit addition to the message.

 

[Domski]

Possibly.

It seems to be a problem when I include a < sign directly after a cell ref.

This works:

=IF($A1<$A2,"Message","")

But without the $ this is all that appears:

=IF(A1<A2,"Message","")

I guess it's an HTML problem but not knowing anything about it I'm not sure.

Dom

 

[Von Pookie]

Yes, it's an HTML issue (i.e., the board is interpreting the greater than/less than signs as an HTML tag). The easiest way to get around it is to put your entire formula within code tags.

=IF(A1<A2,"Message","")

 

[Domski]

I understand, thanks.

 

[Mark W.]

Another way around this problem is enter a space character after the less than sign as shown below...

=IF($A1< $A2,"Message","")