Jun 28 2021 02:26 PM
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:
1 - 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
Jun 28 2021 02:36 PM
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% ?
Jun 28 2021 02:38 PM
Jun 28 2021 02:39 PM
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%
Jun 28 2021 02:41 PM
Jun 28 2021 02:49 PM