From: SarahN on 28 Apr 2010 23:56 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. From: Jacob Skaria on 29 Apr 2010 00:38 Try this UDF (User Defined function). From workbook launch VBE using Alt+F11. From menu Insert a Module and paste the below function.Close and get back to workbook and try the below formula. =EVAL(A1:E1) and format the formula cell to % Function Eval(rngTemp As Range) As Variant Dim cell As Range For Each cell In rngTemp Eval = Eval + Evaluate("=" & cell.Text) Next Eval = Eval / rngTemp.Count End Function -- Jacob (MVP - Excel) "SarahN" wrote: > 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. > >  |