Percentage Difficulties

[tearfulkarma]

Hi, hopefully someone can help me again. Maybe i can explain it first time this time.

I want to put a formula in to find the percentage.
E.G.

Cell B18 has a formula of =sum(b2:b11)
Cell B20 has a formula of =sum(I2:O2)
Cell B22 is where i want the answer. I would like it to show the percentage of a calculation between b18 and b20.
For example. If b18 has an answer of 269 and B20 has an answer of 134.5 then i want B22 to show 50%.

Hopefully this explains it enough for some help.

[etaf]

b20/b18
and format the cell as percent

[Harribone]

You want to put into B22 =B20/B18 to get your answer.

This should then show 0.5 as the answer which is the decimal equivilant of 50%. Select the cell and format it as a percentage so it displays the value as you expect.

[tearfulkarma]

So simple. Thanks guys.