New Posts For Thread: Open Office Helphttps://community.betfair.com/general_betting/go/thread/view/94082/23532066/open-office-helpRocket 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?that's very true lori and a good mind set to have.https://community.betfair.com/general_betting/go/thread/view/94082/23532066/open-office-help?post_id=420830434#420830434that's very true lori and a good mind set to have.Wed, 17 Mar 2010 06:22:23 -0500The 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 quicklyIf you needed a column to add numbers togehttps://community.betfair.com/general_betting/go/thread/view/94082/23532066/open-office-help?post_id=420830430#420830430The 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 quicklyIf you needed a column to add numbers togeWed, 17 Mar 2010 06:12:23 -0500cheers guys, finally got it working. only taken me 80 minutes :Dhttps://community.betfair.com/general_betting/go/thread/view/94082/23532066/open-office-help?post_id=420830426#420830426cheers guys, finally got it working. only taken me 80 minutes :DWed, 17 Mar 2010 05:54:00 -0500Do as starfish says, ignore mehttps://community.betfair.com/general_betting/go/thread/view/94082/23532066/open-office-help?post_id=420830418#420830418Do as starfish says, ignore meWed, 17 Mar 2010 05:40:44 -0500In excel you would put (in the top box of column C) =(b2/a2)*100 and then copy/paste it down the whole columnI know open office isn't the same, but I suspect it is for simpler functions like this one.https://community.betfair.com/general_betting/go/thread/view/94082/23532066/open-office-help?post_id=420830414#420830414In excel you would put (in the top box of column C) =(b2/a2)*100 and then copy/paste it down the whole columnI know open office isn't the same, but I suspect it is for simpler functions like this one.Wed, 17 Mar 2010 05:40:15 -0500* =b1/a1https://community.betfair.com/general_betting/go/thread/view/94082/23532066/open-office-help?post_id=420830410#420830410* =b1/a1Wed, 17 Mar 2010 05:40:11 -0500In column C, right click and choose format cells, then click percentage.Adjust decimal places as you wishThen in C1 enter =a1/b1https://community.betfair.com/general_betting/go/thread/view/94082/23532066/open-office-help?post_id=420830406#420830406In column C, right click and choose format cells, then click percentage.Adjust decimal places as you wishThen in C1 enter =a1/b1Wed, 17 Mar 2010 05:39:45 -0500Rocket 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?https://community.betfair.com/general_betting/go/thread/view/94082/23532066/open-office-help?post_id=420830402#420830402Rocket 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?Wed, 17 Mar 2010 05:28:04 -0500