place in cell X1 a result subject to conditions

[crinkly36]

Can someone advise me how to construct an Excel formula for purpose outlined below?

I wish to place in cell X1 a result subject to these conditions.
If Cell A1>n, or cell A! =<n and is not between clock times xx:xx:xx to yy:yy:yy, then result =A, else result =B. (n is a numerical value)

Apologies if this is in the wrong place ans with hope that my requirement is clear.

[crinkly36]

Sorry I am even more perplexed. How can I know what the formula should be, when I what advice how the formula should be constructed, configured?

As to what it should produce, I'd have thought it was in the text of the OP, but hopefully in clarification my desire is to insert in a cell in column X1 a string or numerical value according to whether
1). the value in A1 is greater than ,say,5,
or
2) if the value in A1 is less than, say,5 and the time in B1 is not in the of times in range C1:D1
If either of those conditions are true the answer will be a particular fixed string or numerical value, but if both are false then the string or numerical value that is in another column of the row.

I hope someone can now find me a solution., but if I still am failing to get my point across within the rules I ask that my forum membership and posts be expunged utterly from your records
I would hate to be unwantedly wasting your and my time here.

[crinkly36]

@teylyn. Thanks for guidance. I hope my new title works

[teylyn]

Thanks for understanding the issue and making the effort to change the title,

based on the info in this ...

1). the value in A1 is greater than ,say,5,
or
2) if the value in A1 is less than, say,5 and the time in B1 is not in the of times in range C1:D1
If either of those conditions are true the answer will be a particular fixed string or numerical value, but if both are false then the string or numerical value that is in another column of the row.

... maybe something along the lines of

=if(or(A1>=5,and(A1<5,or(B1<C1,B1>D1))),"match",E1)

If this does not help, feel free to post a workbook with a data sample, so you can explain in context. It's often easier to find a solution when we can look at the spreadsheet.

hope that helps

[crinkly36]

Thank you! I will try it later today.

[crinkly36]

Problem solved

I realised that I had made matters too complex, as dates given weekday 6 and 7 did not require testing.
That disposed of, I found this worked

Please Login or Register  to view this content.

C2.. weekday number: E2..time: F2&G2.. time limits where test applicable.

Thanks all.