Auto update funtions in excel

Dear Experts,

Please refer my attached file I have mentioned my requirement clearly and help to fulfill my requirement.


Thanks & Regard,
iqubal82

Hello Abu Dhabi
Can you explain where do you want your formula/s? Is it in cell J17? please provide some more verbal explanation.

Thanks.

Dear belinda200

I want the valuable formula for Purity section cell D11, Rate section cell H11 and Amount section J11.

Please help.

Thanks,

Hi,
D11 and down:
=IF(B11=$B$15,92.5,IF(B11=$B$16,72,IF(OR(B11=$B$14,B11=$B$13),"NK",916)))

H11 and down:
=IF(OR(D11=916,D11="NK"),4920,IF(D11=72,70,IF(D11=92.5,250)))

Do you also need a formula for "J"?

Dear belinda200

Yes I also want formula for "J"

Thanks,

What would be considered metal in your list of products on column B, and what would be considered wastage?

D11 cell formula

HTML Code: 

H11 cell formula

HTML Code: 

Dear belinda200,

The metal would be considered the estimate calculation is 2.000+0.200*4920+500 = 11324

The another wastage would be considered the estimate calculation is 2.200*10%*4920+500 = 11324

The ACPL product would be considered the estimate calculation is 10.000*250+500 = 3000

The Silver product would be considered the estimate calculation is 10.000*10%*70+500 = 1270

I want suitable formula in J11, so multi calculation result in one cell. Please refer and help.


Thanks,

Dear belinda200,

The metal would be considered the estimate calculation is 2.000+0.200*4920+500 = 11324

The another wastage would be considered the estimate calculation is 2.200*10%*4920+500 = 11324

The ACPL product would be considered the estimate calculation is 10.000*250+500 = 3000

The Silver product would be considered the estimate calculation is 10.000*10%*70+500 = 1270

I want suitable formula in J11, so multi calculation result in one cell. Please refer and help.


Thanks,

Dear wk9128,

Very excellent the formula work fine thanks.

I also want the right formula for J11 cell please help.

Thanks,