openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian Barker <>
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:
To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message