incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andreas S├Ąger <>
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:
For additional commands, e-mail:

View raw message