You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Hannes <ha...@sacramentospur.co.za> on 2014/05/26 17:56:29 UTC
Calc fuctions
Hi guys
My “sum” etc calc functions are’nt working. If you want to , for example , add the values of say column A1 to A5 , it just says “=A1:A5” , but does’nt do the culculation ?
Kind regards
HANNES ROOS (Owner/Operator) SACRAMENTO SPUR
C/o Heinrich & Madelief ave, Karenpark , Pretoria-North, Tel: 012-5492274/5 • Fax:012-549-2276
• Cell: 0823263122 • Email:hannes@sacramentospur.co.za
Postal Address: P.O. Box 58756,Karenpark,0118,Pretoria
---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com
Re: Calc fuctions
Posted by Richard Detwiler <RL...@aol.com>.
Johnny Rosenberg wrote:
> 2014-05-26 17:56 GMT+02:00 Hannes <ha...@sacramentospur.co.za>:
>
>> Hi guys
>>
>> My “sum” etc calc functions are’nt working. If you want to , for example ,
>> add the values of say column A1 to A5 , it just says “=A1:A5” , but does’nt
>> do the culculation ?
>>
>> Kind regards
>>
> You said that your ”sum” function doesn't work, but how do you know? As far
> as I can see, you don't use it…
>
> This is how to use the SUM function for A1:A5:
> =SUM(A1:A5)
>
> If it now displays the formula rather than the result, check ”Tools →
> Options” for something like ”show formulas” and uncheck it.
>
>
> Johnny Rosenberg
>
>
Correct, typing "=a1:a5" is NOT the same as "=SUM(a1:a5)".
If this doesn't help, then the next question is whether other formulas
display the formula or the value? If they also display the formula, then
go to this menu path:
Tools > Options > Calc > View
Then under "Display", see if "Formulas" is selected (checked) or not. If
it is selected, than that's your problem -- just un-check the check box.
If it is not selected, then I'm at a loss as to what's going on, but
probably someone else on this list can offer a good suggestion.
-------------------------------------------
List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Calc fuctions
Posted by Johnny Rosenberg <gu...@gmail.com>.
2014-05-26 17:56 GMT+02:00 Hannes <ha...@sacramentospur.co.za>:
> Hi guys
>
> My “sum” etc calc functions are’nt working. If you want to , for example ,
> add the values of say column A1 to A5 , it just says “=A1:A5” , but does’nt
> do the culculation ?
>
> Kind regards
>
You said that your ”sum” function doesn't work, but how do you know? As far
as I can see, you don't use it…
This is how to use the SUM function for A1:A5:
=SUM(A1:A5)
If it now displays the formula rather than the result, check ”Tools →
Options” for something like ”show formulas” and uncheck it.
Johnny Rosenberg
>
> HANNES ROOS (Owner/Operator) SACRAMENTO SPUR
> C/o Heinrich & Madelief ave, Karenpark , Pretoria-North, Tel: 012-5492274/5
> • Fax:012-549-2276
> • Cell: 0823263122 • Email:hannes@sacramentospur.co.za
> Postal Address: P.O. Box 58756,Karenpark,0118,Pretoria
>
> ---
> This email is free from viruses and malware because avast! Antivirus
> protection is active.
> http://www.avast.com
>