Re: Calc Formula Question

2014-04-08 Thread Brian Barker
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 g

Re: Calc Formula Question

2014-04-08 Thread Don Daugherty
On 4/7/2014 10:27 AM, japples 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. --- This email is free from viruses an

Re: Calc Formula Question

2014-04-07 Thread japples
I entered an "IF" formula that produced the error. Statement of fact. Not finding an easy answer in Help (opened under OpenOffice Calc, used "Find" to search the term "#name error" with result "no topics found") - I turned to the message board (can only see messages related to my question / c

Re: Calc Formula Question

2014-04-07 Thread japples
I have NO IDEA who this "japples" is, although I do have your program and wish I had a manual to look things up From: Peter Hillier-Brook To: users@openoffice.apache.org Sent: Monday, April 7, 2014 9:38 AM Subject: Re: Calc Formula Question On 07/

Re: Calc Formula Question

2014-04-07 Thread Carol J. White
ubject: Re: Calc Formula Question On 07/04/14 16:27, japples wrote: > When I enter a formula , and get #NAME? for the result, did I do > something wrong? Yes! Did you contemplate looking it up in "Help": the fourth line from the top takes you to a comprehens

Re: Calc Formula Question

2014-04-07 Thread Peter Hillier-Brook
On 07/04/14 16:27, japples wrote: When I enter a formula , and get #NAME? for the result, did I do something wrong? Yes! Did you contemplate looking it up in "Help": the fourth line from the top takes you to a comprehensive description. Peter HB ---

Calc Formula Question

2014-04-07 Thread japples
When I enter a formula , and get #NAME? for the result, did I do something wrong?