Help setting up math equation in excel

[nasams]

Hi all,

I've been using this forum for support and self learning for a long time, but this is my first time posting.
I got math problem to solve in excel and I would really appreciate if some of you could assist me in how to set this up correctly in excel....

The equations is as follows;

PA = P * (Y * L / L0 + Z * M / M0 ) – P

where:

PA =​	Price adjustment
P =​	Price (let's use 100 as an example)
Y =​	Work component of price (expressed in %)
L =​	Labour index A (let's use 50 as an example)
Lo =​	Labour index B (let's use 100 as an example)
Z =​	Material component of price (expressed in %)
M =​	Material index A (let's use 50 as an example)
Mo =​	Material index B (let's use 100 as an example)

 

[maabadi]

Welcome to MrExcel Message Board.
Please Upload one example file at excel with XL2BB addin.
IF yours data is in Column A to G respectivly (from P to M0)
I suppose your first row is row 2 . then formula is:

=A2*(B2*(C2/D2)+E2*(F2/G2))-A2

 

[mohadin]

B9=B1*(B2*B3/B4+B5*B6/B7)-B1

	A	B​	C​	D​	E​
1​	P	100​
2​	Y	5%​
3​	L	50​
4​	Lo	100​
5​	Z	10%​
6​	M	50​
7​	Mo	100​
8​
9​		-92.5	PA=
10​					PA = P * (Y *( L / L0) + Z * (M / M0) ) – P​

 

[fadee2]

try

p*(y)*(L/L0)+(z)*(M/M0)-p

 

[nasams]

Welcome to MrExcel Message Board.
Please Upload one example file at excel with XL2BB addin.
IF yours data is in Column A to G respectivly (from P to M0)
I suppose your first row is row 2 . then formula is:

=A2*(B2*(C2/D2)+E2*(F2/G2))-A2

Should of course have uploaded one example file, but thank you anyway. This did the trick

 

[maabadi]

You're welccome & thanks for feedback