I am currently trying to use Excel to calculate a finite series using one cell as a constant and another cell as the maximum variable going from 0 to that cell. I am not sure if this is the right place to ask but I have tried everything. Here is the command I am trying to get (I will explain as best I can).
F(x) = Sum (n=0,C1) of A1*(100)*n
The closest thing I found was a power series (SERIESSUM) but that is not a finite series and not what I'm looking for. I am trying to use Excel for a new business I started and using this formula for projection caculations based off a range of scenarios but I can't seem to find the right command. Can anyone out there help me? If this is the wrong forum, where would I go to get that information? Is it even possible? Thx!