Doing multiple additions, summing results and timesing by other values in a single cell

[Cris4py]

This must be so simple but I have struggled with this sort of thing for so long now and would appreciate any help you can give me.

What I am trying to do is, times a field by a percentage and the add them together { Sum(A1*B1)+A1 } and then times the result by another cell, which is another percentage, and then add that to the sum of the first to get a total in a single cell. If I was writing it I would write it something like this;

A1 B1 B1 B2 A2 (end total)
£0.061 x 6.6% + £0.061 = £0.065 x 2% + £0.065 = £0.066

Really appreciate any help you can give me as I'm sure you should be able to do this in a single cell and not have to do this over 2 or 3.

Thanks

 

[mse330]

Is this what you're after ?

=(0.061*(6.6%+1))*(2%+1)

 

[Cris4py]

Thanks but not quite, was the way I was describing it..

I have a cost price that I need to times by a fixed cost percentage and then add a profit percentage to the sum of the cost price plus the fixed cost price, to it to get a cross charge cost

	A	B	C	D
1		6.6%	2%
2	Cost Price	Fixed Cost	Profit	Cross Charge
3	£0.061	£0.004	£0.001	£0.066
4		=Sum(A3*B1)	=Sum(A3:B3)*C1	=Sum(A3:C3)

 

[gaz_chops]

If you just want the Cross Charge, try

=A3*(1+B1)*(1+C1)

 

[mse330]

Doesn't the formula in cell E2 in the below example gives what you're trying to acheive ?

Book1
	A	B	C	D	E
1		6.60%	2.00%
2	Cost Price	Fixed Cost	Profit	Cross Charge
3	0.061	0.004	0.001	0.066	0.066
4		0.004026	0.0013	0.066
Sheet1

Cell Formulas
Range	Formula
E3	E3	=(A3*($B$1+1))*($C$1+1)
B4	B4	=SUM(A3*B1)
C4	C4	=SUM(A3:B3)*C1
D4	D4	=SUM(A3:C3)

 

[Cris4py]

Yes it Does.

I was confused by the +1 part and linked it back to the cell ref. When you do this, does it mean add it to the previous value in the formula?

Thanks for your help

 

[gaz_chops]

The +1 adds 100% to the % in row 1, so 6.60% becomes 106.60%