Sep 13 2021 05:09 AM
Here's an easy one for you experts
I want to find the best Excel function to accomplish the following:
The baseline number in my calculation is: 9
I want to increase 9 by .5 each month for 12 months (I.e. (9+.5)+(9+.5+.5)+(9+.5.+.5+.5), etc.
I'm a Windows 10 user and have the latest version of Excel.
Thank you!
George
Sep 13 2021 05:37 AM
That's a mathematics problem. You want to calculate the sum of 12 times 9 and (1+2+...+12) times 0.5
In general, the sum 1+2+...+n is COMBIN(n+1,2) = (n+1)*n/2, so 1+2+...+12 = 13*12/2.
The result you want is
=12*9+13*12/2*0.5
It can also be written as
=12*9+COMBIN(13,2)*0.5
Sep 13 2021 05:47 AM - edited Sep 13 2021 05:48 AM
SolutionSep 13 2021 08:35 AM
Thank you both for providing alternative approaches to my calculation! I appreciate your responses. Additionally, I learned some new Excel strategies.
Have a good day...
George Stoffel
Sep 13 2021 11:56 AM
Sep 13 2021 12:28 PM
Sep 13 2021 05:47 AM - edited Sep 13 2021 05:48 AM
Solution