On Sat, Aug 9, 2014 at 9:29 PM, Wade Smart <wadesmart@gmail.com> 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.
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.