Comparing values with condition

%3CLINGO-SUB%20id%3D%22lingo-sub-1335220%22%20slang%3D%22en-US%22%3EComparing%20values%20with%20condition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1335220%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%2C%20Could%20anybody%20help%20me%20with%20this%3F%20please%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22example.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F186446i86E161FB3E0450BE%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22example.png%22%20alt%3D%22example.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1335220%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1335442%22%20slang%3D%22en-US%22%3ERe%3A%20Comparing%20values%20with%20condition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1335442%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F635427%22%20target%3D%22_blank%22%3E%40majko98%3C%2FA%3E%26nbsp%3BMay%20I%20suggest%20one%20small%20adjustment%20to%20your%20schedule%20as%20it's%20more%20difficult%20to%20calculate%20with%20a%20text%20like%20%221-9%22%20than%20with%20numbers.%20Split%20what%20you%20have%20in%20D%20into%20two%20elements.%20One%20column%20for%20the%20lower%20limit%20and%20another%20for%20the%20upper%20limit.%20Then%20your%20formula%20could%20be%20like%20this%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DIF(AND(B2%3DC2%2CA2%26gt%3B%3DD2%2CA2%26lt%3B%3DE2)%2C%22Okay%22%2C%22wrong%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EPlease%20see%20attached%20workbook%20for%20an%20example.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hello

 

Please, Could anybody help me with this? please

example.png

 Thank you!

1 Reply

@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.