At 09:04 12/07/2018 -0400, Carl Winerich wrote:
Existing cell (for the month of February) has the following formula;
=$G30-$H30+$D32+$E32+COLUMN(A5)
That stuff points to various parts of the spreadsheet and returns
the correct numeric day number of the month. When I try to concat it
with, say, =DAYS then Err:510 appears in the cell.
I'm not surprised: you concatenate references or expressions in a
formula, not multiple formulae. What's that extra equals sign doing
there? That's like writing =A1+=B2 instead of =A1+B2.
Any ideas?
Yes: excise that superfluous equals sign.
Brian Barker
--
To unsubscribe e-mail to: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
