| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding fractions and displaying as Percentages
Hi,
I have a question. I am stuck with I am trying to add a number of Fractions and then Display as a Percentage. Does anyone have a formula for this that works? 4/4 4/4 3/3 2/2 2/2 = 100% 4/4 4/4 3/4 2/2 2/2 = 94% ? Is there a way that excel can automatically calculate this? Thanks heaps |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding fractions and displaying as Percentages
Just to add to this. they are not true fractions. It is really using 4 out of
4. 3 out of 4 etc. I hope this makes sense. and that someone can help "SarahN" wrote: Hi, I have a question. I am stuck with I am trying to add a number of Fractions and then Display as a Percentage. Does anyone have a formula for this that works? 4/4 4/4 3/3 2/2 2/2 = 100% 4/4 4/4 3/4 2/2 2/2 = 94% ? Is there a way that excel can automatically calculate this? Thanks heaps |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding fractions and displaying as Percentages
Check out your post @ Worksheet Functions. There is no need to multi-post..
-- Jacob (MVP - Excel) "SarahN" wrote: Just to add to this. they are not true fractions. It is really using 4 out of 4. 3 out of 4 etc. I hope this makes sense. and that someone can help "SarahN" wrote: Hi, I have a question. I am stuck with I am trying to add a number of Fractions and then Display as a Percentage. Does anyone have a formula for this that works? 4/4 4/4 3/3 2/2 2/2 = 100% 4/4 4/4 3/4 2/2 2/2 = 94% ? Is there a way that excel can automatically calculate this? Thanks heaps |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining 2 percentages into one cell and displaying as % format | Excel Worksheet Functions | |||
| Adding Fractions of a Second | Excel Worksheet Functions | |||
| displaying fractions in a concatenate formula | Excel Discussion (Misc queries) | |||
| Entering and displaying fractions | Excel Worksheet Functions | |||
| Coversion Of Fractions To Percentages | Excel Discussion (Misc queries) | |||
Hybrid Mode
