Forum Discussion
Comparing values with condition
Hello Please, Could anybody help me with this? please Thank you!
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.