New Posts For Thread: Can Open Office do this?https://community.betfair.com/general_betting/go/thread/view/94082/23869590/can-open-office-do-thisI need a spreadsheet that can look at the numbers in cell A1, A2 etc and then do a calculation on the second part of the number depending on how large the whole number is, and then display the answer X in a seperate cell. Like this:If 2.00, X=1.5 +(see my earlier post: Rocket to the FACE 13 Apr 15:45 =(A3/2)+0.5there we go. now i can have all three digits included. Cheers for your time though. Honestly. It's always nice to get some help from someone who owes you f*ck all. And it's always apphttps://community.betfair.com/general_betting/go/thread/view/94082/23869590/can-open-office-do-this?post_id=430332230#430332230see my earlier post: Rocket to the FACE 13 Apr 15:45 =(A3/2)+0.5there we go. now i can have all three digits included. Cheers for your time though. Honestly. It's always nice to get some help from someone who owes you f*ck all. And it's always appTue, 13 Apr 2010 17:10:27 -0500Got it now. All you need is =A1/2+.5https://community.betfair.com/general_betting/go/thread/view/94082/23869590/can-open-office-do-this?post_id=430332226#430332226Got it now. All you need is =A1/2+.5Tue, 13 Apr 2010 17:02:01 -0500but no need to blurt it either way!https://community.betfair.com/general_betting/go/thread/view/94082/23869590/can-open-office-do-this?post_id=430332222#430332222but no need to blurt it either way!Tue, 13 Apr 2010 16:49:47 -0500^ WRONG2.65 = 1.83im sure you can see what im trying to dohttps://community.betfair.com/general_betting/go/thread/view/94082/23869590/can-open-office-do-this?post_id=430332218#430332218^ WRONG2.65 = 1.83im sure you can see what im trying to doTue, 13 Apr 2010 16:48:47 -05002.65 = 1.63https://community.betfair.com/general_betting/go/thread/view/94082/23869590/can-open-office-do-this?post_id=430332214#4303322142.65 = 1.63Tue, 13 Apr 2010 16:48:05 -0500soA1 B11.99 1.5'ishhttps://community.betfair.com/general_betting/go/thread/view/94082/23869590/can-open-office-do-this?post_id=430332210#430332210soA1 B11.99 1.5'ishTue, 13 Apr 2010 16:47:34 -0500So if A1 was 2.65 what should your answer be?https://community.betfair.com/general_betting/go/thread/view/94082/23869590/can-open-office-do-this?post_id=430332206#430332206So if A1 was 2.65 what should your answer be?Tue, 13 Apr 2010 16:46:51 -0500if less than 21+(B/2)https://community.betfair.com/general_betting/go/thread/view/94082/23869590/can-open-office-do-this?post_id=430332202#430332202if less than 21+(B/2)Tue, 13 Apr 2010 16:46:46 -0500If it less than 2 do you still want to add 2? or some other number?https://community.betfair.com/general_betting/go/thread/view/94082/23869590/can-open-office-do-this?post_id=430332198#430332198If it less than 2 do you still want to add 2? or some other number?Tue, 13 Apr 2010 16:45:18 -0500^^^ but that's only correct for a value greater than 3.00https://community.betfair.com/general_betting/go/thread/view/94082/23869590/can-open-office-do-this?post_id=430332194#430332194^^^ but that's only correct for a value greater than 3.00Tue, 13 Apr 2010 16:42:47 -0500