Results 1 to 9 of 9
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Need Special Characters In Formulas (97)

    I want to write a formula to display statistical results. For example, if cell B1 calculates the left side of a mean confidence interval and cell B2 the right, then I could display the confidence interval using the formula:

    =B1&" <= u <= "&B2

    Only I want to use the less than or equal symbol and the mue symbold rather than the ones shown here.

    I can figure out how to do that when the symbols are all available in Times New Roman (or any single font) as they are in this example. However, that is not always the case. For example, to do a chi-square confidence interval, I need the less than or equal, chi-square, and squared two symbols and no font (on my machine) has all these symbols.

    To make it a little more complex, I want to be able to share the resulting worksheets with my students, who may not have exactly the same fonts on their machines as I do so I need to stick to the very basic fonts.

    Any suggestions?
    Ronny
    Ronny Richardson

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Need Special Characters In Formulas (97)

    Can you post pictures of these symbols? Mu (0109), less-than-or-equal-to (0163) and chi (0099) characters are in Symbol, which all Windows users should have. Square will have to come from another font, all users should have Arial, TimesNR and MS Sans-serif. I'm not familiar "squared two"?
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    California
    Posts
    106
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Need Special Characters In Formulas (97)

    A very simple method for >= or <= is to type just > or < and apply the underline format to the cell. I'm afraid I don't have a solution for the other symbols.
    Thanks,
    Caroline in lala-land

  4. #4
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    Sault Ste. Marie, Michigan, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Need Special Characters In Formulas (97)

    Ronny,

    Take a look at this macro which was written to help create math equations in Excel It uses special code characters in your equation to convert text to super, sub, italic, or characters from the Symbol font. You could probably customize it to suit your needs.

    http://www.wopr.com/cgi-bin/w3t/showthread...amp;Main=128269

    As it stands it doesn't run on cells with formulas. but if you disable that line it will run and convert the formula to a value.


    Regards
    Ken

  5. #5
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Re: Need Special Characters In Formulas (97)

    What I meant by two squared was the tiny two in the top half of the frame that some fonts offer.

    Ronny
    Ronny Richardson

  6. #6
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Re: Need Special Characters In Formulas (97)

    This will not work in a formula since you are not allowed to format individual characters in a formula.
    Ronny Richardson

  7. #7
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Re: Need Special Characters In Formulas (97)

    This approach will not work for me as I need the formulas to remain dynamic, not be converted to text strings.

    Ronny
    Ronny Richardson

  8. #8
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Need Special Characters In Formulas (97)

    I can't find a simpler way to do this (which only means -I- can' find a simpler way) so following on Rory's <!post=Post,118796>Post<!/post> attached is a PKZipped WB containing all the Unicodes which will display in XL 97, and functions for the characters you need to display. Note that they may not print.
    Attached Files Attached Files
    -John ... I float in liquid gardens
    UTC -7ąDS

  9. #9
    New Lounger
    Join Date
    May 2002
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Need Special Characters In Formulas (97)

    Could you do it by using 3 cells rather than 1?
    e.g. put the first value, right-aligned, in J1, the chi squared or whatever, centre-aligned and formatted using whatever fonts are available in K1 and the second value, left-aligned, in L1

Posting Permissions

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