+ 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,142

    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%)

  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. [SOLVED] Help! Formula that can Ref. hidden data & Populate Cells with desired text
    By mandamoore@gmail.com in forum Excel Formulas & Functions
    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