I wrote the following code in an attempt to remove 'NaN' from a variable but I cannot run the code. Please help
data = xlsread;('Amortization Schedule.xlsx')
for i = 1:1:308;
j = 1:1:6;
if data(i,j)= isnan(data(i,j))
data(i,j) = 0
I am trying to: firstly equate every 'NaN' to zero then I will proceed by writing other line of code to filter my data and only have values that are not zero.
I will appreciate the help in this matter.