Apr 24 2020 02:55 AM - edited Apr 24 2020 03:45 AM
Hello
Please, Could anybody help me with this? please
Thank you!
Apr 24 2020 05:06 AM
@majko98 May I suggest one small adjustment to your schedule as it's more difficult to calculate with a text like "1-9" than with numbers. Split what you have in D into two elements. One column for the lower limit and another for the upper limit. Then your formula could be like this:
=IF(AND(B2=C2,A2>=D2,A2<=E2),"Okay","wrong")
Please see attached workbook for an example.