# Populate Desired % from number entered.

1. ## 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. ## 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. ## Re: Populate Desired % from number entered.

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

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

5. ## 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. ## Re: Populate Desired % from number entered.

Originally Posted by NickyC
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%]

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.

7. ## 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. ## 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. ## 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!

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

#### 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