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 réponse

Réponse 1 / 1
diablo13800 Posted messages 3469 Registration date   Status Membre 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
Mika
 
Thank you for responding so quickly, however, when trying your formula, it does not work.
0
diablo13800 Posted messages 3469 Registration date   Status Membre 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
Mika
 
Désolé, je ne peux pas accéder aux liens. Veuillez fournir le texte à traduire.
0
diablo13800 Posted messages 3469 Registration date   Status Membre 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
Mika
 
Great!!! Thank you so much, it works perfectly!
0