View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SarahN SarahN is offline
external usenet poster
 
Posts: 25
Default Adding Fractions and Displaying as a percentage.

Hi,

I am trying to add a number of Fractions and then display as a percentage.
Does anyone know a formula that will automatically add a number of cells and
display the total as a percentage?



4/4 4/4 3/3 2/2 2/2 = 100%
4/4 4/4 3/4 2/2 2/2 = ?


Thanks heaps in advance.