Problem posting in Excel Questions - formulas truncated
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Problem posting in Excel Questions - formulas truncated
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Sep 2008
    Location
    Houston, tx
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Problem posting in Excel Questions - formulas truncated

    Not sure where to get help on this?

    All of the sudden I can't post a formula without it getting truncated. This happens whether it is wrapped or not.
    Any ideas? Also tried compatibility mode with no help. Using ie8. THX

  2. #2
    Board Regular
    Join Date
    Sep 2008
    Location
    Houston, tx
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Problem posting in Excel Questions - formulas truncated

    Acutually, I just tried it in this forum and it works fine.

    Code:
    =IF(E8<C2*0.1,"True","False")
    If I try this in Excel Questions it comes out like this:

    [CODE]=IF(E8<

  3. #3
    Administrator starl's Avatar
    Join Date
    Aug 2002
    Location
    Everywhere!
    Posts
    5,846
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Problem posting in Excel Questions - formulas truncated

    put a space around any < and > characters
    those are html tags and since html is enabled in Excel Questions, but not here, it causes problems there.

  4. #4
    Board Regular
    Join Date
    Sep 2008
    Location
    Houston, tx
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Problem posting in Excel Questions - formulas truncated

    Quote Originally Posted by starl View Post
    put a space around any < and > characters
    those are html tags and since html is enabled in Excel Questions, but not here, it causes problems there.
    Hmm, okay, seems to work...makes the formula look funny, though

  5. #5
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    16,422
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Problem posting in Excel Questions - formulas truncated

    I believe you can also put your formula in the php tags (instead of code tags):
    PHP Code:
    =IF(E8<C2*0.1,"True","False"
    It also works to use HTML entities (if you enjoy the details involved):
    Code:
    =IF(E8&lt;C2*0.1,"True","False")

    Using: Office 2010/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

  6. #6
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    50,010
    Post Thanks / Like
    Mentioned
    52 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Problem posting in Excel Questions - formulas truncated

    Code tags usually work for me. I use them whenever I have the "greater than" or "less than" signs in formulas.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  7. #7
    Board Regular
    Join Date
    Sep 2008
    Location
    Houston, tx
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Problem posting in Excel Questions - formulas truncated

    The code tags have always worked for me. I was thinking the board was going through some changes and this might be temporary.
    You would think the code tags code handle displaying the code?

  8. #8
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    16,422
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Problem posting in Excel Questions - formulas truncated

    I'm going to say ixnay on hatnay (doesn't work in Test Forum, with HTML on):
    http://www.mrexcel.com/forum/test-he...ml#post3372682

    Using: Office 2010/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

  9. #9
    Administrator starl's Avatar
    Join Date
    Aug 2002
    Location
    Everywhere!
    Posts
    5,846
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Problem posting in Excel Questions - formulas truncated

    can you test with code tags again? I tried in Excel Questions earlier and it wasn't working for me

  10. #10
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    16,422
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Problem posting in Excel Questions - formulas truncated

    Doesn't work for me in Excel Questions either (without corrective measures such as spaces). That was always the case, AFAIC.

    Note: it's the less than sign that gets you in trouble, I think. Greater thans are okay.

    Using: Office 2010/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •