We want to share an important update with our Betfair Community users.
Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.
Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.
To share your feedback and experience, visit: https://support.betfair.com/app/home
General Betting
There is currently 1 person viewing this thread.
17 Mar 10
10: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.
|