checking excel cell values using matlab

hai i am Dhandapani. i used the following code to check the excel value. it should say true because the exact value in the partucular cell is '0.43916'. i even used xlsread to find . it displayed '0.4392'. i even changed the search valueto '0.4392' but the answer is 'no'. but when i checked for whole numbers like '45' it says 'yes'. kindly help in this regard. the code is as follows. after this i have to check for 5 cell values of excel for a pattern match. is this possible in matlab? Thanks in advance if xlsread('realsys1.xls', 'Sheet1', 'a1:a1') == 0.43916 display 'yes' else display 'no' end

[kowshik Thopalli]

This looks like a format problem. Use

    format long

Will that solve your problem. The general recommendation to check float numbers a1 and a2 is that to not use directly a1==a2 but to use

    abs(a1-a2)<epsilon.

where epsilon is a very small value like 0.001 or something similar.

[Image Analyst]

Make this an answer below, in the answer section along with the other answers, not a comment.

Answer 1

[Image Analyst]

Not surprising. It won't be to you either, after you read the FAQ: http://matlab.wikia.com/wiki/FAQ#Why_is_0.3_-_0.2_-_0.1_.28or_similar.29_not_equal_to_zero.3F

[Dhandapani.S]

thank you. again, when given a value,how can i find in which Excel cell it is present, using matlab

[Dhandapani.S]

to be clear, i need to get a number(say 23.5444)as input using matlab and find in which row of an excel file, the number exists.

[Image Analyst]

Did you try the code in the FAQ I referred you to? See where it says to look within a tolerance? If you have a new version of MATLAB, you can use ismembertol().