Calculate By a Vba Macro

1. Calculate By a Vba Macro

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

2. Re: Calculate By a Vba Macro

``Please Login or Register  to view this content.``

3. Re: Calculate By a Vba Macro

``Please Login or Register  to view this content.``
Or
``Please Login or Register  to view this content.``

4. Re: Calculate By a Vba Macro

Or
``Please Login or Register  to view this content.``

Or
``Please Login or Register  to view this content.``

5. Re: Calculate By a Vba Macro

Or even
``Please Login or Register  to view this content.``

6. Re: Calculate By a Vba Macro

Thnx Sir and Mam for giving ur precious time and great support to this post
Thnx Alot and Have a Great Day

8. Re: Calculate By a Vba Macro

Or, because the ranges are fixed, even this...
``Please Login or Register  to view this content.``

There are currently 1 users browsing this thread. (0 members and 1 guests)