can i get a program for this excel file..?

here i am having so many values in the excel file.Now, in that column it should check each value with following values:

a) 0<=power>=56, the value should multiply with the 0.925 that means power*0.925.

a) 57<=power>=112, the value should multiply with the 0.925 that means power*0.952.

a) 113<=power>=168, the value should multiply with the 0.925 that means power*0.958.

a) 169<=power>=225, the value should multiply with the 0.925 that means power*0.959.

Similarly, i need to get the all values in that column should be check.

Answer 1

[Walter Roberson]

powerfactor = [0.925, 0.952, 0.958, 0.959]);
[count, binnum] = histc(power, [-inf, 57, 113, 169, inf]);
adjpower = power .* powerfactor(binnum);

Note: you have not defined what should happen between 56 and 57, or between 112 and 113, and so on. And you have not defined what should happen for below 0 or above 225.

[nani kalyan]

Error in .^ (line 8) [count, binnum] = histc(power, [-inf, 57, 113, 169, inf]);

Note: i have attached the excel file in that i have the max. value is 225 and the minimum values is 0. so, no need to find the below values.