View original (French)

Frame a cell between two numbers

Solved
Chloé-Guichar Posted messages 9 Status Member -  
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   -
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 Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello

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

    best regards

    --
    To err is human, to persist is diabolical
    2
  2. Chloé-Guichar Posted messages 9 Status Member
     
    It works! Thank you very much!! Actually, it was really simple! Thanks again! :)
    0
    1. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
       
      No problem. Safe travels. Looking forward to it
      I’m marking the topic as resolved
      Best regards
      0