+ Reply to Thread
Results 1 to 10 of 10

Change Percentage value in a macro

  1. #1
    Forum Contributor
    Join Date
    07-16-2009
    Location
    NA
    MS-Off Ver
    MS Excel 2010
    Posts
    237

    Change Percentage value in a macro

    Hi,

    Please Login or Register  to view this content.
    This line calculates 1 % and i have to make it 0.75% so i am looking to change the value of percentage
    So plz let me know for 0.75% what i have to put instead of this 0.01 ?

    Thnx Alot

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,259

    Re: Change Percentage value in a macro

    I would think...
    0.75
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Registered User
    Join Date
    09-15-2019
    Location
    Gurgaon, India
    MS-Off Ver
    2003 2007 2010
    Posts
    8

    Re: Change Percentage value in a macro

    I would think possibly...
    .0075

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,259

    Re: Change Percentage value in a macro

    .01 = 1%
    .10 = 10%
    .75 = 75%

    Not so?

  5. #5
    Registered User
    Join Date
    09-15-2019
    Location
    Gurgaon, India
    MS-Off Ver
    2003 2007 2010
    Posts
    8

    Re: Change Percentage value in a macro

    correct , but the OP asked for .75%
    .0075 is .75%
    Last edited by DevelopmentTest; 08-19-2020 at 03:40 AM.

  6. #6
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,259

    Re: Change Percentage value in a macro

    My bad...Correct you are...

    So he is wanting .75% of 1%

  7. #7
    Registered User
    Join Date
    09-15-2019
    Location
    Gurgaon, India
    MS-Off Ver
    2003 2007 2010
    Posts
    8

    Re: Change Percentage value in a macro

    Its intersting how often this one catches people out , again and again... He is wanting 75% of 1%





    Edit: Just testing uploading/ downloading as there seems to be problems currently

    Solution11.xlsm
    Last edited by DevelopmentTest; 09-02-2020 at 07:17 AM. Reason: testing uploading/ downloading .xlsm files

  8. #8
    Forum Contributor
    Join Date
    07-16-2009
    Location
    NA
    MS-Off Ver
    MS Excel 2010
    Posts
    237

    Re: Change Percentage value in a macro

    Thnx Alot Sintek Sir & DevelopmentTest Sir for ur Great Help & Awesome conversation
    Now i learned how this percentage works
    Thnx Alot

  9. #9
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,259

    Re: Change Percentage value in a macro

    Strong with me today the force is not...lol

  10. #10
    Registered User
    Join Date
    10-05-2019
    Location
    Work: East Coast; Home: Texas, USA
    MS-Off Ver
    Mostly 2010 ( Windows 10 & 365 Insider Super Fast )
    Posts
    32

    Re: Change Percentage value in a macro

    Quote Originally Posted by Zaeguzah View Post
    ..
    Now i learned how this percentage works...
    me thinks that is quite something
    Well that is something in 2 years of duplicate cross postings of almost the same question
    Keep it up .. next decade maybe learn the difference between A B C and 1 2 3
    Last edited by MollyBrennholz; 08-20-2020 at 07:19 AM.
    Bollocks

+ 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. Replies: 1
    Last Post: 09-20-2016, 07:33 PM
  2. macro to find percentage
    By emilyloz in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 07-31-2013, 03:59 PM
  3. [SOLVED] Macro for percentage and sum for each group
    By Ucpaul in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-10-2013, 10:19 PM
  4. value corresponding chnge
    By sandy2011 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2012, 11:46 AM
  5. Macro to find specific percentage
    By adillard in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-06-2011, 01:39 PM
  6. excel macro not dividing by the right sum (percentage macro)
    By MichaelSSSS in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2010, 04:43 AM
  7. How to chnge 35 relative cells to 35 absolute cells at one time.
    By Susan A at Millennium Medical in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-07-2006, 04:20 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