+ Reply to Thread
Results 1 to 8 of 8

Calculate By a Vba Macro

  1. #1
    Registered User
    Join Date
    08-18-2019
    Location
    mumbai
    MS-Off Ver
    2013
    Posts
    2

    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. #2
    Valued Forum Contributor
    Join Date
    06-27-2010
    Location
    sYRIA
    MS-Off Ver
    Excel 2013
    Posts
    525

    Re: Calculate By a Vba Macro

    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    4,496

    Re: Calculate By a Vba Macro

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

  4. #4
    Valued Forum Contributor
    Join Date
    06-27-2010
    Location
    sYRIA
    MS-Off Ver
    Excel 2013
    Posts
    525

    Re: Calculate By a Vba Macro

    Or
    Please Login or Register  to view this content.

    Or
    Please Login or Register  to view this content.
    Last edited by mohadin; 08-18-2019 at 02:41 AM.

  5. #5
    Valued Forum Contributor
    Join Date
    06-27-2010
    Location
    sYRIA
    MS-Off Ver
    Excel 2013
    Posts
    525

    Re: Calculate By a Vba Macro

    Or even
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    08-18-2019
    Location
    mumbai
    MS-Off Ver
    2013
    Posts
    2

    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

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    59,035

    Re: Calculate By a Vba Macro

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  8. #8
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2010, 2019
    Posts
    2,183

    Re: Calculate By a Vba Macro

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to Automatically Calculate a New Row?
    By raeinla in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-18-2016, 04:56 PM
  2. Macro to calculate the average
    By ediman16 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-23-2015, 03:40 AM
  3. Macro to calculate a cell before this macro is run
    By juliettelam in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2014, 09:39 AM
  4. Macro to Calculate Percent
    By foxy_420 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2012, 06:29 PM
  5. Macro to calculate what percentile a value is in
    By Toneranger in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-16-2011, 03:20 AM
  6. calculate the mean value in macro
    By Emelie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-17-2008, 10:44 AM
  7. Calculate Now F9 Unavailable after macro run
    By Ray Hooper in forum Excel General
    Replies: 6
    Last Post: 08-04-2005, 04:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1