Prev: Record time by formula
Next: Adding data from multiple cell and linking to a new worksheet
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.
>
>
 | 
Pages: 1
Prev: Record time by formula
Next: Adding data from multiple cell and linking to a new worksheet