openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian Barker <b.m.bar...@btinternet.com>
Subject Re: Calc Formula Question
Date Tue, 08 Apr 2014 18:26:21 GMT
At 11:02 08/04/2014 -0500, Don Daugherty wrote:
>On 4/7/2014 10:27 AM, J Apples wrote:
>>When I enter a formula , and get #NAME? for the result, did I do 
>>something wrong?
>
>Maybe the problem is that you simply need to start the formula with 
>an equal sign, e.g., =IF(A1=B75,"OK";"Not OK").  Just a guess.

Surely not, in fact?  A formula without its leading equals sign is 
just a text string - a literal value which displays in the cell but 
has no effect as the formula it looks somewhat like.

Brian Barker 


-------------------------------------------
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


Mime
View raw message