I am using excel and matlab together. I have a gui interface. One text edit box is used to input any number desired. I would like to take that number and round it to the nearest value that is in my excel spreadsheet. For example, if I input the number 148 and my excel sheet has values 140, 155, 161. I want matlab to round to the nearest value in excel.
No products are associated with this question.
x = randi([137,149],10,1);
out = round(x/5)*5;
s = xlsread('yourfile.xlsx'); % data from Excel -> [140;155;166] x = randi([136,166],10,1); %let this is your data
[~,ii] = min(bsxfun(@(x,y)abs(x-y),s(:).',x(:)),,2); out = s(ii);
Play games and win prizes!Learn more