General Betting
There is currently 1 person viewing this thread.
17 Mar 10
11:28
Joined:
Date Joined:
28 Oct 08
Rocket to the FACE 17 Mar 11:09
If i have numbers in column A and numbers in column B and want to know what % B is of A how do I go about this?
If i have numbers in column A and numbers in column B and want to know what % B is of A how do I go about this?
sort by:
Show
per page
Replies: 7
|
By:
In column C, right click and choose format cells, then click percentage.
Adjust decimal places as you wish Then in C1 enter =a1/b1 |
|
By:
* =b1/a1
|
|
By:
In excel you would put (in the top box of column C) =(b2/a2)*100 and then copy/paste it down the whole column
I know open office isn't the same, but I suspect it is for simpler functions like this one. |
|
By:
Do as starfish says, ignore me
|
|
By:
cheers guys, finally got it working. only taken me 80 minutes :D
|
|
By:
The great thing now though, is that learning excel/open office is a continual building process. You've not just got this working, but you'll be able to do similar, but slightly different things really quickly
If you needed a column to add numbers together, you'd do it in 2 mins now, not 80, and so on. |
|
By:
that's very true lori and a good mind set to have.
|