View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dana DeLouis Dana DeLouis is offline
external usenet poster
 
Posts: 947
Default 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?