At 07:51 31/08/2014 -0700, Graham Lovatt wrote:
Could someone tell me what's going on in the spreadsheet i uploaded
[...]
Altering the original sheets as little as possible i used =LEFT(cell
ref,1) This seemed to work, except the values returned aren't seen
by vlookup and can not be summed (but can be added) and don't work
in a graph. Maybe its something to do with text rather than number values?
Exactly so.
Any suggestions
Either:
use =VALUE(LEFT(B3;1)) in place of =LEFT(B3;1) - and probably format
the cells suitably
or:
use =SUM(VALUE(C3:C9)) instead of =SUM(C3:C9). But this needs to be
an array formula, so you need to use Ctrl+Shift+Enter to complete it
instead of plain Enter. The formula will appear in the Input Line
with braces: {=SUM(VALUE(C3:C9))} - but you cannot type those braces yourself.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
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
Context
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.