Results 1 to 9 of 9

20020524, 16:22 #1
 Join Date
 Jan 2001
 Location
 Atlanta
 Posts
 571
 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 chisquare confidence interval, I need the less than or equal, chisquare, 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?
RonnyRonny Richardson

20020524, 17:13 #2
 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), lessthanorequalto (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 Sansserif. I'm not familiar "squared two"?
John ... I float in liquid gardens
UTC 7ąDS

20020524, 21:55 #3
 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 lalaland

20020525, 04:11 #4
 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/cgibin/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

20020526, 22:42 #5
 Join Date
 Jan 2001
 Location
 Atlanta
 Posts
 571
 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.
RonnyRonny Richardson

20020526, 22:43 #6
 Join Date
 Jan 2001
 Location
 Atlanta
 Posts
 571
 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

20020526, 22:44 #7
 Join Date
 Jan 2001
 Location
 Atlanta
 Posts
 571
 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.
RonnyRonny Richardson

20020528, 15:56 #8
 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.
John ... I float in liquid gardens
UTC 7ąDS

20020529, 06:39 #9
 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, rightaligned, in J1, the chi squared or whatever, centrealigned and formatted using whatever fonts are available in K1 and the second value, leftaligned, in L1