Help with Formula

[mclark15]

HI All
What I want to do is take the cost price of B5 ($788) add the gst of cell P3 then add the labour amount of P5 and then add on the markup % of cell P4 & show the new amount in C5 which should be $1575.18

Price book formula.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1
2		Cost	New Price
3															GST	10%
4															Mark Up	35%
5		$ 788.00													Labour 1	300
6		$ 792.00													Labour 2	350
7		$ 821.00													Labour 3	400
8		$ 1,029.00
9		$ 1,066.00
10		$ 1,267.00
11
Sheet1

 

[Michael M]

TRy

=(B5+B5*$P$3+$P$5)*(1+$P$4)

 

[Marcelo Branco]

Maybe

C5
=(B5*(1+P$3)+P$5)*(1+P$4)

M.

 

[mclark15]

TRy

=(B5+B5*$P$3+$P$5)*(1+$P$4)

Thanks this worked