Formulas getting truncated

respree

Active Member

Joined

Apr 14, 2003

Messages

258

• Mar 8, 2007

• #1

Hi all:

When I post a long formula, it seems to be getting cut off.

I've been using the

Code:

 tag (and that seems to fix the problem), but am wondering if there is something else I should be using instead.

 

Von Pookie

MrExcel MVP

Joined

Feb 17, 2002

Messages

13,686

• Mar 8, 2007

• #2

Formulas sometimes get cut off if they contain either < or >. As far as I can figure, the board interprets this as the beginning of an HTML tag, so things from that point get cut off--but they are still in the post.

Using the code tags around the formula should work or you can try adding a space after a < symbol or before a > symbol.

 

respree

Active Member

Joined

Apr 14, 2003

Messages

258

• Mar 8, 2007

• #3

Must have something to do with the forum software.

Oddly, you just posted < > and nothing got cut off. Dunno.

Thanks for the advice.

 

Von Pookie

MrExcel MVP

Joined

Feb 17, 2002

Messages

13,686

• Mar 8, 2007

• #4

My post had the < > with spaces around them

Code tags: this should be ok:

Code:

=IF(A1<B2,1,0)

Space after the < symbol: this should be ok:
=IF(A1< B2,1,0)

Formula w/out using code tags and with no space after < symbol: this will be cut off:
=IF(A1<B2,1,0)

 

Norie

Well-known Member

Joined

Apr 28, 2004

Messages

76,377

Office Version

1. 365

Platform

1. Windows

• Mar 8, 2007

• #5

respree

I think Kristy is right about the HTML tag thing.

One solution is using code tags, and I think it's a good one for 2 reasons.

1 You can easily see the formula.

2 You can easily copy it. (Well I can with Firefox)

 

respree

Active Member

Joined

Apr 14, 2003

Messages

258

• Mar 8, 2007

• #6

Thanks for the additional comments, guys. I think I'll use the code tags from now on.

 

erik.van.geit

MrExcel MVP

Joined

Feb 1, 2003

Messages

17,832

• Mar 9, 2007

• #7

Hi , all,


TIPS:
1. to select the entire contents of the code, you can control+click

2. when you suspect there is some information missing "on display" within a post, just click "quote" to see the entire contents
=IF(A1<B2,1,0)

so click "quote" to see more of the above formula: you will see B2,1,0) after the < - sign

kind regards,
Erik