Asked by carl chew
on 11 Mar 2013

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.*

Answer by Andrei Bobrov
on 11 Mar 2013

Edited by Andrei Bobrov
on 11 Mar 2013

Accepted answer

x = randi([137,149],10,1);

out = round(x/5)*5;

ADD

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);

Opportunities for recent engineering grads.

## 0 Comments