I'm trying to accomplish something in Excel (latest version), I've googled for a while now, but probably I'm describing the problem not accurately enough.

I want to perform a calculation in Excel:

Known value A: 100 Known value B: 1.4

I want achieve do the following: (A * B) ((Result of A * B) * B) ((Result of ABB) * B)

The calculation steps behind this would be:

1. 100 * 1.4 = 140
2. 140 * 1.4 = 196
3. 196 * 1.4 = 274.4
4. = 140 196 274.4 = 610.4

I can easily do this using 4 cells, but I was wondering if there is a way to do this with 1 formula? I've experimented with the LET function, but can't seem to achieve it with this function.

Any help would be greatly appreciated!

Thanks!

CodePudding user response：

Using LET:

=LET(x,A1*B1,
     y,x*B1,
     z,y*B1,
     SUM(x,y,z)
    )

If you don't have the LET function, other methods:

=SUM(A1*B1^{1,2,3})
=SUMPRODUCT(A1*B1^{1,2,3})