Forum Discussion

majko98's avatar
majko98
Copper Contributor
Apr 24, 2020

Comparing values with condition

Hello

 

Please, Could anybody help me with this? please

 Thank you!

excel

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Apr 24, 2020

    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. 

Resources