On Sat, Aug 9, 2014 at 9:03 PM, Alan B <[email protected]> wrote: > On Sat, Aug 9, 2014 at 9:29 PM, Wade Smart <[email protected]> wrote: >> >> Im working on a sheet that has numbers for a sports club. >> At the moment we use two columns and at the end of >> the columns of data, we calculate values in one column >> leaving another empty. >> >> What I would like to do is move to a single column design. >> >> What I would like to do is: >> B3=3,7 >> B4=0,10 >> B5=1,2 >> >> How would I access the first or second value a pair value? > > > Wade, I believe you will be stuck with messy formulas if you move to a > single cell. Once you put 3,7 into a cell it is now treated as text, not a > number. So to use in a number formula it must be converted to a number. > > Since you will use a comma to separate your numbers you have a reliable > separator to pick out the first or second number. > > A formula to get the fist number from B3 would be > =VALUE( MID(B3,1,SEARCH(",",B3)-1)) > The above formula will give you the number 3 which you can then use in your > other calculations. > > A formula for the second number would be > =VALUE(RIGHT(B3,LEN(B12)-FIND(",",B3))) > It will you the number 7 which again can be used in your other formulas. > > Others may suggest better formulas. I think most will recommend a different > spreadsheet design.
I was afraid of that. Ok.. it was just something I was working on. I can stick with two columns until I find a better way. Thanks :D -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
