View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default 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?