Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

See also: https://ask.libreoffice.org/en/question/74901/cant-post-as-wiki-be-disabled-for-questions/
https://ask.libreoffice.org/en/question/137128/guidelines-for-asking/
https://ask.libreoffice.org/en/question/131311/why-do-i-often-get-an-error-508-504-502-eg-if-i-paste-a-calc-formula-from-some-post-into-my-sheet/

=IF(WEEKDAY(A65;2)=5 AND(A65=$A$3);$C$3;0) tries (in an inconsequent way) to treat AND as a logical operator. It isn't. There is the function AND() with a list of parameters each introducing a logical result. In addition the comparison A65=$A$3 does not comply with your explanations. It should, most likely, read A65<=$A$3.

Thus =IF(AND(WEEKDAY(A65;2)=5;A65<=$A$3);$C$3;0) should be what you need.

See also: https://ask.libreoffice.org/en/question/74901/cant-post-as-wiki-be-disabled-for-questions/
https://ask.libreoffice.org/en/question/137128/guidelines-for-asking/
https://ask.libreoffice.org/en/question/131311/why-do-i-often-get-an-error-508-504-502-eg-if-i-paste-a-calc-formula-from-some-post-into-my-sheet/

=IF(WEEKDAY(A65;2)=5 AND(A65=$A$3);$C$3;0) tries (in an inconsequent way) to treat AND as a logical operator. It isn't. There is the function AND() with a list of parameters each introducing a logical result. In addition the comparison A65=$A$3 does not comply with your explanations. It should, most likely, read A65<=$A$3.

Thus =IF(AND(WEEKDAY(A65;2)=5;A65<=$A$3);$C$3;0) should be what you need.need.

(I do not understand the usage of descending order in the context.)

See also: https://ask.libreoffice.org/en/question/74901/cant-post-as-wiki-be-disabled-for-questions/
https://ask.libreoffice.org/en/question/137128/guidelines-for-asking/
https://ask.libreoffice.org/en/question/131311/why-do-i-often-get-an-error-508-504-502-eg-if-i-paste-a-calc-formula-from-some-post-into-my-sheet/

=IF(WEEKDAY(A65;2)=5 AND(A65=$A$3);$C$3;0) tries (in an inconsequent way) to treat AND as a logical operator. It isn't. There is the function AND() with a list of parameters each introducing a logical result. In addition the comparison A65=$A$3 does not comply with your explanations. It should, most likely, read A65<=$A$3.

Thus =IF(AND(WEEKDAY(A65;2)=5;A65<=$A$3);$C$3;0) should be what you need.

(I do not understand the usage of descending order in the context.)

=IF(WEEKDAY(A65;2)=5 AND(A65=$A$3);$C$3;0) tries (in an inconsequent way) to treat AND as a logical operator. It isn't. There is the function AND() with a list of parameters each introducing a logical result. In addition the comparison A65=$A$3 does not comply with your explanations. It should, most likely, read A65<=$A$3.

Thus =IF(AND(WEEKDAY(A65;2)=5;A65<=$A$3);$C$3;0) should be what you need.

(I do not understand the usage of descending order in the context.)context.)

Edit 1 (as announced in my comment on the recent post by the OQ):
See this attached demonstration.

=IF(WEEKDAY(A65;2)=5 AND(A65=$A$3);$C$3;0) tries (in an inconsequent way) to treat AND as a logical operator. It isn't. There is the function AND() with a list of parameters each introducing a logical result. In addition the comparison A65=$A$3 does not comply with your explanations. It should, most likely, read A65<=$A$3.

Thus =IF(AND(WEEKDAY(A65;2)=5;A65<=$A$3);$C$3;0) should be what you need.

(I do not understand the usage of descending order in the context.)

Edit 1 (as (As announced in my comment on the recent post by the OQ):
See this attached demonstration.

demonstration.

Edit 2 (As announced in my second comment there. Sorry, I was distracted. Thus the delivery is late.)
Two of the probable reasons for the issue:
-1- At least some of the "dates" in the OQ's sheet are actually texts instead of standard spreadsheet-dates. -2- Some specifics of the relevant formula from my demo were not correctly adapted when moving it to the OQ's sheet. Concerning -2- I cannot do anything except to advise to perform another thorough comparison. Concerning -1- I cannot offer direct help again, but I can zeach a bit about the issue often striking beginners.

I tried to do this in a concise way commenting on the slightly different cases and solutions contained in this new attachment.

=IF(WEEKDAY(A65;2)=5 AND(A65=$A$3);$C$3;0) tries (in an inconsequent way) to treat AND as a logical operator. It isn't. There is the function AND() with a list of parameters each introducing a logical result. In addition the comparison A65=$A$3 does not comply with your explanations. It should, most likely, read A65<=$A$3.

Thus =IF(AND(WEEKDAY(A65;2)=5;A65<=$A$3);$C$3;0) should be what you need.

(I do not understand the usage of descending order in the context.)

Edit 1 (As announced in my comment on the recent post by the OQ):
See this attached demonstration.

Edit 2 (As announced in my second comment there. Sorry, I was distracted. Thus the delivery is late.)
Two of the probable reasons for the issue:
-1- At least some of the "dates" in the OQ's sheet are actually texts instead of standard spreadsheet-dates. -2- Some specifics of the relevant formula from my demo were not correctly adapted when moving it to the OQ's sheet. Concerning -2- I cannot do anything except to advise to perform another thorough comparison. Concerning -1- I cannot offer direct help again, but I can zeach teach a bit about the issue often striking beginners.

I tried to do this in a concise way commenting on the slightly different cases and solutions contained in this new attachment.