prompt{1}='Enter 1st grade :';
prompt{2}='Enter 2nd grade :';
name='result';
answer=inputdlg(prompt,name);
a=xlsread('inputdata.xlsx');
excel file values are
0.1 0.1 0.1
0.1 0.2 0.1
0.1 0.3 0.1
0.1 0.4 0.2
0.1 0.5 0.2
0.1 0.6 0.2
0.1 0.7 0.3
0.1 0.8 0.3
0.2 0.1 0.1
0.2 0.2 0.2
0.2 0.3 0.2
0.2 0.4 0.2
0.2 0.5 0.3
0.2 0.6 0.3
0.2 0.7 0.3
0.2 0.8 0.4
0.3 0.1 0.1
0.3 0.2 0.2
0.3 0.3 0.2
1st grade values are in 1st column
2nd grade values are in 2nd column
if user enter values for 1st and 2nd grade, then it has to display the output. output is the corresponding 3rd column value.
for eg:
Enter 1st grade : 0.2
Enter 2nd grade :0.8
output is 0.4
please give me a solution
