+ Reply to Thread
Results 1 to 9 of 9

Populate Desired % from number entered.

  1. #1
    Registered User
    Join Date
    01-05-2014
    Location
    Troy, MT
    MS-Off Ver
    Excel 2007
    Posts
    4

    Populate Desired % from number entered.

    PLEASE HELP with a formula: In Column B a number 1 thru 20 will be put in by the user. C olumn C will show a % number that represents number entered in B. Example 1=5%, 2=10%,10=50% all the way up to 20=100%. So if I put a 4 in column B, column C will automatically populate with 20%. Thank You in advance!

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Populate Desired % from number entered.

    welcome to the forum. say B1 contains your number, put this in C1:
    =B1*5%

    copy down & Format cells as %. or to show as blank when Column B is empty:
    =IF(B1="","",B1*5%)

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Populate Desired % from number entered.

    =B1/20, formatted as a percentage, should do the trick

  4. #4
    Registered User
    Join Date
    01-05-2014
    Location
    Troy, MT
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Populate Desired % from number entered.

    Thanks for the quick replies guys! I was not clear enough. In B1 I would place a number 1 thru 20 and C1 would provide 5% to 100% based on the number entered. Then B2 would be the same. So if I entered 4 into any B column/row then any C column row would display 20%. I am confused if this is a string formula or a table type formula. I will only be using the numbers 1 thru 20 in B1, B2, B3 etc. and 1 = 5%, 2 = 10%, 3 = 15%, 4 = 20% all the way up to all the way to 20 = 100%
    Thank You
    Last edited by Trist@n7; 01-05-2014 at 11:56 PM.

  5. #5
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Populate Desired % from number entered.

    Hi
    I don't quite understand - are you saying that, if you enter '1' in any cell in column B, all the used cells in column C would show 5% ?

  6. #6
    Registered User
    Join Date
    01-05-2014
    Location
    Troy, MT
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Populate Desired % from number entered.

    Quote Originally Posted by NickyC View Post
    Hi
    I don't quite understand - are you saying that, if you enter '1' in any cell in column B, all the used cells in column C would show 5% ?
    No sir, it would look something like this:
    [A] [B] [C]
    [1] [Offense] [Level] [% Multiplier]
    [2] [Infantry] [4] [20%]
    [3] [Pikeman] [10] [50%]
    [4] [Paladin] [18] [90%]

    Sorry this post wont let me put proper spacing in and squeezes it down. Top row is column A B C with each row under lining up behind 1 2 3

    In column B my numbers change cause of leveling up and I want to be able to just enter a number in column B (1-20) and have column C automatically populate with the correct percent that is then used in another formula already working properly. Each increased number in column B = 5% with 20 being 100%. Hope this helps. Thank you for trying to help with my limited info above.
    Last edited by Trist@n7; 01-06-2014 at 01:21 PM.

  7. #7
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Populate Desired % from number entered.

    so, if you enter the formula

    =B1/20

    in cell C1, and copy this formula down into cells C2:C4, does that not give you wat you need?

  8. #8
    Registered User
    Join Date
    01-05-2014
    Location
    Troy, MT
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Populate Desired % from number entered.

    OMG...I feel so frigging stupid!!! THANK YOU Nicky!!! I am rather embarrassed that what I thought would be a string type formula is nothing but simple arithmetic.

  9. #9
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Populate Desired % from number entered.

    not to worry - one of the reasons I like this forum is that other people come up with simple solutions to what I thought were complicated problems!

+ 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. Formula needed to populate associate name when ID number entered in another cell
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-20-2013, 12:06 AM
  2. [SOLVED] Returning desired number on conditions
    By Montoro22 in forum Excel General
    Replies: 15
    Last Post: 08-02-2012, 02:25 PM
  3. [SOLVED] To find any 4 digit number and return the same number with desired formating effect.
    By neo4u44 in forum Word Programming / VBA / Macros
    Replies: 3
    Last Post: 04-24-2012, 12:45 AM
  4. Replies: 5
    Last Post: 12-08-2008, 04:01 PM
  5. Replies: 1
    Last Post: 04-08-2006, 01:20 AM

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