New Contributor

# Percentages

Hello,

I have Windows 10 Pro and Excel 365.

I know the answer is a simple one, but for the life of me, I cannot wrap my mind around what it should be:

- I have one column with a list of property names, which are cells I1:I36.

2 - I have five cells in a row, which are property names (e.g., Bayside Apartments, etc.). Cells A17:E17, four of the five cells are the same as the property names in column I

3 - I have one cell that has a dollar amount of \$10,000, which is cell H17

4 - I have five cells, which are my VLOOKUP formulas. In cells A19:E19, the formula is as follows: =IF(VLOOKUP(A17,I1:I36,1)=A17,1,0) - the formula is the same for the next four cells in the row with the exception of changing A17 to B17 to C17, etc.

5 - I have one cell, which has a formula in cell H18: =SUM(A19:E19) - giving me a total of 4 (see #2 & #4 above)

6 - I have five cells in a row, which are my result cells: A18:E18 and this is where my issue lies

7 - In row A18:E18, the cells are set to a percentage, and the formula for each cell is as follows: =IF(A19=1,\$H\$17/\$H\$18,0) - changing A19 to B19 to C19, etc.

8 - The returning results in cells A18:E18 gives me 200000% and not 20%? I don't know why the result is coming up as 200000, and not 20%?

Any help to get to the result I need is greatly appreciated.

Galtin

7 Replies

# Re: Percentages

It's practically impossible to follow without the sample. Did I understand correctly that final formula, if ignore IF(),

= H17/H18 = (\$10000 / 4) = 2500 = 250000 %

and you would like to receive 25% ?

# Re: Percentages

Hello, Sergei

Yes, that is correct. I would like to see the final result show 25%. I can send you the sample if you prefer?

# Re: Percentages

You mention that H17 contains 10000 and that the formula in H18 returns 4.

So H17/H18 = 10000/4 = 2500

If you would format this as a percentage, you'd get 2500*100% = 250000%

I don't see how you could get either 200000% or 20%

# Re: Percentages

Sorry, each cell shows 250000%

# Re: Percentages

In A18:

=A19/\$H\$18

Format A18 as a percentage and fill to the right to E18.

# Re: Percentages

Better with sample file

# Re: Percentages

I believe I figured it out.
Since the \$ amount is \$10,000, I have to take the formula =IF(A19=1,((G23/F23)/10000),0)
Where A19 is 1, and G23 is \$10,000, and F23 is 4