incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andreas S├Ąger <ville...@t-online.de>
Subject Re: #VALUE! warning in spreadsheet
Date Sat, 25 Aug 2012 12:13:13 GMT
A space is a charater just like "a", "b", "c".
="a"+"b" raises an error because + is an arithmetic operator which 
applies to numbers only. Even ="1"+"2" raises an error because you can 
not add character "1" to character "2".

So your =e1+f1 fails whenever you refer to a text value.
Try =SUM(E1;F1)
Contrary to arithmetic operators, many arithmetic functions can ignore text.


---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org


Mime
View raw message