Add one part of a formula to another

D

Darren

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?
 
B

Biff

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
 
D

Darren

Great! Thanks, much appreciated!
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
Click to expand...
 
Top