[Solved] #NAME? error in Spreadhsheet

[06honda]

I have been using Open Office for tracking my stock holdings and it has worked quite good until recently. I added a stock holding recently purchased and entered the Forumlas as per the rest of course using the correct number for the line its on. I have this error in one box only: #NAME? see screen grab and one of a different spreadsheet where it works.

1. 2nd Spreadsheet where forumula works 2. Spreadsheet where forumula gives error #NAME?

[John_Ha]

What formula do you have in O14?

It should be

Code: Select all

=SUM(O1:O13)

Search Help with NAME to discover a description of the error.

Showing that a problem has been solved helps others searching so, if your problem is now solved, please view your first post in this thread and click the Edit button (top right in the post) and add [Solved] in front of the subject.

[MrProgrammer]

Hi, and welcome to the forum.

I have this error in one box only: #NAME?

Your formula in O14 is =IF(«SomeTest»;«ValueIfTrue»;«ValueIfFalse») where «ValueIfFalse» is the term error. But error is not defined in that spreadsheet, so you receive a #NAME? message in the cell. Do you perhaps want "error" with quotes instead of error? Be sure to use double quotes and not single quotes. If you want to use error (no quotes) you must define the term using Insert → Names → Define before you can use it.

For any further assistance, attach a document demonstrating the difficulty (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the document itself). Do this whether your question is about the spreadsheet with the #NAME? error or if it is about the one without the #NAME? error. Attach the spreadsheet (or both) about which you are asking. It will help you get your problem solved more quickly than a picure will.

Edit: Thank you for the attachment below. After looking at it, I see that your formula in O10 should be =C10+F10+H10+L10, not =SUM(C10+F10+I10+L10). Skipping H10 is wrong, and you don't need to use SUM() since you are adding with the plus signs thus there only a single term, that total between the parentheses, for the function to sum. Your use of the unquoted error term in O14 is still incorrect though. You can just add quotes around it, but it would be better to describe exactly what needs attention, perhaps "Row totals do not equal column totals".

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know
[Tutorial] Mac FAQ

[06honda]

What formula do you have in O14?

It should be

Code: Select all

=SUM(O1:O13)

Formula in O14 is =IF(SUM(O5:O13)=SUM(C14:N14);SUM(O5:O13);error)

[06honda]

See attached spreadsheets. Error is on 2nd sheet called: Non-Reg Account Dividends 2020

[RusselB]

The last term in your IF statement is stipulated as error
Since error is not enclosed in quotation marks ("), Calc looks for a function named error.
Since error isn't a built-in function or, in this case, a custom coded function, Calc doesn't find a function called error, thus it reports back an error message that stipulates that the function name can't be found.
The easiest method is to put the word error (which is the last term in the IF statement) into quotation marks, making the code

Code: Select all

=IF(SUM(O5:O13)=SUM(C14:N14);SUM(O5:O13);"error")

[06honda]

Wasn't able to figure it out but thanks for all you help.