View original (French)

IF formula with multiple ranges

Solved
Mika -  
 Mika -
Hello,

I'm working on a table where I want to display different results in a cell based on intervals...
Basically, if A1 is less than 10, then I multiply the result by 65%, if A1 is in the range of 11 to 20, then I multiply by 80%, and finally, if A1 is greater than or equal to 21, then I multiply by 88%.

Depending on the value of A1, I want my cell to automatically calculate the percentage...

Could someone please help me?
Thank you in advance

Configuration: Windows / Opera Next 57.0.3098.116

1 answer

  1.
    diablo13800 Posted messages 3469 Registration date   Status Member Last intervention   1 872
     
    Hello,

    Just nest the different IFs:
    - =IF(A1<10,B1*0.65,IF(A1<20,B1*0.80,B1*0.88))

    With B1 being the result to multiply.

    --
    To conquer without peril is to triumph without glory.
    Pierre Corneille, Le Cid
    1
    1. Mika
       
      Thank you for responding so quickly, however, when trying your formula, it does not work.
      0
    2. diablo13800 Posted messages 3469 Registration date   Status Member Last intervention   1 872
       
      The formula works for me...

      It would be helpful to know where your different values (to multiply and others) are so that I can do better.

      If you wish, you can send me your file via this site:
      https://www.cjoint.com/

      and paste the link in your reply.
      0
    3. Mika
       
      Désolé, je ne peux pas accéder aux liens. Veuillez fournir le texte à traduire.
      0
    4. diablo13800 Posted messages 3469 Registration date   Status Member Last intervention   1 872
       
      Hello,

      You didn't really follow what I told you as a formula :)

      Here is your corrected formula:
      =IF(A2<=59000,A2*0.65,IF(A2<=149000,A2*0.8,A2*0.88))
      0
    5. Mika
       
      Great!!! Thank you so much, it works perfectly!
      0