Add one part of a formula to another
 

Hi. 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 = 7.59
B1 = 0.27
C1 = 0.12

I want the answer 10.80, at the moment I have the answer 1.16 with this
formula

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

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

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

Add one part of a formula to another
 

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


"Darren" wrote:

Hi. 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 = 7.59
B1 = 0.27
C1 = 0.12

I want the answer 10.80, at the moment I have the answer 1.16 with this
formula

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

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

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

Add one part of a formula to another
 

Try this:

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

Returns: 10.7960160000000

If you format as NUMBER 2 decimal places the result will *APPEAR* as 10.80
but the true underlying value will still be 10.7960160000000.

If you want the absolute value of 10.80:

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

Format as NUMBER 2 decimal places

Biff

"Darren" wrote in message
ps.com...
Hi. 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 = 7.59
B1 = 0.27
C1 = 0.12

I want the answer 10.80, at the moment I have the answer 1.16 with this
formula

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

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

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

Add one part of a formula to another
 

Great! Thanks, much appreciated!

Biff wrote:
Try this:

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

Returns: 10.7960160000000

If you format as NUMBER 2 decimal places the result will *APPEAR* as 10.80
but the true underlying value will still be 10.7960160000000.

If you want the absolute value of 10.80:

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

Format as NUMBER 2 decimal places

Biff

"Darren" wrote in message
ps.com...
Hi. 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 = 7.59
B1 = 0.27
C1 = 0.12

I want the answer 10.80, at the moment I have the answer 1.16 with this
formula

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

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

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

Add one part of a formula to another
 

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

Just a different version:

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

--
Dana DeLouis


"Darren" wrote in message
ups.com...
Great! Thanks, much appreciated!

Biff wrote:
Try this:

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

Returns: 10.7960160000000

If you format as NUMBER 2 decimal places the result will *APPEAR* as
10.80
but the true underlying value will still be 10.7960160000000.

If you want the absolute value of 10.80:

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

Format as NUMBER 2 decimal places

Biff

"Darren" wrote in message
ps.com...
Hi. 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 = 7.59
B1 = 0.27
C1 = 0.12

I want the answer 10.80, at the moment I have the answer 1.16 with this
formula

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

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

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

Add one part of a formula to another
 

Thanks

Dana DeLouis wrote:
=(A1*B1+A1)+(A1*B1+A1)*C1

Just a different version:

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

--
Dana DeLouis


"Darren" wrote in message
ups.com...
Great! Thanks, much appreciated!

Biff wrote:
Try this:

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

Returns: 10.7960160000000

If you format as NUMBER 2 decimal places the result will *APPEAR* as
10.80
but the true underlying value will still be 10.7960160000000.

If you want the absolute value of 10.80:

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

Format as NUMBER 2 decimal places

Biff

"Darren" wrote in message
ps.com...
Hi. 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 = 7.59
B1 = 0.27
C1 = 0.12

I want the answer 10.80, at the moment I have the answer 1.16 with this
formula

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

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

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