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
