formula needed to multiply correct number

[Melikec]

Hello All,

I attached the example file about my problem.

I have 2 different pages;
In page 1 I have unit prices for products.
Page 2 I have a calculation page in which I have a problem..

SO I would like to choose the product in the cell C3 (PAGE2) , and if the product is "a" I want 10 (m2 price for A) will be multiplied with mē dimensions , so it will write respectively 10,20,30,40,50 in C4,C5,C6,C7,C8 (EXAMPLES in the file)

If someone could help me with this I would be glad.

Thanks,
Melike
bar??.xlsx

[samba_ravi]

C4

Please Login or Register  to view this content.

Try this and copy towards down

[Melikec]

Hey Siva

Thank you!