+ Reply to Thread
Results 1 to 7 of 7

Multiplying with percentage having decimals not working.

  1. #1
    Forum Contributor
    Join Date
    07-29-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    110

    Multiplying with percentage having decimals not working.

    Good Day All!

    I have a code:

    Please Login or Register  to view this content.
    which supposed to calculate values from 2 textboxes where textbox1 will have an amount and textbox19 will have % value and result will go to textbox32. Thing is, sometimes textbox19 will have percentage values with decimals in it (eg. 2.1%) couldn't figure out a way that it will allow the calculation (Textbox1 * Textbox19) where textbox19 has decimals.

    Would appreciate any help

  2. #2
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Multiplying with percentage having decimals not working.

    Hi,

    Have you tried replacing
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    or
    Please Login or Register  to view this content.
    The first suggestion will convert the string to a double-type value, and the second suggestion will remove the % sign from the value.

    The reason that I am providing multiple solutions is because I haven't tested either, and it's hard to determine what will work without having your code in the correct context. If neither of these solutions work, could you please upload your workbook for me to take a look at.

    Thanks

  3. #3
    Forum Contributor
    Join Date
    07-29-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    110

    Re: Multiplying with percentage having decimals not working.

    hey ajryan88,

    Thanks for your time.

    I need the formula to multiply in percentage. Im unsure if removing "/ 100#" will work?

    As for the workbook. Its only 1 bit of a whole program Im working on so I dont think it will be efficient to upload everything in

    If it will help,

    What Im trying to do is to create a program that will allow users to divide certain dollar amount. where users will determine the percentage per division. the dollar amount varies as well.

    The code I have works with whole numbers but not with percentages with decimals.

  4. #4
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Multiplying with percentage having decimals not working.

    Sorry I wasn't suggesting to remove the "/100#", I was simply just changing only the bits that needed changing. Please give each of my previous solutions a go, and then if they fail see if you can mock up a smaller version of the same workbook that won't be too large to upload.

    Thanks again

  5. #5
    Forum Contributor
    Join Date
    07-29-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    110

    Re: Multiplying with percentage having decimals not working.

    Thank you so much for the inputs.

    it works with this

    Please Login or Register  to view this content.
    marking it as solved

  6. #6
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Multiplying with percentage having decimals not working.

    That's great news!

    Please don't forget to also add some reputation by clicking on the star next to my post to say thank you.

    Have a great night

  7. #7
    Forum Contributor
    Join Date
    07-29-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    110

    Re: Multiplying with percentage having decimals not working.

    sure thing

+ 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. [SOLVED] Working with Decimals and possibly Concatenation
    By tuoinside in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-26-2012, 04:50 PM
  2. Converting decimals of working weeks to days
    By Dermot McGrath in forum Excel General
    Replies: 7
    Last Post: 10-25-2012, 06:21 AM
  3. Countif with decimals to give a percentage..HELP!!
    By mrhogan in forum Excel General
    Replies: 10
    Last Post: 11-20-2008, 04:24 AM
  4. Convert numbers with decimals to percentage
    By Wskip49 in forum Excel General
    Replies: 2
    Last Post: 11-11-2008, 06:14 PM
  5. percentage not working right
    By winnieluvpooh in forum Excel General
    Replies: 3
    Last Post: 06-21-2005, 07:05 PM

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