multiple sums in a formula

[Nascarnut]

Please help. I'm trying to impress my new boss by opening my big mouth
and telling him I know tons about excel. Now i'm stuck
I can't seem to get this formula to work.

TRUSS02.XLS
	C	D	E	F	G	H	I	J	K	L
1
2		BOARDFEET	LABORRATE	BURDENRATE	MATERIALPRICE	MARKUP	TOTAL
3
4		1236	60	1.60	$1,259.00	30%
5
6		INEEDTOTAKETHESUMOFD4/E4,						20.60
7		THENMULTIPLYTHATTOTALBYF4,						20.60*1.60=32.96
8		THENADDTHETWOSUMSTOGETHERANDADDG4,						20.60+32.96+1259=1312.56
9		ANDTHENMULTIPLYBYH4						1312.56*1.30=1706.33
10		THECORRECTANSWERIS$1,706.33
11
Sheet1

 

[cherria]

=(((D4/E4)*(1+F4))+G4)*(1+H4)

 

[Ivan Howard]

Here you go...

=SUM(((D4/E4)*F4)+G4+(SUM(D4/E4)))*SUM(1+H4)

 

[cherria]

Here you go...

=SUM(((D4/E4)*F4)+G4+(SUM(D4/E4)))*SUM(1+H4)

Ivan - Why do you use the SUM function in this at all?

 

[Nascarnut]

Thank You to all who helped me.
Both of your formulas worked great!!
Drinks are on me next time!!