Add one part of a formula to another

[darrentaylor60]

New to this so please bare with me. I知 trying to use excel to calculate some margins. I知 struggling with how to sum part of a formula, not sure if this is possible to do in an excel cell... example

A1 = 2
B1 = 0.5
C1 = 5

I want the answer 18, at the moment I have the answer 15 with this formula

=(((A1*B1)+A1)*C1)

((A1*B1)+A1) = 3
*C1 = 15

but how do I then add these to outputs, using the formula in one cell?

[Bryan Hessey]

New to this so please bare with me. I’m trying to use excel to calculate some margins. I’m struggling with how to sum part of a formula, not sure if this is possible to do in an excel cell... example

A1 = 2
B1 = 0.5
C1 = 5

I want the answer 18, at the moment I have the answer 15 with this formula

=(((A1*B1)+A1)*C1)

((A1*B1)+A1) = 3
*C1 = 15

but how do I then add these to outputs, using the formula in one cell?

=(((A1*B1)+A1)*(C1+2*B1))

or

=((A1*B1+A1)*(C1+A1*B1))

or

=(C1-A1)*(C1+A1*B1)

---

[darrentaylor60]

Thanks for the response, however, your solution only works for the examples I gave, perhaps they were too simplistic. I知 not looking for the specific answer to those numbers but the formula solution.

If I replace the numbers

A1 = 7.59
B1 = 0.27
C1 = 0.12

The answer should be 10.80

Your formulas calculate as:
=(((A1*B1)+A1)*(C1+2*B1)) = 6.36
=((A1*B1+A1)*(C1+A3*B1)) = 20.91
=(C1-A1)*(C1+A1*B1) = -16.20

?

[Bryan Hessey]

Thanks for the response, however, your solution only works for the examples I gave, perhaps they were too simplistic. I知 not looking for the specific answer to those numbers but the formula solution.

If I replace the numbers

A1 = 7.59
B1 = 0.27
C1 = 0.12

The answer should be 10.80

Your formulas calculate as:
=(((A1*B1)+A1)*(C1+2*B1)) = 6.36
=((A1*B1+A1)*(C1+A3*B1)) = 20.91
=(C1-A1)*(C1+A1*B1) = -16.20

?

as

=((A1*B1)+A1)+((A1*B1)+A1)*C1

---

[darrentaylor60]

Great! Thanks, much appreciated!