View original (French)

Frame a cell between two numbers

Solved
Chloé-Guichar -  
Hello,
I have a number, for example 2 days. I want the formula to display 1 if it's between 1 and 3 days and 0 if it’s not. I tried using the function =IF(0<a1 but="" it="" doesn="" work="" />I can't seem to find a solution!! Does anyone have a solution?
Thanks in advance.

2 answers

  1.  Vaucluse Contributor
    Hello

    =IF(AND(A1>=1;A1<=3);1;0)

    best regards

    --
    To err is human, to persist is diabolical
    2
    1. Chloé-Guichar Author
      It works! Thank you very much!! Actually, it was really simple! Thanks again! :)
      0
      1. Vaucluse Contributor
        No problem. Safe travels. Looking forward to it
        I’m marking the topic as resolved
        Best regards
        0