# fractional display

1. ### Formula to use fraction to set levels

Hi I want to make a point-based level system I'll have the data in a table displayed like this: 10 points 30 points 60 points and so on... but in the scoreboard will be displayed like this: level 1: 10/10 points level 2: 20/20 points (10 points from level 1 + 20 points of level 2) level 3...
2. ### Fraction Display

I'm having some rounding issues with fractions. Here is what excel is calculating: -5/16 + 5/7 = 2/5 I'm looking for the answer 45/112 Also, for the value 24.666667 excel is showing 24 2/3. I would like this to show 74/3.
3. ### Formating fractions in Excel

Hi, I know how to use the fraction format, but it displays the fraction as, for example,11 3/4, where the fraction (3/4) is displayed as the same font size as the integer, 11. What I want is for the fraction, 3/4, to be smaller font than the integer, 11, AND that the 3 be above the 4 not on the...

### This Week's Hot Topics

• Problem with Radio Button's format control
I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
• Last Display on userform to a Listbox
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
• Rename and move files to a new location
Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
• Help with True/False Formula
Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
• Clear extra characters from a provided range of cells
Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
• Help with Current and highest streaks
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...