Re: [libreoffice-users] Calc, =left not working as expected

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