I have attached a worksheet wherein i have given an example of the calculation and in that there is a formula in Column E starting from E8 and down. I want to understand that what does this formula calculate. (not giving here more description of the question as it can be understood from the attached file)
Please assist.
----
excel_learner
(Using XL 2007 & 2010)
-------Learning never stops!
I can not understand your problem, the formula is very simple
I want to understand in simple words what does it calculate.. Is it average or something else
Last edited by bakerman; 12-26-2013 at 11:02 PM. Reason: No need to Quote when directly answering to previous post
----
excel_learner
(Using XL 2007 & 2010)
-------Learning never stops!
a=10
the formula is 10*11/2 = 55
it's not an average, but you only have to know the goal of your file
The formula is this... =D8*(D8+1)/2 I do not know how it fits into the data in the workbook, but that is the formula for the sum of the first N digit where cell D8 contains the value for N. So, for example, if D8 contained the number 5, then the formula would evaluate to this...Originally Posted by excel_learner
The sum of the first 5 digits is 15 (=1+2+3+4+5). This will work for any positive value N in cell D8.Code:=5*(5+1)/2 =5*6/2 =5*3 =15
Last edited by Rick Rothstein; 12-27-2013 at 02:01 PM.
Posting Permissions
Reply With Quote
Bookmarks