Excel formulas
Excel formulas
Has anyone successfully created fraction symbols that can be correctly used in an Excel (or similar) spreadsheet formula? I mean 1/4 + 1/4 = 1/2 etc. I'm probably thinking way over my head here but is it possible?
-
- Top Typographer
- Posts: 1360
- Joined: Wed Oct 01, 2003 1:19 pm
- Location: North Dallas, Texas
I don't think it would work. Yes, you can create fraction glyphs -- in fact there are a whole bunch of them already defined in Unicode
I would bet all other forms of numbers or digits (e.g., Roman numerals, ) wouldn't work in Excel either such as:
They would not be treated as numerators with denominators but as symbols, like A,B,C,D,E.00BC VULGAR FRACTION ONE QUARTER
00BD VULGAR FRACTION ONE HALF
00BE VULGAR FRACTION THREE QUARTERS
2153 VULGAR FRACTION ONE THIRD
2154 VULGAR FRACTION TWO THIRDS
2155 VULGAR FRACTION ONE FIFTH
2156 VULGAR FRACTION TWO FIFTHS
2157 VULGAR FRACTION THREE FIFTHS
2158 VULGAR FRACTION FOUR FIFTHS
2159 VULGAR FRACTION ONE SIXTH
215A VULGAR FRACTION FIVE SIXTHS
215B VULGAR FRACTION ONE EIGHTH
215C VULGAR FRACTION THREE EIGHTHS
215D VULGAR FRACTION FIVE EIGHTHS
215E VULGAR FRACTION SEVEN EIGHTHS
215F FRACTION NUMERATOR ONE
I would bet all other forms of numbers or digits (e.g., Roman numerals, ) wouldn't work in Excel either such as:
However I've not tried it to confirm~!TAMIL NUMBER TEN
TAMIL NUMBER ONE HUNDRED
TAMIL NUMBER ONE THOUSAND
AEGEAN NUMBER ONE (1 thru 10, 20, etc.)
OLD PERSIAN NUMBER ONE (2, 10, 20, 100, etc)
MYANMAR DIGIT ZERO
KHAROSHTHI NUMBER 10
ETHIOPIC NUMBER 10
CIRCLED NUMBER 10
PARENTHESIZED NUMBER TEN
DIGIT ONE FULL STOP
NUMBER TEN FULL STOP
NEGATIVE CIRCLED NUMBER ELEVEN
DOUBLE CIRCLED DIGIT ONE
DINGBAT NEGATIVE CIRCLED NUMBER TEN
DINGBAT CIRCLED SANS-SERIF NUMBER TEN