find result from multiple if and range value

1 view (last 30 days)
hello, can someone help me? i have a set of range and i need the number produced from the the range. example: if i input a value of 0.17,it will find 0.17 is in which range (in this case it is in between 0.138 to 0.205) and then it will display the number of that range category which is 6.0
0.0 To 0.068 = 7.0
0.069 To 0.137 = 6.5
0.138 To 0.205 = 6.0
0.206 To 0.274 = 5.5
0.275 To 0.342 = 5.0 .
0.343 To 0.410 = 4.5
0.411 To 0.479 = 4.0
0.480 To 0.547 = 3.5
0.548 To 0.615 = 3.0
0.616 To 0.684 = 2.5
0.685 To 0.752 = 2.0
0.753 To 0.821 = 1.5
0.822 To 0.890 = 1.0

Accepted Answer

Azzi Abdelmalek
Azzi Abdelmalek on 10 Apr 2016
Edited: Azzi Abdelmalek on 10 Apr 2016
Edit2
r=[0.0 .068 7.0
0.069 0.137 6.5
0.138 0.205 6.0]
a=0.032
b=mat2cell(r(:,1:2),ones(size(r,1),1),2)
idx=cellfun(@(x) x(1)<=a & x(2)>=a,b)
sprintf('the range of a is %0.1f',r(idx,3))
  5 Comments
Azzi Abdelmalek
Azzi Abdelmalek on 10 Apr 2016
Look again at edited answer. I think this is the good one
badrul hisham
badrul hisham on 10 Apr 2016
thank you so much for your help sir. this works perfectly now

Sign in to comment.

More Answers (1)

Andrei Bobrov
Andrei Bobrov on 10 Apr 2016
Edited: Andrei Bobrov on 10 Apr 2016
x =[ 0 7.0000
0.0690 6.5000
0.1380 6.0000
0.2060 5.5000
0.2750 5.0000
0.3430 4.5000
0.4110 4.0000
0.4800 3.5000
0.5480 3.0000
0.6160 2.5000
0.6850 2.0000
0.7530 1.5000
0.8220 1.0000];
t = 0.890;
a = rand(30,1)*t;
[~,~,bin] = histcounts(a,[x(:,1);t]);
out = x(bin,2);

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!