View original (French)

Excel: If Less Than and Greater Than or Equal

Solved
lagodille Posted messages 99 Status Membre -  
 mon speudo et cricri 59 -
Hello,

I have a small issue with a function:

I have IF(A11=1,2,IF(B11=12,5))

but I would like it to be 12<B11<=14 and I can't manage to do it

If someone can help me
thanksConfiguration: Windows XP
Internet Explorer 6.0

9 réponses

Réponse 1 / 9
aquarelle Posted messages 7182 Registration date   Status Modérateur Last intervention   1 311
 
Good evening,
Here's a formula that could help you; it outputs 5 if 12<B11<=14, otherwise it writes 0, to be adjusted depending on what it should do if the condition is false: 
=IF(AND(B11<=14;B11>12),5,0)

Have a good evening
--

"To find a solution to his problems, one must put in the effort."
59
lagodille Posted messages 99 Status Membre 4
 
That's what I thought. I had considered this function, but it didn't work. So I think that in my complete formula, I am using 8 formulas, and adding an AND makes it 9 conditions, and I find myself stuck.

Is there a workaround for 9 to 10 conditions?
Here’s what I need:
in cell B11
=IF(A1=0,0,IF(A1=1,0.25,IF(A1=2,0.5,IF(A1=3,0.75,IF(A1=9,1,IF(A1=10,1,IF(A1=11,1,IF(AND(A1<=14,A1>11),5,"NULL")))))))

Thanks, aquarelle.
0
gildautal Posted messages 16 Status Membre 3
 
At first glance, it works and I am perfectly satisfied, I will try to understand later.

Thank you again Aquarelle for your valuable help.

Have a good evening.
3