Adding fractions and displaying as Percentages

  • Thread starter Thread starter SarahN
  • Start date Start date
S

SarahN

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
 
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
 
Back
Top