Glory! You solved the problem!
Thank you so very much!
Peterbody,div,table,thead,tbody,tfoot,tr,th,td,p { font-family:"Arial";
font-size:x-small }
a.comment-indicator:hover + comment { background:#ffd;
position:absolute; display:block; border:1px solid black; padding:0.5em; }
a.comment-indicator { background:red; display:inline-block;
border:1px solid black; width:0.5em; height:0.5em; }
comment { display:none; }From:Brian
Barker [mailto:[email protected]]
Subject:[libreoffice-users] Adding a / (forward slash)
Date:Saturday,
April 4, 2020, 8:45 AM
To:[email protected]
Cc:Peter
Dutton
At
07:50 04/04/2020 -0400, Peter Dutton wrote:Thanks- the "/" works
perfectly.Good-oh!Nothing's easy in this world.Many things are.What has been
created in the calc
sheet is the day number of the year which is followed by the
"/". In the cell beside the result is the remaining number of
days in the year. Here's an example of what I'd like to see for
this date (February 10, 2020)41 / 325In this case 325 is the remaining
number of days in the year
2020 from the date Feb. 10. The cell in which the formula used
to obtain the figure of 325 is-=365-S4+1"S4" is the cell where the day
number of the year is located
returned by the formula, as mentioned
below-=DATEDIF($Begin_Here.$E$76,R4,"d")" / "I still don't think this is the
clearest or best formula for what
you need. (And you've lost the ampersand, though I suspect that's
a "feature" of your mail system.)What happens to the remaining days
number in cell S4 the dreaded error - #VALUE! is returned. I
suspect this has something to do with the formatting of the cell
but can't figure it out.It's nothing to do with formatting: it's to do
with, er, values.
It's hardly surprising, since - as I made clear - what you have
now put in S4 is not the number 41 but the *string* "41 / ", and
that is not a number. You cannot calculate with strings (unless
they happen to represent numbers in a simple way). What do you
expect if you try to divide "three" by "two"? "one point five"?!Any
ideas?Yes. Take the concatenated slash off your formula so that it
creates the number 41 in S4, as before. Then use=S4" / "366-S4for your
result.I trust this helps.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
