View original (French)

Use the value of x from a range in a formula

benjaminb -  
 H -
Hello,

I have been looking for a while for a solution, I am on the verge of despair; I want to validate a range written in one cell automatically in the following cell:

Let me explain, I have 20<X<80, with X being a variable value in a previous cell, so I would like, depending on the range and the value of X, a formula to automatically validate in a third cell as either conforming or not conforming.

In summary, first cell: value of X; second cell: 20 < X < 80; third cell: conforming or not conforming, if X is indeed between the two values......

Sorry in advance, it’s really difficult to describe, I hope I have been as clear as possible and haven't made it too complicated for you.

Thank you very much in advance for your help.

Best regards.

Configuration: Windows 7 / Chrome 49.0.2623.87

2 answers

  1.
    PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835
     
    Hello

    the value of X in A1

    in A2 put this formula

    =IF(AND(20<a1 compliant="" />--
    It is by forging that one becomes a blacksmith. - It is at the foot of the wall that one sees the mason - one always learns from one's mistakes
    0
    1. benjaminb
       
      Thank you very much for the prompt response, but the issue is that the brackets also change. There are 10 different brackets: 20Thank you anyway.
      Best regards.
      0
      1. PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835 > benjaminb
         
        you must test each frame separately
        with a choice of frame (see with a list of choices)
        Or all at once, so several formulas
        0
      2. benjaminb > PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention  
         
        Could we make the X of the frame dynamic so that it takes the value from the previous cell, and thus check if it fits within the frame, regardless of the said frame?
        0
    2. H
       
      X in A1
      20 in A2
      80 in A3
      =IF(AND(A2
      0
  2. PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835
     
    Hello

    An example file

    http://www.cjoint.com/c/FDhiV00FOVx

    --
    It's by forging that one becomes a blacksmith. - It's at the foot of the wall that one sees the mason - you always learn from your mistakes
    0
    1. benjaminb
       
      I will try this, thank you very much. I'm also trying to set up a VLOOKUP table, but it's not easy, I won't hide that from you.
      In any case, thanks again for your responses.
      0