| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| 2 Nesting questions | Excel Worksheet Functions | |||
| IF/AND Formula seems to only be reading 1st part of formula | Excel Worksheet Functions | |||
Linear Mode
