View original (French)

Excel formula if between x and y

Solved
Clairettededi -  
 Ben -
Hello,

I'm having difficulty using the IF formula in Excel 2003. Specifically, I would like to apply: if age is between 12 and 16 = fee of 255, if age is between 6 and 11 = fee of 133, and if age is under 5 = fee of 0.

I tried to apply the following formula: =IF((12>=J21<=16),255,IF((6>=J21<=11),131,0)) knowing that J21 is the child's age, but I'm not getting any result. Can you help me please?

Thanks in advance

Configuration: Windows XP / Internet Explorer 8.0

1 réponse

Réponse 1 / 1
Ricky38 Posted messages 5776 Registration date   Status Contributeur Last intervention   1 463
 
Hi,

=IF(J21="","",IF(J21<6,0,IF(J21<12,133,IF(J21<=16,255,""))))
--
Every problem has a solution... you just have to be persistent.
19
Clairettededi
 
Thank you very much for this solution.
0
Timiii
 
Is it possible to use the same formula for 8 values? I tried to modify this one but it doesn't work.
0
via55
 
It's better to use VLOOKUP for multiple values
For example:
Let’s say the 2 columns are
A B
0 rate 1
5 rate 2
10 rate 3
etc
in A the limits of the age ranges and in B the corresponding rates
If in C1 we enter an age, for example 6, with in C2 the following formula
VLOOKUP(C1, A1:B4, 2, TRUE) where A1:B24 is the range where to find the data
C2 will then display rate 2.
0
Ben
 
Thank you
0