LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find value in array Brook6 Excel Worksheet Functions 26 January 30th 07 09:40 PM
Reusing formula Tony29 Excel Discussion (Misc queries) 7 September 7th 06 03:34 AM
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM
2 Nesting questions Starchaser Excel Worksheet Functions 7 January 20th 06 06:53 PM
IF/AND Formula seems to only be reading 1st part of formula Greg Bobak Excel Worksheet Functions 2 March 3rd 05 01:53 AM


All times are GMT +1. The time now is 04:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"