OpenOffice forumla

[Whisp3r]

Hello fellow nerds!

I'm trying to get OpenOffice to take two numbers in different cells, and determine the percentage of one from the other (10 of 100 is 10%). But I can't seem to get them to divide for some reason. Is there a trick to this?

[nateperson]

Say, A1 has 10 and B1 has 100. If you want C1 to show 10%, you input in C1 =(A1/B1)
which will give you .1 as a result. You then change the format of the cell to percentage and 10% will show.

[hubie]

It would help to know what formula you are using, and what result you are getting. When you say you can't get them to divide, does that mean you are getting some kind of error (like "divide by zero")?

[cb951303]

.