Incrimental Multiplication

[saltkev]

Good Morning

I wonder can anyone help. I hope I can explain my needs properly.

I am looking for a non VBA solution.

I have 2 Numbers lets say 2 & 4 in cells A1 & B1, I need to incrimentally multiply the value of A1 (2) , 4 times or the value of B1. & total all into lets say C1 (All Calculations in one Cell)


1 * 2 = 2
2 * 2 = 4
3 * 2 = 6
4 * 2 = 8

Value for C1 would be 20


thanks very much

Saltkev

 

[pgc01]

Hi Saltkev

Not sure I understood correctly, but try:

=A1*B1*(B1+1)/2

 

[saltkev]

Top Job

Many Thanks

regards

Kev