J10= 1000
K20=40
P40=54
Only look J10,K20,P40 cells ignore everything in the sheet
Divide J10 by K20
Multiply the first result with P40
And multiply the second result by 2
and paste the third result in G20
Example
Divide J10/K20
1000/40
=25(result1)
Multply the result with P40
25*54
=1350(result2)
Multiply the result by 2
1350*2
=2700(result3)
I need result 3 in G20
2700 in G20
I need vba to do the same
So plz have a look Sir/Mam
Bookmarks