Hello,
I have a column of 100 values in column P.
I need to get a value from these using =(1%*LN(P2))+(1%*LN(P3))+(1%*LN(P4))+(1%*LN(P5))....(1%*LN(P101))
Can i do this without manually entering every cell value?
Hello,
I have a column of 100 values in column P.
I need to get a value from these using =(1%*LN(P2))+(1%*LN(P3))+(1%*LN(P4))+(1%*LN(P5))....(1%*LN(P101))
Can i do this without manually entering every cell value?
Hi and welcome to the board
Try =SUMPRODUCT(0.01*LN(P2:P101))
Ahh SUMPRODUCT. Thank you
Another one a bit more complicated. The formula is:
(0.01(p2^0.5)/(0.5))+(0.01(p3^0.5)/(0.5)).....(0.01(p101^0.5)/(0.5))
Will this then be correct?
=SUMPRODUCT(0.01*(((P2:P101)^(0.5))/0.5))
Last edited by andersb; 05-12-2011 at 04:28 AM.
What is the point in multiplying then dividing by the same amount?
It is not multiplied by 0.5 it is raised to the power of 0.5. Then it is divided by 0.5
Ooops, that exp symbol shows badly on my screen ( exp .5 may also be replaced by SQRT function)
The formula seems OK
or join 0.01 / 0.5
=SUMPRODUCT(0.02*((P2:P101)^(0.5)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks