percentage calculation
Il 14/10/2012 04:54, sumesh56 ha scritto:
thanks a lot for both Isabella and Plinius for the reply. very happy to
find that both the formulas works for me. but can u plz explain where
was the text occured in between the numbers which caused for the error?
+-------------------------------------------------------------------+
+-------------------------------------------------------------------+
Removing unnecessary brackets, your formula is:
=SUM(E4:E35/32)/90*100
E4:E35 is not a single value dividing by 32 but a matrix, therefore it
is a matricial formula and can work correctly only if confirmed by
CONTROL+SHIFT+RETURN
Hi,
E.
|